compute_resource_dimension

computeResourceTk

tk

date_dimension

dateTk

tk

file_system_dimension

fsTk

tk

host_dimension

hostTk

tk

storage_dimension

storageTk

tk

tier_dimension

tierTk

tk

vm_dimension

vmTk

tk

tk

Int32

Yes

TK of this compute resource row.

identifier

String

Yes

Natural identifier of the compute resource.

name

String

Yes

name of the compute resource.

type

String

Yes

resource type.

domain

String

Yes

domain of compute resource.

ip

String

Yes

Comma separated list of IP addresses of the compute resource.

os

String

Yes

Operating system running on the compute resource.

id

Int64

Yes

GUID of the compute resource in dwh_inventory.compute_resource

latest

String

Yes

Indicates whether this row is the latest one for this compute resource.

dateTk

Int32

Yes

TK of the date in which this compute resource row was created.

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 the dimension.

computeResourceIdentifier

String

Yes

Identifier of the compute resource. Part of the natural key.

name

String

Yes

Mounting point or drive latter. Part of the natural key.

location

String

Yes

Indicates where the data is kept and how it is accessed. For example: local, SAN, NAS. Will be set to null if the location is unknown.

hardwareId

String

Yes

Host specific identifier. Will be set to null if unknown.

type

String

Yes

File system type. For example: NTFS, FAT, UFS, UDF, ZFS, ISO 9660, VXFS etc. Will be set to null if unknown.

id

Int64

Yes

GUID of the file-system in dwh_inventory.file_system.

latest

String

Yes

Indicates whether this row is the latest one for this file-system.

dateTk

Int32

Yes

TK of the date in which this file-system row was created.

tk [PK]

Int32

Yes

TK of the fact.

dateTk [FK] →date_dimension.tk

Int32

Yes

TK of the date.

hostTk [FK] →host_dimension.tk

Int32

Yes

TK of the host.

vmTk [FK] →vm_dimension.tk

Int32

Yes

TK of the vm.

computeResourceTk [FK] →compute_resource_dimension.tk

Int32

Yes

TK of the computeResource.

fsTk [FK] →file_system_dimension.tk

Int32

Yes

TK of the file system.

storageTk [FK] →storage_dimension.tk

Int32

Yes

TK of the storage.

tierTk [FK] →tier_dimension.tk

Int32

Yes

TK of the tier.

sizeMB

Int64

Yes

Size of the file system in MB.

usedMB

Int64

Yes

Amount of file-system capacity that is used and is not available.

tk

Int32

Yes

TK of this host row.

name

String

Yes

Name of the host.

identifier

String

Yes

Identifier of the device.

ip

String

Yes

Comma separated list of IP addresses of the host.

os

String

Yes

Operating system running on the host.

model

String

Yes

Model number.

manufacturer

String

Yes

Manufacturer of the host.

url

String

Yes

Url to this host in Insight Server.

id

Int64

Yes

GUID of the host in dwh_inventory.host.

latest

String

Yes

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

dateTk

Int32

Yes

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

dataCenter

String

Yes

dataCenter annotation value assigned to dwh_dimensions.host_dimension

tk

Int32

Yes

TK of this storage array row.

name

String

Yes

Name of the storage array.

identifier

String

Yes

Identifier of the device.

ip

String

Yes

IP address of the storage array.

model

String

Yes

Model of the storage array.

manufacturer

String

Yes

Manufacturer of the storage array.

serialNumber

String

Yes

Serial number for the storage array.

microcodeVersion

String

Yes

Version of the firmware running on the storage array.

family

String

Yes

Family name of the storage array (e.g. Clariion, Symmetrix etc).

url

String

Yes

Url to this storage in Insight Server.

id

Int64

Yes

GUID of the storage array in dwh_inventory.storage.

latest

String

Yes

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

dateTk

Int32

Yes

TK of the date in which this stroage array row was created.

dataCenter

String

Yes

dataCenter annotation value assigned to dwh_dimensions.storage_dimension

tk

Int32

Yes

TK of this tier row.

name

String

Yes

Identifying name for the tier.

sequence

Int32

Yes

Sequencial number of the tier as defined in dwh_inventory.annotation_value.

cost

Double

Yes

Cost associated with this tier.

id

Int64

Yes

GUID of the tier in dwh_inventory.annotation_value.

latest

String

Yes

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

dateTk

Int32

Yes

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

tk

Int32

Yes

TK of this virtual machine row.

name

String

Yes

Name of the virtual machine.

naturalKey

String

Yes

Natural identifier of the virtual machine.

os

String

Yes

Guest operating system.

virtualCenterIp

String

Yes

IP address of virtual center of the virtual machine.

ips

String

Yes

Comma separated list of IP addresses of the virtual machine.

url

String

Yes

Url to this virtual machine in Insight Server.

id

Int64

Yes

GUID of the virtual machine in dwh_inventory.hv_virtual_machine

latest

String

Yes

Indicates whether this row is the latest one for this virtual machine.

dateTk

Int32

Yes

TK of the date in which this virtual machine row was created.