connected_device_dimension

connectedDeviceTk

tk

date_dimension

dateTk

tk

port_dimension

portTk

tk

switch_dimension

switchTk

tk

digit

Int32

Yes

A number between 0 and 99.

tk [PK]

Int32

Yes

TK of the device.

name

String

Yes

Name of the device.

manufacturer

String

Yes

Manufacturer of the device.

model

String

Yes

Model of the device.

type

String

Yes

Type of the device.

firmware

String

Yes

Firmware version running on the device.

id

Int64

Yes

The ID of the device

latest

String

Yes

Indicates whether this row is the latest one for this device.

tk

Int32

Yes

TK of the date object.

fullDate

DateTimeOffset

Yes

Date of the date object.

dayInMonth

Byte

Yes

Day of the month for the date object. The first day of the month has value 1.

dayInYear

Int32

Yes

Day in year of the date object. The first day of the year has value 1.

dateYear

Int32

Yes

Year of the date object.

yearLabel

String

Yes

Year formatted as String

monthNum

Byte

Yes

Month of the date object. January has value 1.

monthLabel

String

Yes

Month formatted as String

dayInWeekNum

Byte

Yes

Day of the week for the date object. Sunday has value 1.

quarter

Byte

Yes

Quarter of the date object. First quarter has value 1.

quarterLabel

String

Yes

Quarter formatted as String

dayInQuarter

Int32

Yes

Day in quarter of the date object. First day of the quarter has value 1.

repQuarter

Byte

Yes

Indicates whether this date is the first date available for its quarter.

repMonth

Byte

Yes

Indicates whether this date is the first date available for its month.

repWeek

Byte

Yes

Indicates whether this date is the first date available for its week.

repDay

Byte

Yes

Indicates whether this date is the first date available for its day.

repMonthOrLatest

Byte

Yes

Indicates whether this date is the repmonth or the latest. This flag is used by Datamarts which works on monthly reps. Only difference being for the current month it is the latest

sspFlag

Byte

Yes

Indicates whether this date is used in Storage and Storage Pool Datamart. It is true for month representatives and for the last number of days as defined in configuration.

latest

String

Yes

Indicates whether this date is the last date available in the table.

future

String

Yes

Indicates whether this date is a future date (projection) or regular one.

tk

Int32

Yes

TK of this port row.

wwn

String

Yes

WWN of the port.

name

String

Yes

Name of the port.

gbicType

String

Yes

Type of GBIC (Gigabit Interface Converter) used for the port.

type

String

Yes

Port type, typically used to identify the protocol used to communicate with the other device, taken from the device itself: F-port, E-port, and so forth.

speed

String

Yes

Speed of the port, in Gbps.

isGenerated

String

Yes

Indication whether this is a generated wwn (if we do not know the real wwn).

url

String

Yes

Url to this port in Insight Server.

id

Int64

Yes

GUID of the port in dwh_inventory.switch_port.

latest

String

Yes

Indicates whether this row is the latest one for this port.

dateTk

Int32

Yes

TK of the date in which the port row was created.

tk [PK]

Int32

Yes

TK of the fact.

dateTk [FK] →date_dimension.tk

Int32

Yes

TK of the date.

switchTk [FK] →switch_dimension.tk

Int32

Yes

TK of the switch containing the port.

connectedDeviceTk [FK] →connected_device_dimension.tk

Int32

Yes

TK of the device that is connected to the port.

portTk [FK] →port_dimension.tk

Int32

Yes

TK of the port.

fabric

String

Yes

Name or WWN for the fabric (or VSAN) on which the port is configured to operate.

speed

String

Yes

Speed of the port, in Gbps.

connectivityType

String

Yes

Type of the connected device.

type

String

Yes

Port type, typically used to identify the protocol used to communicate with the other device, taken from the device itself: F-port, E-port, and so forth.

status

String

Yes

Status of the port. Possible values are OK, NOT_LICENSED, ERROR, INACTIVE and UNKNOWN

tk

Int32

Yes

TK of the fact.

dateTk

Int32

Yes

TK of the date.

switchTk

Int32

Yes

TK of the switch containing the port.

connectedDeviceTk

Int32

Yes

TK of the device that is connected to the port.

portTk

Int32

Yes

TK of the port.

fabric

String

Yes

Name or WWN for the fabric (or VSAN) on which the port is configured to operate.

speed

String

Yes

Speed of the port, in Gbps.

connectivityType

String

Yes

Type of the connected device.

type

String

Yes

Port type, typically used to identify the protocol used to communicate with the other device, taken from the device itself: F-port, E-port, and so forth.

status

String

Yes

Status of the port. Possible values are OK, NOT_LICENSED, ERROR, INACTIVE and UNKNOWN

tk

Int32

Yes

TK of this switch row.

wwn

String

Yes

WWN of the switch.

name

String

Yes

Name of the switch.

identifier

String

Yes

Identifier of the device.

ip

String

Yes

IP address of the switch.

model

String

Yes

Model of the switch.

manufacturer

String

Yes

Manufacturer of the switch.

firmware

String

Yes

Firmware version running on the switch.

serialNumber

String

Yes

Serial number of the switch.

npv

String

Yes

Indication whether this is an NPV switch.

isGenerated

String

Yes

Indication whether this switch does not correspond to a physical device. It is used to model one to many port connectivity.

type

String

Yes

Switch type.

url

String

Yes

Url to this switch in Insight Server.

id

Int64

Yes

GUID of the switch in dwh_inventory.switch.

latest

String

Yes

Indicates whether this row is the latest one for this switch.

dateTk

Int32

Yes

TK of the date in which this switch row was created.

dataCenter

String

Yes

dataCenter annotation value assigned to dwh_dimensions.switch_dimension

switchLevel

String

Yes

switchLevel annotation value assigned to dwh_dimensions.switch_dimension