Source: dwh_fs_util OData endpoint — Cloud Insights
Tables found: 8 | Associations: 7
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| 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 |
PK Primary Key FK Foreign Key NOT NULL Required field
Entity Set(s): compute_resource_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| type | String | Yes |
| domain | String | Yes |
| ip | String | Yes |
| os | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |
Entity Set(s): date_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| fullDate | DateTimeOffset | Yes |
| dayInMonth | Byte | Yes |
| dayInYear | Int32 | Yes |
| dateYear | Int32 | Yes |
| yearLabel | String | Yes |
| monthNum | Byte | Yes |
| monthLabel | String | Yes |
| dayInWeekNum | Byte | Yes |
| quarter | Byte | Yes |
| quarterLabel | String | Yes |
| dayInQuarter | Int32 | Yes |
| repQuarter | Byte | Yes |
| repMonth | Byte | Yes |
| repWeek | Byte | Yes |
| repDay | Byte | Yes |
| repMonthOrLatest | Byte | Yes |
| sspFlag | Byte | Yes |
| latest | String | Yes |
| future | String | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |
Entity Set(s): file_system_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| computeResourceIdentifier | String | Yes |
| name | String | Yes |
| location | String | Yes |
| hardwareId | String | Yes |
| type | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |
Entity Set(s): fs_util_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| vmTkFK → vm_dimension.tk | Int32 | Yes |
| computeResourceTkFK → compute_resource_dimension.tk | Int32 | Yes |
| fsTkFK → file_system_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| sizeMB | Int64 | Yes |
| usedMB | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| file_system_dimension | file_system_dimension | one JOIN: fsTk = file_system_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| compute_resource_dimension | compute_resource_dimension | one JOIN: computeResourceTk = compute_resource_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| vm_dimension | vm_dimension | one JOIN: vmTk = vm_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): host_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| identifier | String | Yes |
| ip | String | Yes |
| os | String | Yes |
| model | String | Yes |
| manufacturer | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| dataCenter | String | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |
Entity Set(s): storage_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| identifier | String | Yes |
| ip | String | Yes |
| model | String | Yes |
| manufacturer | String | Yes |
| serialNumber | String | Yes |
| microcodeVersion | String | Yes |
| family | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| dataCenter | String | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |
Entity Set(s): tier_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| sequence | Int32 | Yes |
| cost | Double | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |
Entity Set(s): vm_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| naturalKey | String | Yes |
| os | String | Yes |
| virtualCenterIp | String | Yes |
| ips | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| fs_util_fact | fs_util_fact | many |