Source: dwh_performance OData endpoint — Cloud Insights
Tables found: 74 | Associations: 167
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| disk_dimension | diskTk | tk |
| storage_dimension | storageTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| disk_dimension | diskTk | tk |
| storage_dimension | storageTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| host_group_dimension | hostGroupTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| internal_volume_dimension | internalVolumeTk | tk |
| k8s_namespace_dimension | k8sNamespaceTk | tk |
| k8s_namespace_group_dimension | k8sNamespaceGroupTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| storage_node_dimension | storageNodeTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| tier_dimension | tierTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| internal_volume_dimension | internalVolumeTk | tk |
| k8s_namespace_dimension | k8sNamespaceTk | tk |
| k8s_namespace_group_dimension | k8sNamespaceGroupTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| storage_node_dimension | storageNodeTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| internal_volume_dimension | internalVolumeTk | tk |
| k8s_namespace_dimension | k8sNamespaceTk | tk |
| k8s_namespace_group_dimension | k8sNamespaceGroupTk | tk |
| qtree_dimension | qtreeTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| tier_dimension | tierTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| internal_volume_dimension | internalVolumeTk | tk |
| k8s_namespace_dimension | k8sNamespaceTk | tk |
| k8s_namespace_group_dimension | k8sNamespaceGroupTk | tk |
| qtree_dimension | qtreeTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| storage_dimension | storageTk | tk |
| storage_node_dimension | storageNodeTk | tk |
| tier_dimension | tierTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| storage_dimension | storageTk | tk |
| storage_node_dimension | storageNodeTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| connected_device_dimension | connectedDeviceTk | tk |
| date_dimension | dateTk | tk |
| fabric_dimension | fabricTk | tk |
| port_dimension | portTk | tk |
| switch_dimension | switchTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| storage_dimension | storageTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| tape_dimension | tapeTk | tk |
| time_dimension | timeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| k8s_node_dimension | k8sNodeTk | tk |
| vm_dimension | vmTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| k8s_node_dimension | k8sNodeTk | tk |
| time_dimension | timeTk | tk |
| vm_dimension | vmTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| datastore_dimension | dataStoreTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| tier_dimension | tierTk | tk |
| vm_dimension | vmTk | tk |
| vmdk_dimension | vmdkTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| datastore_dimension | dataStoreTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| vm_dimension | vmTk | tk |
| vmdk_dimension | vmdkTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| host_group_dimension | hostGroupTk | tk |
| k8s_namespace_dimension | k8sNamespaceTk | tk |
| k8s_namespace_group_dimension | k8sNamespaceGroupTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| storage_node_dimension | storageNodeTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| tier_dimension | tierTk | tk |
| volume_dimension | volumeTk | tk |
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| application_dimension | applicationTk | tk |
| application_group_dimension | applicationGroupTk | tk |
| business_entity_dimension | businessEntityTk | tk |
| date_dimension | dateTk | tk |
| host_dimension | hostTk | tk |
| host_group_dimension | hostGroupTk | tk |
| k8s_namespace_dimension | k8sNamespaceTk | tk |
| k8s_namespace_group_dimension | k8sNamespaceGroupTk | tk |
| service_level_dimension | serviceLevelTk | tk |
| storage_dimension | storageTk | tk |
| storage_node_dimension | storageNodeTk | tk |
| storage_pool_dimension | storagePoolTk | tk |
| tier_dimension | tierTk | tk |
| time_dimension | timeTk | tk |
| volume_dimension | volumeTk | tk |
PK Primary Key FK Foreign Key NOT NULL Required field
Entity Set(s): application_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| description | String | Yes |
| priority | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
| switch_performance_for_host_hourly_fact | switch_performance_for_host_hourly_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): application_group_bridge
| Field | Type | Nullable |
|---|---|---|
| appGroupTk | Int32 | Yes |
| appTk | Int32 | Yes |
| isRep | String | Yes |
Entity Set(s): application_group_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| repApp | String | Yes |
| repAppTk | Int32 | Yes |
| cardinality | Int32 | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
| switch_performance_for_host_hourly_fact | switch_performance_for_host_hourly_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): application_volume_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| sumOfAveragesVolumeThroughput | Double | Yes |
| maxOfMaxVolumeThroughput | Double | Yes |
| sumOfMaxVolumeThroughput | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| sumOfAveragesVolumeIops | Double | Yes |
| maxOfMaxVolumeIops | Double | Yes |
| sumOfMaxVolumeIops | Double | Yes |
| readCacheHitRatio | Double | Yes |
| writeCacheHitRatio | Double | Yes |
| totalCacheHitRatio | Double | Yes |
| totalCacheHitRatioMax | Double | Yes |
| writePending | Int64 | Yes |
| readIoDensity | Double | Yes |
| writeIoDensity | Double | Yes |
| totalIoDensity | Double | Yes |
| totalIoDensityMax | Double | Yes |
| compressionSavingsPercent | Double | Yes |
| compressionSavingsSpace | Double | Yes |
| totalTimeToFull | Double | Yes |
| confidenceIntervalTimeToFull | Double | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
Entity Set(s): business_entity_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| fullname | String | Yes |
| tenant | String | Yes |
| lob | String | Yes |
| businessUnit | String | Yes |
| project | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
| switch_performance_for_host_hourly_fact | switch_performance_for_host_hourly_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): capacity_volume_fact_current
| Field | Type | Nullable |
|---|---|---|
| chargebackFactTk | Int32 | Yes |
| volumeId | Int32 | Yes |
| storageId | Int32 | Yes |
| volumeName | String | Yes |
| volumeType | String | Yes |
| thinProvisioned | String | Yes |
| isVirtual | String | Yes |
| snapshot | String | Yes |
| technologyType | String | Yes |
| physicalUsableMB | Int64 | Yes |
| physicalRawMB | Int64 | Yes |
| provisionedUsableMB | Int64 | Yes |
| provisionedRawMB | Int64 | Yes |
Entity Set(s): cluster_switch_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| address | String | Yes |
| serialNumber | String | Yes |
| network | String | Yes |
| version | String | Yes |
| model | String | Yes |
| monitored | String | Yes |
| monitoringEnabled | String | Yes |
| monitoringReason | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): cluster_switch_port_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| clusterSwitchPortTk | Int32 | Yes |
| clusterSwitchTk | Int32 | Yes |
| storageTk | Int32 | Yes |
| storageNodeTk | Int32 | Yes |
| receiveBytes | Double | Yes |
| transmitBytes | Double | Yes |
| totalBytes | Double | Yes |
| receiveDiscards | Double | Yes |
| transmitDiscards | Double | Yes |
| totalDiscards | Double | Yes |
| receiveErrors | Double | Yes |
| transmitErrors | Double | Yes |
| totalErrors | Double | Yes |
| receivePackets | Double | Yes |
| transmitPackets | Double | Yes |
| totalPackets | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): cluster_switch_port_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| duplexType | String | Yes |
| storageNodePortName | String | Yes |
| storageNodePortMtu | String | Yes |
| portIndex | String | Yes |
| isl | String | Yes |
| macAddress | String | Yes |
| mtu | String | Yes |
| number | String | Yes |
| type | String | Yes |
| speed | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): cluster_switch_port_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| clusterSwitchPortTk | Int32 | Yes |
| clusterSwitchTk | Int32 | Yes |
| storageTk | Int32 | Yes |
| storageNodeTk | Int32 | Yes |
| receiveBytes | Double | Yes |
| transmitBytes | Double | Yes |
| totalBytes | Double | Yes |
| receiveDiscards | Double | Yes |
| transmitDiscards | Double | Yes |
| totalDiscards | Double | Yes |
| receiveErrors | Double | Yes |
| transmitErrors | Double | Yes |
| totalErrors | Double | Yes |
| receivePackets | Double | Yes |
| transmitPackets | Double | Yes |
| totalPackets | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): connected_device_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| manufacturer | String | Yes |
| model | String | Yes |
| type | String | Yes |
| firmware | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| switch_performance_for_port_hourly_fact | switch_performance_for_port_hourly_fact | many |
Entity Set(s): datastore_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| naturalKey | String | Yes |
| name | String | Yes |
| moid | String | Yes |
| virtualCenterIp | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_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 |
|---|---|---|
| host_vm_daily_performance_fact | host_vm_daily_performance_fact | many |
| time_dimension | time_dimension | many |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| switch_performance_for_port_hourly_fact | switch_performance_for_port_hourly_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
| switch_performance_for_tape_hourly_fact | switch_performance_for_tape_hourly_fact | many |
| switch_performance_for_host_hourly_fact | switch_performance_for_host_hourly_fact | many |
| switch_performance_for_storage_hourly_fact | switch_performance_for_storage_hourly_fact | many |
| storage_node_hourly_performance_fact | storage_node_hourly_performance_fact | many |
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| storage_node_daily_performance_fact | storage_node_daily_performance_fact | many |
| disk_hourly_performance_fact | disk_hourly_performance_fact | many |
| disk_daily_performance_fact | disk_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_fact | many |
| host_vm_hourly_performance_fact | host_vm_hourly_performance_fact | many |
Entity Set(s): disk_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| diskTkFK → disk_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readUtilization | Double | Yes |
| writeUtilization | Double | Yes |
| totalUtilization | Double | Yes |
| totalUtilizationMax | Double | Yes |
| accessed | Int32 | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| disk_dimension | disk_dimension | one JOIN: diskTk = disk_dimension.tk |
Entity Set(s): disk_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| storageIdentifier | String | Yes |
| name | String | Yes |
| speed | Int32 | Yes |
| location | String | Yes |
| role | String | Yes |
| vendor | String | Yes |
| model | String | Yes |
| type | String | Yes |
| diskGroup | String | Yes |
| status | String | Yes |
| serialNumber | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| disk_hourly_performance_fact | disk_hourly_performance_fact | many |
| disk_daily_performance_fact | disk_daily_performance_fact | many |
Entity Set(s): disk_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| diskTkFK → disk_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readUtilization | Double | Yes |
| writeUtilization | Double | Yes |
| totalUtilization | Double | Yes |
| totalUtilizationMax | Double | Yes |
| accessed | Int32 | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| disk_dimension | disk_dimension | one JOIN: diskTk = disk_dimension.tk |
Entity Set(s): fabric_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| wwn | String | Yes |
| name | String | Yes |
| vsanEnabled | String | Yes |
| vsanId | String | Yes |
| zoningEnabled | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| switch_performance_for_port_hourly_fact | switch_performance_for_port_hourly_fact | many |
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 |
|---|---|---|
| host_vm_daily_performance_fact | host_vm_daily_performance_fact | many |
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
| switch_performance_for_host_hourly_fact | switch_performance_for_host_hourly_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_fact | many |
| host_vm_hourly_performance_fact | host_vm_hourly_performance_fact | many |
Entity Set(s): host_group_bridge
| Field | Type | Nullable |
|---|---|---|
| hostGroupTk | Int32 | Yes |
| hostTk | Int32 | Yes |
| isRep | String | Yes |
Entity Set(s): host_group_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| repHost | String | Yes |
| repHostTk | Int32 | Yes |
| cardinality | Int32 | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): host_vm_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| ipReceiveThroughput | Double | Yes |
| ipTransmitThroughput | Double | Yes |
| ipTotalThroughput | Double | Yes |
| ipTotalThroughputMax | Double | Yes |
| cpuUtilization | Double | Yes |
| maxOfAvgCpuUtilization | Double | Yes |
| memoryUtilization | Double | Yes |
| maxOfAvgMemoryUtilization | Double | Yes |
| swapInRate | Double | Yes |
| maxOfAvgSwapInRate | Double | Yes |
| swapOutRate | Double | Yes |
| maxOfAvgSwapOutRate | Double | Yes |
| swapTotalRate | Double | Yes |
| swapTotalRateMax | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): host_vm_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| ipReceiveThroughput | Double | Yes |
| ipTransmitThroughput | Double | Yes |
| ipTotalThroughput | Double | Yes |
| ipTotalThroughputMax | Double | Yes |
| cpuUtilization | Double | Yes |
| memoryUtilization | Double | Yes |
| swapInRate | Double | Yes |
| swapOutRate | Double | Yes |
| swapTotalRate | Double | Yes |
| swapTotalRateMax | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): host_volume_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| hostGroupTkFK → host_group_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| sumOfAveragesVolumeThroughput | Double | Yes |
| maxOfMaxVolumeThroughput | Double | Yes |
| sumOfMaxVolumeThroughput | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| sumOfAveragesVolumeIops | Double | Yes |
| maxOfMaxVolumeIops | Double | Yes |
| sumOfMaxVolumeIops | Double | Yes |
| readCacheHitRatio | Double | Yes |
| writeCacheHitRatio | Double | Yes |
| totalCacheHitRatio | Double | Yes |
| totalCacheHitRatioMax | Double | Yes |
| writePending | Int64 | Yes |
| readIoDensity | Double | Yes |
| writeIoDensity | Double | Yes |
| totalIoDensity | Double | Yes |
| totalIoDensityMax | Double | Yes |
| compressionSavingsPercent | Double | Yes |
| compressionSavingsSpace | Double | Yes |
| totalTimeToFull | Double | Yes |
| confidenceIntervalTimeToFull | Double | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| host_group_dimension | host_group_dimension | one JOIN: hostGroupTk = host_group_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): internal_volume_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| internalVolumeTkFK → internal_volume_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| virtualStorageTk | Int32 | Yes |
| storageNodeTkFK → storage_node_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| k8sNamespaceTkFK → k8s_namespace_dimension.tk | Int32 | Yes |
| k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| writePending | Int64 | Yes |
| readIoDensity | Double | Yes |
| writeIoDensity | Double | Yes |
| totalIoDensity | Double | Yes |
| totalIoDensityMax | Double | Yes |
| objectCount | Double | Yes |
| filesystemCapacityPhysicalUsed | Double | Yes |
| filesystemCapacityPhysicalAvailable | Double | Yes |
| filesystemCapacityLogicalUsed | Double | Yes |
| totalTimeToFull | Double | Yes |
| confidenceIntervalTimeToFull | Double | Yes |
| accessed | Int32 | Yes |
| frontend | String | Yes |
| backend | String | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| internal_volume_dimension | internal_volume_dimension | one JOIN: internalVolumeTk = internal_volume_dimension.tk |
| storage_node_dimension | storage_node_dimension | one JOIN: storageNodeTk = storage_node_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| k8s_namespace_group_dimension | k8s_namespace_group_dimension | one JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
| k8s_namespace_dimension | k8s_namespace_dimension | one JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk |
Entity Set(s): internal_volume_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| identifier | String | Yes |
| storagePoolIdentifier | String | Yes |
| storageName | String | Yes |
| storageIP | String | Yes |
| type | String | Yes |
| virtualStorage | String | Yes |
| spaceGuarantee | String | Yes |
| thinProvisioningSupported | String | Yes |
| thinProvisioned | String | Yes |
| uuid | String | Yes |
| flexGroupIdentifier | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
Entity Set(s): internal_volume_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| internalVolumeTkFK → internal_volume_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| virtualStorageTk | Int32 | Yes |
| storageNodeTkFK → storage_node_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| k8sNamespaceTkFK → k8s_namespace_dimension.tk | Int32 | Yes |
| k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| writePending | Int64 | Yes |
| readIoDensity | Double | Yes |
| writeIoDensity | Double | Yes |
| totalIoDensity | Double | Yes |
| totalIoDensityMax | Double | Yes |
| objectCount | Double | Yes |
| filesystemCapacityPhysicalUsed | Double | Yes |
| filesystemCapacityPhysicalAvailable | Double | Yes |
| filesystemCapacityLogicalUsed | Double | Yes |
| totalTimeToFull | Double | Yes |
| confidenceIntervalTimeToFull | Double | Yes |
| accessed | Int32 | Yes |
| frontend | String | Yes |
| backend | String | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| internal_volume_dimension | internal_volume_dimension | one JOIN: internalVolumeTk = internal_volume_dimension.tk |
| storage_node_dimension | storage_node_dimension | one JOIN: storageNodeTk = storage_node_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| k8s_namespace_group_dimension | k8s_namespace_group_dimension | one JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
| k8s_namespace_dimension | k8s_namespace_dimension | one JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk |
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): k8s_cluster_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| allocatableCpuSaturation | Double | Yes |
| capacityCpuSaturation | Double | Yes |
| allocatableMemorySaturation | Double | Yes |
| capacityMemorySaturation | Double | Yes |
| allocatableCpuCores | Double | Yes |
| capacityCpuCores | Double | Yes |
| usageCpuCores | Double | Yes |
| requestsCpuCores | Double | Yes |
| limitsCpuCores | Double | Yes |
| allocatableMemoryBytes | Double | Yes |
| capacityMemoryBytes | Double | Yes |
| limitsMemoryBytes | Double | Yes |
| requestsMemoryBytes | Double | Yes |
| usageMemoryBytes | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_cluster_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): k8s_cluster_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| allocatableCpuSaturation | Double | Yes |
| capacityCpuSaturation | Double | Yes |
| allocatableMemorySaturation | Double | Yes |
| capacityMemorySaturation | Double | Yes |
| allocatableCpuCores | Double | Yes |
| capacityCpuCores | Double | Yes |
| usageCpuCores | Double | Yes |
| requestsCpuCores | Double | Yes |
| limitsCpuCores | Double | Yes |
| allocatableMemoryBytes | Double | Yes |
| capacityMemoryBytes | Double | Yes |
| limitsMemoryBytes | Double | Yes |
| requestsMemoryBytes | Double | Yes |
| usageMemoryBytes | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_namespace_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| namespaceTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| cpuHardLimit | Double | Yes |
| cpuUsedLimit | Double | Yes |
| cpuHardRequest | Double | Yes |
| cpuUsedRequest | Double | Yes |
| memoryHardLimit | Double | Yes |
| memoryUsedLimit | Double | Yes |
| memoryHardRequest | Double | Yes |
| memoryUsedRequest | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_namespace_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| clusterName | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): k8s_namespace_group_bridge
| Field | Type | Nullable |
|---|---|---|
| k8sNamespaceGroupTk | Int32 | Yes |
| k8sNamespaceTk | Int32 | Yes |
| isRep | String | Yes |
Entity Set(s): k8s_namespace_group_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| repK8sNamespace | String | Yes |
| repK8sNamespaceTk | Int32 | Yes |
| cardinality | Int32 | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): k8s_namespace_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| namespaceTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| cpuHardLimit | Double | Yes |
| cpuUsedLimit | Double | Yes |
| cpuHardRequest | Double | Yes |
| cpuUsedRequest | Double | Yes |
| memoryHardLimit | Double | Yes |
| memoryUsedLimit | Double | Yes |
| memoryHardRequest | Double | Yes |
| memoryUsedRequest | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_node_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| nodeTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| vmTk | Int32 | Yes |
| allocatableCpuSaturation | Double | Yes |
| capacityCpuSaturation | Double | Yes |
| allocatableMemorySaturation | Double | Yes |
| capacityMemorySaturation | Double | Yes |
| allocatableMemoryBytes | Double | Yes |
| capacityMemoryBytes | Double | Yes |
| memoryUsageBytes | Double | Yes |
| cpuUsageNanocores | Double | Yes |
| allocatableCpu | Double | Yes |
| capacityCpu | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_node_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| clusterName | String | Yes |
| internalIp | String | Yes |
| osImage | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
Entity Set(s): k8s_node_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| nodeTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| vmTk | Int32 | Yes |
| allocatableCpuSaturation | Double | Yes |
| capacityCpuSaturation | Double | Yes |
| allocatableMemorySaturation | Double | Yes |
| capacityMemorySaturation | Double | Yes |
| allocatableMemoryBytes | Double | Yes |
| capacityMemoryBytes | Double | Yes |
| memoryUsageBytes | Double | Yes |
| cpuUsageNanocores | Double | Yes |
| allocatableCpu | Double | Yes |
| capacityCpu | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_pv_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| clusterName | String | Yes |
| phase | String | Yes |
| pvcName | String | Yes |
| storageClass | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): k8s_pvc_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| pvcTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| namespaceTk | Int32 | Yes |
| pvTk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| readLatency | Double | Yes |
| writeLatency | Double | Yes |
| totalLatency | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_pvc_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| clusterName | String | Yes |
| namespaceName | String | Yes |
| pvName | String | Yes |
| phase | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): k8s_pvc_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| pvcTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| namespaceTk | Int32 | Yes |
| pvTk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| readLatency | Double | Yes |
| writeLatency | Double | Yes |
| totalLatency | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_workload_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| workloadTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| namespaceTk | Int32 | Yes |
| usageCpuCores | Double | Yes |
| requestCpuCores | Double | Yes |
| limitCpuCores | Double | Yes |
| usageMemoryBytes | Double | Yes |
| requestMemoryBytes | Double | Yes |
| limitMemoryBytes | Double | Yes |
| runningPodCount | Int32 | Yes |
| desiredPodCount | Int32 | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): k8s_workload_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| clusterName | String | Yes |
| namespaceName | String | Yes |
| type | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): k8s_workload_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| workloadTk | Int32 | Yes |
| clusterTk | Int32 | Yes |
| namespaceTk | Int32 | Yes |
| usageCpuCores | Double | Yes |
| requestCpuCores | Double | Yes |
| limitCpuCores | Double | Yes |
| usageMemoryBytes | Double | Yes |
| requestMemoryBytes | Double | Yes |
| limitMemoryBytes | Double | Yes |
| runningPodCount | Int32 | Yes |
| desiredPodCount | Int32 | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): port_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| wwn | String | Yes |
| name | String | Yes |
| gbicType | String | Yes |
| type | String | Yes |
| speed | String | Yes |
| isGenerated | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| switch_performance_for_port_hourly_fact | switch_performance_for_port_hourly_fact | many |
Entity Set(s): qtree_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| qtreeTkFK → qtree_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| internalVolumeTkFK → internal_volume_dimension.tk | Int32 | Yes |
| virtualStorageTk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| k8sNamespaceTkFK → k8s_namespace_dimension.tk | Int32 | Yes |
| k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk | Int32 | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| internal_volume_dimension | internal_volume_dimension | one JOIN: internalVolumeTk = internal_volume_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| qtree_dimension | qtree_dimension | one JOIN: qtreeTk = qtree_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| k8s_namespace_group_dimension | k8s_namespace_group_dimension | one JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
| k8s_namespace_dimension | k8s_namespace_dimension | one JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk |
Entity Set(s): qtree_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| identifier | String | Yes |
| storageIdentifier | String | Yes |
| type | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
Entity Set(s): qtree_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| qtreeTkFK → qtree_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| internalVolumeTkFK → internal_volume_dimension.tk | Int32 | Yes |
| virtualStorageTk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| k8sNamespaceTkFK → k8s_namespace_dimension.tk | Int32 | Yes |
| k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk | Int32 | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| internal_volume_dimension | internal_volume_dimension | one JOIN: internalVolumeTk = internal_volume_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| k8s_namespace_group_dimension | k8s_namespace_group_dimension | one JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
| k8s_namespace_dimension | k8s_namespace_dimension | one JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk |
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| qtree_dimension | qtree_dimension | one JOIN: qtreeTk = qtree_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): service_level_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 |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_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 |
|---|---|---|
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| switch_performance_for_storage_hourly_fact | switch_performance_for_storage_hourly_fact | many |
| storage_node_hourly_performance_fact | storage_node_hourly_performance_fact | many |
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| storage_node_daily_performance_fact | storage_node_daily_performance_fact | many |
| disk_hourly_performance_fact | disk_hourly_performance_fact | many |
| disk_daily_performance_fact | disk_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_fact | many |
Entity Set(s): storage_node_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| storageNodeTkFK → storage_node_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| diskReadsReplaced | Double | Yes |
| cacheHitRatio | Double | Yes |
| utilization | Double | Yes |
| utilizationMax | Double | Yes |
| readFileSystemIops | Double | Yes |
| writeFileSystemIops | Double | Yes |
| readFileSystemThroughput | Double | Yes |
| writeFileSystemThroughput | Double | Yes |
| portUtilization | Double | Yes |
| portErrors | Int64 | Yes |
| portTraffic | Double | Yes |
| accessed | Int32 | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_node_dimension | storage_node_dimension | one JOIN: storageNodeTk = storage_node_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): storage_node_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| identifier | String | Yes |
| version | String | Yes |
| model | String | Yes |
| serialNumber | String | Yes |
| siteName | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| storage_node_daily_performance_fact | storage_node_daily_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
| storage_node_hourly_performance_fact | storage_node_hourly_performance_fact | many |
Entity Set(s): storage_node_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| storageNodeTkFK → storage_node_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| diskReadsReplaced | Double | Yes |
| cacheHitRatio | Double | Yes |
| utilization | Double | Yes |
| utilizationMax | Double | Yes |
| readFileSystemIops | Double | Yes |
| writeFileSystemIops | Double | Yes |
| readFileSystemThroughput | Double | Yes |
| writeFileSystemThroughput | Double | Yes |
| portUtilization | Double | Yes |
| portErrors | Int64 | Yes |
| portTraffic | Double | Yes |
| accessed | Int32 | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_node_dimension | storage_node_dimension | one JOIN: storageNodeTk = storage_node_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): storage_pool_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| storageName | String | Yes |
| storageIP | String | Yes |
| type | String | Yes |
| redundancy | String | Yes |
| thinProvisioningSupported | String | Yes |
| isVirtual | String | Yes |
| usesFlashPools | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| disk_hourly_performance_fact | disk_hourly_performance_fact | many |
| disk_daily_performance_fact | disk_daily_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): switch_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| wwn | String | Yes |
| name | String | Yes |
| identifier | String | Yes |
| ip | String | Yes |
| model | String | Yes |
| manufacturer | String | Yes |
| firmware | String | Yes |
| serialNumber | String | Yes |
| npv | String | Yes |
| isGenerated | String | Yes |
| type | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| dataCenter | String | Yes |
| switchLevel | String | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| switch_performance_for_port_hourly_fact | switch_performance_for_port_hourly_fact | many |
Entity Set(s): switch_performance_for_host_hourly_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| rxTraffic | Double | Yes |
| txTraffic | Double | Yes |
| totalTraffic | Double | Yes |
| errorRateFlag | String | Yes |
| crcErrorRateFlag | String | Yes |
| syncLossCount | Int64 | Yes |
| signalLossCount | Int64 | Yes |
| class3DiscardCount | Int64 | Yes |
| frameTooShortCount | Int64 | Yes |
| frameTooLongCount | Int64 | Yes |
| bbCreditErrorCount | Int64 | Yes |
| rx | Double | Yes |
| tx | Double | Yes |
| rxMax | Double | Yes |
| txMax | Double | Yes |
| trafficUtilizationTotal | Double | Yes |
| trafficUtilizationTotalMax | Double | Yes |
| rxLinkResets | Int64 | Yes |
| txLinkResets | Int64 | Yes |
| balanceIndex | Int32 | Yes |
| weightedBalanceIndex | Int32 | Yes |
| portSpeed | Int32 | Yes |
| portCount | Int32 | Yes |
| portErrorsLinkFailure | Int64 | Yes |
| bbCreditZeroRx | Int64 | Yes |
| bbCreditZeroTx | Int64 | Yes |
| bbCreditZeroMsTx | Double | Yes |
| bbCreditZeroTotal | Int64 | Yes |
| trafficRateTx | Double | Yes |
| trafficRateRx | Double | Yes |
| trafficRateTotal | Double | Yes |
| trafficFrameRateTx | Double | Yes |
| trafficFrameRateRx | Double | Yes |
| trafficFrameRateTotal | Double | Yes |
| trafficFrameSizeAvgTx | Int64 | Yes |
| trafficFrameSizeAvgRx | Int64 | Yes |
| portErrorsTimeoutDiscardTx | Int64 | Yes |
| portErrorsCrc | Int64 | Yes |
| portErrorsEncIn | Int64 | Yes |
| portErrorsEncOut | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
Entity Set(s): switch_performance_for_port_hourly_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| portTkFK → port_dimension.tk | Int32 | Yes |
| switchTkFK → switch_dimension.tk | Int32 | Yes |
| fabricTkFK → fabric_dimension.tk | Int32 | Yes |
| connectedDeviceTkFK → connected_device_dimension.tk | Int32 | Yes |
| connectivityType | String | Yes |
| isl | String | Yes |
| rxTraffic | Double | Yes |
| txTraffic | Double | Yes |
| totalTraffic | Double | Yes |
| errorRateFlag | String | Yes |
| crcErrorRateFlag | String | Yes |
| syncLossCount | Int64 | Yes |
| signalLossCount | Int64 | Yes |
| class3DiscardCount | Int64 | Yes |
| frameTooShortCount | Int64 | Yes |
| frameTooLongCount | Int64 | Yes |
| bbCreditErrorCount | Int64 | Yes |
| rx | Double | Yes |
| tx | Double | Yes |
| rxMax | Double | Yes |
| txMax | Double | Yes |
| trafficUtilizationTotal | Double | Yes |
| trafficUtilizationTotalMax | Double | Yes |
| rxLinkResets | Int64 | Yes |
| txLinkResets | Int64 | Yes |
| portErrorsLinkFailure | Int64 | Yes |
| bbCreditZeroRx | Int64 | Yes |
| bbCreditZeroTx | Int64 | Yes |
| bbCreditZeroMsTx | Double | Yes |
| bbCreditZeroTotal | Int64 | Yes |
| trafficRateTx | Double | Yes |
| trafficRateRx | Double | Yes |
| trafficRateTotal | Double | Yes |
| trafficFrameRateTx | Double | Yes |
| trafficFrameRateRx | Double | Yes |
| trafficFrameRateTotal | Double | Yes |
| trafficFrameSizeAvgTx | Int64 | Yes |
| trafficFrameSizeAvgRx | Int64 | Yes |
| portErrorsTimeoutDiscardTx | Int64 | Yes |
| portErrorsCrc | Int64 | Yes |
| portErrorsEncIn | Int64 | Yes |
| portErrorsEncOut | Int64 | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| connected_device_dimension | connected_device_dimension | one JOIN: connectedDeviceTk = connected_device_dimension.tk |
| fabric_dimension | fabric_dimension | one JOIN: fabricTk = fabric_dimension.tk |
| port_dimension | port_dimension | one JOIN: portTk = port_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| switch_dimension | switch_dimension | one JOIN: switchTk = switch_dimension.tk |
Entity Set(s): switch_performance_for_storage_hourly_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| rxTraffic | Double | Yes |
| txTraffic | Double | Yes |
| totalTraffic | Double | Yes |
| errorRateFlag | String | Yes |
| crcErrorRateFlag | String | Yes |
| syncLossCount | Int64 | Yes |
| signalLossCount | Int64 | Yes |
| class3DiscardCount | Int64 | Yes |
| frameTooShortCount | Int64 | Yes |
| frameTooLongCount | Int64 | Yes |
| bbCreditErrorCount | Int64 | Yes |
| rx | Double | Yes |
| tx | Double | Yes |
| rxMax | Double | Yes |
| txMax | Double | Yes |
| trafficUtilizationTotal | Double | Yes |
| trafficUtilizationTotalMax | Double | Yes |
| rxLinkResets | Int64 | Yes |
| txLinkResets | Int64 | Yes |
| balanceIndex | Int32 | Yes |
| weightedBalanceIndex | Int32 | Yes |
| portSpeed | Int32 | Yes |
| portCount | Int32 | Yes |
| portErrorsLinkFailure | Int64 | Yes |
| bbCreditZeroRx | Int64 | Yes |
| bbCreditZeroTx | Int64 | Yes |
| bbCreditZeroMsTx | Double | Yes |
| bbCreditZeroTotal | Int64 | Yes |
| trafficRateTx | Double | Yes |
| trafficRateRx | Double | Yes |
| trafficRateTotal | Double | Yes |
| trafficFrameRateTx | Double | Yes |
| trafficFrameRateRx | Double | Yes |
| trafficFrameRateTotal | Double | Yes |
| trafficFrameSizeAvgTx | Int64 | Yes |
| trafficFrameSizeAvgRx | Int64 | Yes |
| portErrorsTimeoutDiscardTx | Int64 | Yes |
| portErrorsCrc | Int64 | Yes |
| portErrorsEncIn | Int64 | Yes |
| portErrorsEncOut | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): switch_performance_for_tape_hourly_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| tapeTkFK → tape_dimension.tk | Int32 | Yes |
| rxTraffic | Double | Yes |
| txTraffic | Double | Yes |
| totalTraffic | Double | Yes |
| errorRateFlag | String | Yes |
| crcErrorRateFlag | String | Yes |
| syncLossCount | Int64 | Yes |
| signalLossCount | Int64 | Yes |
| class3DiscardCount | Int64 | Yes |
| frameTooShortCount | Int64 | Yes |
| frameTooLongCount | Int64 | Yes |
| bbCreditErrorCount | Int64 | Yes |
| rx | Double | Yes |
| tx | Double | Yes |
| rxMax | Double | Yes |
| txMax | Double | Yes |
| trafficUtilizationTotal | Double | Yes |
| trafficUtilizationTotalMax | Double | Yes |
| rxLinkResets | Int64 | Yes |
| txLinkResets | Int64 | Yes |
| balanceIndex | Int32 | Yes |
| weightedBalanceIndex | Int32 | Yes |
| portSpeed | Int32 | Yes |
| portCount | Int32 | Yes |
| portErrorsLinkFailure | Int64 | Yes |
| bbCreditZeroRx | Int64 | Yes |
| bbCreditZeroTx | Int64 | Yes |
| bbCreditZeroMsTx | Double | Yes |
| bbCreditZeroTotal | Int64 | Yes |
| trafficRateTx | Double | Yes |
| trafficRateRx | Double | Yes |
| trafficRateTotal | Double | Yes |
| trafficFrameRateTx | Double | Yes |
| trafficFrameRateRx | Double | Yes |
| trafficFrameRateTotal | Double | Yes |
| trafficFrameSizeAvgTx | Int64 | Yes |
| trafficFrameSizeAvgRx | Int64 | Yes |
| portErrorsTimeoutDiscardTx | Int64 | Yes |
| portErrorsCrc | Int64 | Yes |
| portErrorsEncIn | Int64 | Yes |
| portErrorsEncOut | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| tape_dimension | tape_dimension | one JOIN: tapeTk = tape_dimension.tk |
Entity Set(s): tape_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| name | String | Yes |
| identifier | String | Yes |
| ip | String | Yes |
| manufacturer | String | Yes |
| serialNumber | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| switch_performance_for_tape_hourly_fact | switch_performance_for_tape_hourly_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 |
|---|---|---|
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| qtree_daily_performance_fact | qtree_daily_performance_fact | many |
| storage_node_daily_performance_fact | storage_node_daily_performance_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| internal_volume_daily_performance_fact | internal_volume_daily_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_fact | many |
| storage_node_hourly_performance_fact | storage_node_hourly_performance_fact | many |
Entity Set(s): time_dimension
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| hourDateTime | DateTimeOffset | Yes |
| hour | Byte | Yes |
| minute | Byte | Yes |
| second | Byte | Yes |
| microsecond | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| switch_performance_for_port_hourly_fact | switch_performance_for_port_hourly_fact | many |
| host_volume_hourly_performance_fact | host_volume_hourly_performance_fact | many |
| switch_performance_for_tape_hourly_fact | switch_performance_for_tape_hourly_fact | many |
| switch_performance_for_host_hourly_fact | switch_performance_for_host_hourly_fact | many |
| switch_performance_for_storage_hourly_fact | switch_performance_for_storage_hourly_fact | many |
| storage_node_hourly_performance_fact | storage_node_hourly_performance_fact | many |
| qtree_hourly_performance_fact | qtree_hourly_performance_fact | many |
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| application_volume_hourly_performance_fact | application_volume_hourly_performance_fact | many |
| disk_hourly_performance_fact | disk_hourly_performance_fact | many |
| internal_volume_hourly_performance_fact | internal_volume_hourly_performance_fact | many |
| host_vm_hourly_performance_fact | host_vm_hourly_performance_fact | many |
Entity Set(s): vm_daily_performance_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 |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| k8sNodeTkFK → k8s_node_dimension.tk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| ipReceiveThroughput | Double | Yes |
| ipTransmitThroughput | Double | Yes |
| ipTotalThroughput | Double | Yes |
| ipTotalThroughputMax | Double | Yes |
| cpuUtilization | Double | Yes |
| maxOfAvgCpuUtilization | Double | Yes |
| maxOfMaxCpuUtilization | Double | Yes |
| memoryUtilization | Double | Yes |
| maxOfAvgMemoryUtilization | Double | Yes |
| maxOfMaxMemoryUtilization | Double | Yes |
| swapInRate | Double | Yes |
| maxOfAvgSwapInRate | Double | Yes |
| swapOutRate | Double | Yes |
| maxOfAvgSwapOutRate | Double | Yes |
| swapTotalRate | Double | Yes |
| swapTotalRateMax | Double | Yes |
| processors | Int32 | Yes |
| memory | Int64 | Yes |
| cpuCoSchedulingDelayTimePercent | Double | Yes |
| cpuDemandToEntitlementPercent | Double | Yes |
| cpuIdleTimePercent | Double | Yes |
| waitingToBeScheduledTimePercent | Double | Yes |
| cpuTotalWaitTimePercent | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| k8s_node_dimension | k8s_node_dimension | one JOIN: k8sNodeTk = k8s_node_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_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 |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
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 |
|---|---|---|
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| vm_hourly_performance_fact | vm_hourly_performance_fact | many |
| vm_daily_performance_fact | vm_daily_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_fact | many |
Entity Set(s): vm_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| vmTkFK → vm_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| k8sNodeTkFK → k8s_node_dimension.tk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| ipReceiveThroughput | Double | Yes |
| ipTransmitThroughput | Double | Yes |
| ipTotalThroughput | Double | Yes |
| ipTotalThroughputMax | Double | Yes |
| cpuUtilization | Double | Yes |
| memoryUtilization | Double | Yes |
| cpuUtilizationMax | Double | Yes |
| memoryUtilizationMax | Double | Yes |
| swapInRate | Double | Yes |
| swapOutRate | Double | Yes |
| swapTotalRate | Double | Yes |
| swapTotalRateMax | Double | Yes |
| processors | Int32 | Yes |
| memory | Int64 | Yes |
| cpuCoSchedulingDelayTimePercent | Double | Yes |
| cpuDemandToEntitlementPercent | Double | Yes |
| cpuIdleTimePercent | Double | Yes |
| waitingToBeScheduledTimePercent | Double | Yes |
| cpuTotalWaitTimePercent | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| k8s_node_dimension | k8s_node_dimension | one JOIN: k8sNodeTk = k8s_node_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_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 |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
Entity Set(s): vmdk_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| vmdkTkFK → vmdk_dimension.tk | Int32 | Yes |
| dataStoreTkFK → datastore_dimension.tk | Int32 | Yes |
| vmTkFK → vm_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| datastore_dimension | datastore_dimension | one JOIN: dataStoreTk = datastore_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| vm_dimension | vm_dimension | one JOIN: vmTk = vm_dimension.tk |
| vmdk_dimension | vmdk_dimension | one JOIN: vmdkTk = vmdk_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): vmdk_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| naturalKey | String | Yes |
| name | String | Yes |
| type | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| vmdk_hourly_performance_fact | vmdk_hourly_performance_fact | many |
| vmdk_daily_performance_fact | vmdk_daily_performance_fact | many |
Entity Set(s): vmdk_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| vmdkTkFK → vmdk_dimension.tk | Int32 | Yes |
| dataStoreTkFK → datastore_dimension.tk | Int32 | Yes |
| vmTkFK → vm_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| datastore_dimension | datastore_dimension | one JOIN: dataStoreTk = datastore_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| vm_dimension | vm_dimension | one JOIN: vmTk = vm_dimension.tk |
| vmdk_dimension | vmdk_dimension | one JOIN: vmdkTk = vmdk_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
Entity Set(s): vmware_host_daily_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| dateTk | Int32 | Yes |
| vmwareHostTk | Int32 | Yes |
| powerAvg | Double | Yes |
| powerCapAvg | Double | Yes |
| energyAvg | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): vmware_host_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| identifier | String | Yes |
| name | String | Yes |
| numCpuCores | Int64 | Yes |
| numCpuPackages | Int64 | Yes |
| numCpuThreads | Int64 | Yes |
| numNodes | Int64 | Yes |
| hyperThreadActive | String | Yes |
| hyperThreadAvailable | String | Yes |
| hyperThreadConfig | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
Entity Set(s): vmware_host_hourly_metrics_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTk | Int32 | Yes |
| dateTk | Int32 | Yes |
| vmwareHostTk | Int32 | Yes |
| powerAvg | Double | Yes |
| powerCapAvg | Double | Yes |
| energyAvg | Double | Yes |
| timestampPK | Int64 | Yes |
Entity Set(s): volume_daily_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| volumeTkFK → volume_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| virtualStorageTk | Int32 | Yes |
| storageNodeTkFK → storage_node_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| hostGroupTkFK → host_group_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| k8sNamespaceTkFK → k8s_namespace_dimension.tk | Int32 | Yes |
| k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readCacheHitRatio | Double | Yes |
| writeCacheHitRatio | Double | Yes |
| totalCacheHitRatio | Double | Yes |
| totalCacheHitRatioMax | Double | Yes |
| writePending | Int64 | Yes |
| readIoDensity | Double | Yes |
| writeIoDensity | Double | Yes |
| totalIoDensity | Double | Yes |
| totalIoDensityMax | Double | Yes |
| compressionSavingsPercent | Double | Yes |
| compressionSavingsSpace | Double | Yes |
| totalTimeToFull | Double | Yes |
| confidenceIntervalTimeToFull | Double | Yes |
| accessed | Int32 | Yes |
| frontend | String | Yes |
| backend | String | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_node_dimension | storage_node_dimension | one JOIN: storageNodeTk = storage_node_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| host_group_dimension | host_group_dimension | one JOIN: hostGroupTk = host_group_dimension.tk |
| k8s_namespace_group_dimension | k8s_namespace_group_dimension | one JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
| k8s_namespace_dimension | k8s_namespace_dimension | one JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk |
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| volume_dimension | volume_dimension | one JOIN: volumeTk = volume_dimension.tk |
Entity Set(s): volume_dimension
| Field | Type | Nullable |
|---|---|---|
| tk | Int32 | Yes |
| storageIdentifier | String | Yes |
| name | String | Yes |
| label | String | Yes |
| thinProvisioned | String | Yes |
| type | String | Yes |
| isVirtual | String | Yes |
| meta | String | Yes |
| snapshot | String | Yes |
| technologyType | String | Yes |
| uuid | String | Yes |
| isMainframe | String | Yes |
| url | String | Yes |
| id | Int32 | Yes |
| latest | String | Yes |
| dateTk | Int32 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| volume_hourly_performance_fact | volume_hourly_performance_fact | many |
| volume_daily_performance_fact | volume_daily_performance_fact | many |
Entity Set(s): volume_hourly_performance_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int64 | Yes |
| timeTkFK → time_dimension.tk | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| volumeTkFK → volume_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| virtualStorageTk | Int32 | Yes |
| storageNodeTkFK → storage_node_dimension.tk | Int32 | Yes |
| storagePoolTkFK → storage_pool_dimension.tk | Int32 | Yes |
| applicationTkFK → application_dimension.tk | Int32 | Yes |
| applicationGroupTkFK → application_group_dimension.tk | Int32 | Yes |
| hostTkFK → host_dimension.tk | Int32 | Yes |
| hostGroupTkFK → host_group_dimension.tk | Int32 | Yes |
| tierTkFK → tier_dimension.tk | Int32 | Yes |
| serviceLevelTkFK → service_level_dimension.tk | Int32 | Yes |
| businessEntityTkFK → business_entity_dimension.tk | Int32 | Yes |
| k8sNamespaceTkFK → k8s_namespace_dimension.tk | Int32 | Yes |
| k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk | Int32 | Yes |
| readResponseTime | Double | Yes |
| writeResponseTime | Double | Yes |
| totalResponseTime | Double | Yes |
| totalResponseTimeMax | Double | Yes |
| readThroughput | Double | Yes |
| writeThroughput | Double | Yes |
| totalThroughput | Double | Yes |
| totalThroughputMax | Double | Yes |
| readIops | Double | Yes |
| writeIops | Double | Yes |
| totalIops | Double | Yes |
| totalIopsMax | Double | Yes |
| readCacheHitRatio | Double | Yes |
| writeCacheHitRatio | Double | Yes |
| totalCacheHitRatio | Double | Yes |
| totalCacheHitRatioMax | Double | Yes |
| writePending | Int64 | Yes |
| readIoDensity | Double | Yes |
| writeIoDensity | Double | Yes |
| totalIoDensity | Double | Yes |
| totalIoDensityMax | Double | Yes |
| compressionSavingsPercent | Double | Yes |
| compressionSavingsSpace | Double | Yes |
| totalTimeToFull | Double | Yes |
| confidenceIntervalTimeToFull | Double | Yes |
| accessed | Int32 | Yes |
| frontend | String | Yes |
| backend | String | Yes |
| timestampPK | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_node_dimension | storage_node_dimension | one JOIN: storageNodeTk = storage_node_dimension.tk |
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| business_entity_dimension | business_entity_dimension | one JOIN: businessEntityTk = business_entity_dimension.tk |
| host_group_dimension | host_group_dimension | one JOIN: hostGroupTk = host_group_dimension.tk |
| k8s_namespace_group_dimension | k8s_namespace_group_dimension | one JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk |
| application_group_dimension | application_group_dimension | one JOIN: applicationGroupTk = application_group_dimension.tk |
| k8s_namespace_dimension | k8s_namespace_dimension | one JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk |
| service_level_dimension | service_level_dimension | one JOIN: serviceLevelTk = service_level_dimension.tk |
| tier_dimension | tier_dimension | one JOIN: tierTk = tier_dimension.tk |
| application_dimension | application_dimension | one JOIN: applicationTk = application_dimension.tk |
| time_dimension | time_dimension | one JOIN: timeTk = time_dimension.tk |
| storage_pool_dimension | storage_pool_dimension | one JOIN: storagePoolTk = storage_pool_dimension.tk |
| host_dimension | host_dimension | one JOIN: hostTk = host_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
| volume_dimension | volume_dimension | one JOIN: volumeTk = volume_dimension.tk |