Database Schema Reference for dwh_capacity
Suggest changes
PDFs
This reference provides detailed schema information for the dwh_capacity database, including table structures, field definitions, data types, and relationships.
Tables and Views
application_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Application name |
description |
String |
Application description |
priority |
String |
Priority level |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
application_group_bridge
| Field | Type | Description |
|---|---|---|
appGroupTk |
Integer |
Application group technical key |
appTk |
Integer |
Application technical key |
isRep |
String |
Representative flag |
application_group_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
repApp |
String |
Representative application |
repAppTk |
Integer |
Representative application technical key |
cardinality |
Integer |
Group cardinality |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
business_entity_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
fullname |
String |
Full entity name |
tenant |
String |
Tenant name |
lob |
String |
Line of business |
businessUnit |
String |
Business unit |
project |
String |
Project name |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
capacity_type
Primary Key: type
| Field | Type | Description |
|---|---|---|
type |
String |
Capacity type |
used |
String |
Used flag |
vmSpecific |
String |
VM-specific flag |
replicationSpecific |
String |
Replication-specific flag |
description |
String |
Description |
Relationships:
-
vm_capacity_fact (one-to-many)
cardinals
| Field | Type | Description |
|---|---|---|
digit |
Integer |
Cardinal number |
chargeback_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storageTk |
Integer |
Storage technical key |
storagePoolTk |
Integer |
Storage pool technical key |
internalVolumeTk |
Integer |
Internal volume technical key |
qtreeTk |
Integer |
Qtree technical key |
hostTk |
Integer |
Host technical key |
hostGroupTk |
Integer |
Host group technical key |
applicationTk |
Integer |
Application technical key |
applicationGroupTk |
Integer |
Application group technical key |
tierTk |
Integer |
Tier technical key |
serviceLevelTk |
Integer |
Service level technical key |
businessUnit |
String |
Business unit |
businessEntityTk |
Integer |
Business entity technical key |
k8sNamespaceTk |
Integer |
Kubernetes namespace technical key |
k8sNamespaceGroupTk |
Integer |
Kubernetes namespace group technical key |
protectionType |
String |
Protection type |
storageAccessType |
String |
Storage access type |
resourceName |
String |
Resource name |
resourceType |
String |
Resource type |
mappedByVM |
String |
Mapped by VM flag |
virtualStorage |
String |
Virtual storage flag |
provisionedCapacityMB |
Long |
Provisioned capacity (MB) |
usedCapacityMB |
Long |
Used capacity (MB) |
Relationships:
-
volume_fact_current (one-to-one)
-
volume_history_capacity_fact (one-to-many)
-
internal_volume_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
business_entity_dimension (many-to-one)
-
host_group_dimension (many-to-one)
-
k8s_namespace_group_dimension (many-to-one)
-
application_group_dimension (many-to-one)
-
k8s_namespace_dimension (many-to-one)
-
service_level_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
application_dimension (many-to-one)
-
qtree_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
host_dimension (many-to-one)
-
date_dimension (many-to-one)
datastore_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
naturalKey |
String |
Natural key |
name |
String |
Datastore name |
moid |
String |
Managed object ID |
virtualCenterIp |
String |
vCenter IP address |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
vm_capacity_fact (one-to-many)
date_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
fullDate |
Date |
Full date |
dayInMonth |
Integer |
Day in month |
dayInYear |
Integer |
Day in year |
dateYear |
Integer |
Year |
yearLabel |
String |
Year label |
monthNum |
Integer |
Month number |
monthLabel |
String |
Month label |
dayInWeekNum |
Integer |
Day of week number |
quarter |
Integer |
Quarter |
quarterLabel |
String |
Quarter label |
dayInQuarter |
Integer |
Day in quarter |
repQuarter |
String |
Representative quarter |
repMonth |
String |
Representative month |
repWeek |
String |
Representative week |
repDay |
String |
Representative day |
repMonthOrLatest |
String |
Representative month or latest |
sspFlag |
String |
SSP flag |
latest |
String |
Latest flag |
future |
String |
Future flag |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
disk_group_capacity_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
disk_group_capacity_future_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
k8s_pvc_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_future_fact (one-to-many)
-
storage_node_capacity_fact (one-to-many)
disk_group_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storageTk |
Integer |
Storage technical key |
storagePoolTk |
Integer |
Storage pool technical key |
diskGroupTk |
Integer |
Disk group technical key |
capacityMB |
Long |
Total capacity (MB) |
usedCapacityMB |
Long |
Used capacity (MB) |
physicalDiskCapacityMB |
Long |
Physical disk capacity (MB) |
Relationships:
-
disk_group_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
date_dimension (many-to-one)
disk_group_capacity_future_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storageTk |
Integer |
Storage technical key |
storagePoolTk |
Integer |
Storage pool technical key |
diskGroupTk |
Integer |
Disk group technical key |
capacityMB |
Long |
Projected capacity (MB) |
usedCapacityMB |
Long |
Projected used capacity (MB) |
Relationships:
-
disk_group_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
date_dimension (many-to-one)
disk_group_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Disk group name |
identifier |
String |
Disk group identifier |
vendorDiskGroupType |
String |
Vendor disk group type |
diskType |
String |
Disk type |
status |
String |
Status |
redundancy |
String |
Redundancy level |
isVirtual |
String |
Virtual flag |
vendorTier |
String |
Vendor tier |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
disk_group_capacity_fact (one-to-many)
-
disk_group_capacity_future_fact (one-to-many)
host_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Host name |
identifier |
String |
Host identifier |
ip |
String |
IP address |
os |
String |
Operating system |
model |
String |
Hardware model |
manufacturer |
String |
Manufacturer |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
dataCenter |
String |
Data center location |
Alias |
String |
Host alias |
vm monthly license cost |
String |
Monthly VM license cost |
Business Entity |
String |
Business entity |
Service Level |
String |
Service level |
Relationships:
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
host_group_bridge
| Field | Type | Description |
|---|---|---|
hostGroupTk |
Integer |
Host group technical key |
hostTk |
Integer |
Host technical key |
isRep |
String |
Representative flag |
host_group_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
repHost |
String |
Representative host |
repHostTk |
Integer |
Representative host technical key |
cardinality |
Integer |
Group cardinality |
dateTk |
Integer |
Date technical key |
Relationships:
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
internal_volume_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storageTk |
Integer |
Storage technical key |
storagePoolTk |
Integer |
Storage pool technical key |
internalVolumeTk |
Integer |
Internal volume technical key |
virtualStorageTk |
Integer |
Virtual storage technical key |
tierTk |
Integer |
Tier technical key |
applicationTk |
Integer |
Application technical key |
applicationGroupTk |
Integer |
Application group technical key |
serviceLevelTk |
Integer |
Service level technical key |
businessUnit |
String |
Business unit |
businessEntityTk |
Integer |
Business entity technical key |
k8sNamespaceTk |
Integer |
Kubernetes namespace technical key |
k8sNamespaceGroupTk |
Integer |
Kubernetes namespace group technical key |
storageAccessType |
String |
Storage access type |
protectionType |
String |
Protection type |
allocatedCapacityMB |
Long |
Allocated capacity (MB) |
consumedCapacityMB |
Long |
Consumed capacity (MB) |
usedCapacityMB |
Long |
Used capacity (MB) |
dataUsedCapacityMB |
Long |
Data used capacity (MB) |
dataUnusedCapacityMB |
Long |
Data unused capacity (MB) |
snapshotAllocatedCapacityMB |
Long |
Snapshot allocated capacity (MB) |
snapshotUsedCapacityMB |
Long |
Snapshot used capacity (MB) |
totalCloneSavedCapacityMB |
Long |
Total clone saved capacity (MB) |
dedupeRatio |
Decimal |
Deduplication ratio |
dedupeSavingsGB |
Decimal |
Deduplication savings (GB) |
rawToUsableRatio |
Decimal |
Raw to usable ratio |
snapshotCount |
Integer |
Snapshot count |
lastSnapshotTime |
DateTimeOffset |
Last snapshot timestamp |
compressionRatio |
Decimal |
Compression ratio |
compressionSavingsGB |
Decimal |
Compression savings (GB) |
compressionSavingsPercent |
Decimal |
Compression savings (%) |
objectStoreUsedSpaceGB |
Decimal |
Object store used space (GB) |
Relationships:
-
service_level_dimension (many-to-one)
-
internal_volume_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
business_entity_dimension (many-to-one)
-
application_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
date_dimension (many-to-one)
-
k8s_namespace_group_dimension (many-to-one)
-
application_group_dimension (many-to-one)
-
k8s_namespace_dimension (many-to-one)
internal_volume_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Volume name |
identifier |
String |
Volume identifier |
storagePoolIdentifier |
String |
Storage pool identifier |
storageName |
String |
Storage name |
storageIP |
String |
Storage IP address |
type |
String |
Volume type |
virtualStorage |
String |
Virtual storage |
spaceGuarantee |
String |
Space guarantee |
thinProvisioningSupported |
String |
Thin provisioning support flag |
thinProvisioned |
String |
Thin provisioned flag |
uuid |
String |
UUID |
flexGroupIdentifier |
String |
FlexGroup identifier |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
k8s_cluster_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
Cluster identifier |
name |
String |
Cluster name |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
k8s_pvc_capacity_fact (one-to-many)
k8s_namespace_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
Namespace identifier |
name |
String |
Namespace name |
clusterName |
String |
Cluster name |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
k8s_pvc_capacity_fact (one-to-many)
k8s_namespace_group_bridge
| Field | Type | Description |
|---|---|---|
k8sNamespaceGroupTk |
Integer |
Namespace group technical key |
k8sNamespaceTk |
Integer |
Namespace technical key |
isRep |
String |
Representative flag |
k8s_namespace_group_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
repK8sNamespace |
String |
Representative namespace |
repK8sNamespaceTk |
Integer |
Representative namespace technical key |
cardinality |
Integer |
Group cardinality |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
k8s_node_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
Node identifier |
name |
String |
Node name |
clusterName |
String |
Cluster name |
internalIp |
String |
Internal IP address |
osImage |
String |
OS image |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
vm_capacity_fact (one-to-many)
k8s_pv_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
PV identifier |
name |
String |
PV name |
clusterName |
String |
Cluster name |
phase |
String |
PV phase |
pvcName |
String |
PVC name |
storageClass |
String |
Storage class |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
k8s_pvc_capacity_fact (one-to-many)
k8s_pvc_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
pvcTk |
Integer |
PVC technical key |
clusterTk |
Integer |
Cluster technical key |
namespaceTk |
Integer |
Namespace technical key |
pvTk |
Integer |
PV technical key |
pvSizeBytes |
Long |
PV size (bytes) |
pvcSizeBytes |
Long |
PVC size (bytes) |
Relationships:
-
k8s_pvc_dimension (many-to-one)
-
k8s_cluster_dimension (many-to-one)
-
k8s_namespace_dimension (many-to-one)
-
date_dimension (many-to-one)
-
k8s_pv_dimension (many-to-one)
k8s_pvc_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
PVC identifier |
name |
String |
PVC name |
clusterName |
String |
Cluster name |
namespaceName |
String |
Namespace name |
pvName |
String |
PV name |
phase |
String |
PVC phase |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
k8s_pvc_capacity_fact (one-to-many)
k8s_workload_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
Workload identifier |
name |
String |
Workload name |
clusterName |
String |
Cluster name |
namespaceName |
String |
Namespace name |
type |
String |
Workload type |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
qtree_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storageTk |
Integer |
Storage technical key |
storagePoolTk |
Integer |
Storage pool technical key |
internalVolumeTk |
Integer |
Internal volume technical key |
qtreeTk |
Integer |
Qtree technical key |
virtualStorageTk |
Integer |
Virtual storage technical key |
tierTk |
Integer |
Tier technical key |
serviceLevelTk |
Integer |
Service level technical key |
applicationTk |
Integer |
Application technical key |
applicationGroupTk |
Integer |
Application group technical key |
businessUnit |
String |
Business unit |
businessEntityTk |
Integer |
Business entity technical key |
k8sNamespaceTk |
Integer |
Kubernetes namespace technical key |
k8sNamespaceGroupTk |
Integer |
Kubernetes namespace group technical key |
storageAccessType |
String |
Storage access type |
protectionType |
String |
Protection type |
hardLimitCapacityMB |
Long |
Hard limit capacity (MB) |
softLimitCapacityMB |
Long |
Soft limit capacity (MB) |
usedCapacityMB |
Long |
Used capacity (MB) |
rawToUsableRatio |
Decimal |
Raw to usable ratio |
missingQuotaLimits |
String |
Missing quota limits flag |
Relationships:
-
internal_volume_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
business_entity_dimension (many-to-one)
-
k8s_namespace_group_dimension (many-to-one)
-
application_group_dimension (many-to-one)
-
k8s_namespace_dimension (many-to-one)
-
service_level_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
application_dimension (many-to-one)
-
qtree_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
date_dimension (many-to-one)
qtree_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Qtree name |
identifier |
String |
Qtree identifier |
storageIdentifier |
String |
Storage identifier |
type |
String |
Qtree type |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Tier |
String |
Tier annotation |
Relationships:
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
service_level_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Service level name |
sequence |
Integer |
Sequence |
cost |
Decimal |
Cost |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
sp_time_to_fill
Primary Key: saspFactTk
| Field | Type | Description |
|---|---|---|
saspFactTk |
Integer |
Storage pool fact technical key |
daysToStoragePoolFull |
Integer |
Days until storage pool full |
dateAtStoragePoolFull |
Date |
Date storage pool will be full |
Relationships:
-
storage_and_storage_pool_capacity_fact (one-to-one)
storage_and_storage_pool_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storagePoolTk |
Integer |
Storage pool technical key |
storageTk |
Integer |
Storage technical key |
tierTk |
Integer |
Tier technical key |
backend |
String |
Backend flag |
isVirtual |
String |
Virtual flag |
capacityMB |
Long |
Total capacity (MB) |
rawCapacityMB |
Long |
Raw capacity (MB) |
usedCapacityMB |
Long |
Used capacity (MB) |
usedRawCapacityMB |
Long |
Used raw capacity (MB) |
snapshotUsedCapacityMB |
Long |
Snapshot used capacity (MB) |
snapshotUsedRawCapacityMB |
Long |
Snapshot used raw capacity (MB) |
softLimitCapacityMB |
Long |
Soft limit capacity (MB) |
unconfiguredRawCapacityMB |
Long |
Unconfigured raw capacity (MB) |
spareRawCapacityMB |
Long |
Spare raw capacity (MB) |
failedRawCapacityMB |
Long |
Failed raw capacity (MB) |
volumeCapacityMB |
Long |
Volume capacity (MB) |
unusedVolumeCapacityMB |
Long |
Unused volume capacity (MB) |
volumeConsumedCapacityMB |
Long |
Volume consumed capacity (MB) |
mappedVolumeCapacityMB |
Long |
Mapped volume capacity (MB) |
maskedVolumeCapacityMB |
Long |
Masked volume capacity (MB) |
internalVolumeAllocatedCapacityMB |
Long |
Internal volume allocated capacity (MB) |
internalVolumeUsedCapacityMB |
Long |
Internal volume used capacity (MB) |
internalVolumeConsumedCapacityMB |
Long |
Internal volume consumed capacity (MB) |
dedupeRatio |
Decimal |
Deduplication ratio |
dedupeSavingsGB |
Decimal |
Deduplication savings (GB) |
compressionRatio |
Decimal |
Compression ratio |
compressionSavingsGB |
Decimal |
Compression savings (GB) |
compressionSavingsPercent |
Decimal |
Compression savings (%) |
objectStoreUsedSpaceGB |
Decimal |
Object store used space (GB) |
compactionRatio |
Decimal |
Compaction ratio |
compactionSavingsGB |
Decimal |
Compaction savings (GB) |
Relationships:
-
sp_time_to_fill (one-to-one)
-
volume_history_capacity_fact (one-to-many)
-
storage_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
date_dimension (many-to-one)
storage_and_storage_pool_capacity_future_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storagePoolTk |
Integer |
Storage pool technical key |
storageTk |
Integer |
Storage technical key |
tierTk |
Integer |
Tier technical key |
backend |
String |
Backend flag |
isVirtual |
String |
Virtual flag |
capacityMB |
Long |
Projected capacity (MB) |
rawCapacityMB |
Long |
Projected raw capacity (MB) |
usedCapacityMB |
Long |
Projected used capacity (MB) |
usedRawCapacityMB |
Long |
Projected used raw capacity (MB) |
Relationships:
-
storage_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
date_dimension (many-to-one)
storage_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Storage name |
identifier |
String |
Storage identifier |
ip |
String |
IP address |
model |
String |
Storage model |
manufacturer |
String |
Manufacturer |
serialNumber |
String |
Serial number |
microcodeVersion |
String |
Microcode version |
family |
String |
Storage family |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
disk_group_capacity_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
disk_group_capacity_future_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_future_fact (one-to-many)
-
storage_node_capacity_fact (one-to-many)
storage_node_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
storageTk |
Integer |
Storage technical key |
storageNodeTk |
Integer |
Storage node technical key |
tierTk |
Integer |
Tier technical key |
totalNodeCapacityUtilizationMB |
Long |
Total node capacity utilization (MB) |
usableNodeCapacityUtilizationMB |
Long |
Usable node capacity utilization (MB) |
usedNodeCapacityUtilizationMB |
Long |
Used node capacity utilization (MB) |
usedMetaDataNodeCapacityUtilizationMB |
Long |
Used metadata capacity utilization (MB) |
allowedMetaDataNodeCapacityUtilizationMB |
Long |
Allowed metadata capacity utilization (MB) |
Relationships:
-
storage_node_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
date_dimension (many-to-one)
storage_node_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Node name |
identifier |
String |
Node identifier |
version |
String |
Node version |
model |
String |
Node model |
serialNumber |
String |
Serial number |
siteName |
String |
Site name |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
ActiveIQ |
String |
ActiveIQ annotation |
Relationships:
-
storage_node_capacity_fact (one-to-many)
storage_pool_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
identifier |
String |
Pool identifier |
name |
String |
Pool name |
storageName |
String |
Storage name |
storageIP |
String |
Storage IP |
type |
String |
Pool type |
redundancy |
String |
Redundancy level |
thinProvisioningSupported |
String |
Thin provisioning support flag |
isVirtual |
String |
Virtual flag |
usesFlashPools |
String |
Uses flash pools flag |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Tier |
String |
Tier annotation |
Province |
String |
Province annotation |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
disk_group_capacity_fact (one-to-many)
-
disk_group_capacity_future_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_future_fact (one-to-many)
tier_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
Tier name |
sequence |
Integer |
Sequence |
cost |
Decimal |
Cost |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
internal_volume_capacity_fact (one-to-many)
-
chargeback_fact (one-to-many)
-
vm_capacity_fact (one-to-many)
-
qtree_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_fact (one-to-many)
-
volume_history_capacity_fact (one-to-many)
-
storage_and_storage_pool_capacity_future_fact (one-to-many)
-
storage_node_capacity_fact (one-to-many)
vm_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
hostTk |
Integer |
Host technical key |
storageTk |
Integer |
Storage technical key |
virtualStorageTk |
Integer |
Virtual storage technical key |
internalVolumeTk |
Integer |
Internal volume technical key |
qtreeTk |
Integer |
Qtree technical key |
hostGroupTk |
Integer |
Host group technical key |
applicationTk |
Integer |
Application technical key |
applicationGroupTk |
Integer |
Application group technical key |
tierTk |
Integer |
Tier technical key |
serviceLevelTk |
Integer |
Service level technical key |
vmTk |
Integer |
VM technical key |
dataStoreTk |
Integer |
Datastore technical key |
dataStoreName |
String |
Datastore name |
dataStoreId |
Long |
Datastore ID |
virtualCenterIp |
String |
vCenter IP |
businessUnit |
String |
Business unit |
businessEntityTk |
Integer |
Business entity technical key |
k8sNodeTk |
Integer |
Kubernetes node technical key |
storageAccessType |
String |
Storage access type |
capacityType |
String |
Capacity type |
actualMB |
Long |
Actual capacity (MB) |
provisionedMB |
Long |
Provisioned capacity (MB) |
Relationships:
-
internal_volume_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
business_entity_dimension (many-to-one)
-
k8s_node_dimension (many-to-one)
-
host_group_dimension (many-to-one)
-
vm_dimension (many-to-one)
-
application_group_dimension (many-to-one)
-
service_level_dimension (many-to-one)
-
capacity_type (many-to-one)
-
tier_dimension (many-to-one)
-
application_dimension (many-to-one)
-
datastore_dimension (many-to-one)
-
qtree_dimension (many-to-one)
-
host_dimension (many-to-one)
-
date_dimension (many-to-one)
vm_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
name |
String |
VM name |
naturalKey |
String |
Natural key |
os |
String |
Operating system |
virtualCenterIp |
String |
vCenter IP |
ips |
String |
IP addresses |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Relationships:
-
vm_capacity_fact (one-to-many)
volume_capacity_fact
| Field | Type | Description |
|---|---|---|
volumeTk |
Integer |
Volume technical key |
chargebackFactTk |
Integer |
Chargeback fact technical key |
storageAndSpFactTk |
Integer |
Storage and pool fact technical key |
hostTk |
Integer |
Host technical key |
storageTk |
Integer |
Storage technical key |
hostGroupTk |
Integer |
Host group technical key |
tierTk |
Integer |
Tier technical key |
serviceLevelTk |
Integer |
Service level technical key |
storagePoolTk |
Integer |
Storage pool technical key |
internalVolumeTk |
Integer |
Internal volume technical key |
qtreeTk |
Integer |
Qtree technical key |
k8sNamespaceTk |
Integer |
Kubernetes namespace technical key |
k8sNamespaceGroupTk |
Integer |
Kubernetes namespace group technical key |
isVirtual |
String |
Virtual flag |
isBackend |
String |
Backend flag |
protectionType |
String |
Protection type |
isAccessed |
String |
Accessed flag |
isOrphaned |
String |
Orphaned flag |
isProtection |
String |
Protection flag |
isUnused |
String |
Unused flag |
provisionedCapacityMB |
Long |
Provisioned capacity (MB) |
accessedCapacityMB |
Long |
Accessed capacity (MB) |
orphanedCapacityMB |
Long |
Orphaned capacity (MB) |
protectionCapacityMB |
Long |
Protection capacity (MB) |
unusedCapacityMB |
Long |
Unused capacity (MB) |
daysSinceLastAccessed |
Integer |
Days since last accessed |
volume_dimension
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
storageIdentifier |
String |
Storage identifier |
name |
String |
Volume name |
label |
String |
Volume label |
thinProvisioned |
String |
Thin provisioned flag |
type |
String |
Volume type |
isVirtual |
String |
Virtual flag |
meta |
String |
Metadata flag |
snapshot |
String |
Snapshot flag |
technologyType |
String |
Technology type |
uuid |
String |
UUID |
isMainframe |
String |
Mainframe flag |
url |
String |
Reference URL |
id |
Long |
Unique identifier |
latest |
String |
Latest flag |
dateTk |
Integer |
Date technical key |
Business Entity |
String |
Business entity annotation |
Tier |
String |
Tier annotation |
Relationships:
-
volume_history_capacity_fact (one-to-many)
volume_fact_current
Primary Key: volumeId
| Field | Type | Description |
|---|---|---|
chargebackFactTk |
Integer |
Chargeback fact technical key |
volumeId |
Long |
Volume ID |
storageId |
Long |
Storage ID |
volumeName |
String |
Volume name |
volumeType |
String |
Volume type |
thinProvisioned |
String |
Thin provisioned flag |
isVirtual |
String |
Virtual flag |
snapshot |
String |
Snapshot flag |
technologyType |
String |
Technology type |
physicalUsableMB |
Long |
Physical usable capacity (MB) |
physicalRawMB |
Long |
Physical raw capacity (MB) |
provisionedUsableMB |
Long |
Provisioned usable capacity (MB) |
provisionedRawMB |
Long |
Provisioned raw capacity (MB) |
Relationships:
-
chargeback_fact (many-to-one)
volume_history_capacity_fact
Primary Key: tk, dateTk
| Field | Type | Description |
|---|---|---|
tk |
Integer |
Technical key |
dateTk |
Integer |
Date technical key |
volumeTk |
Integer |
Volume technical key |
chargebackFactTk |
Integer |
Chargeback fact technical key |
storageAndSpFactTk |
Integer |
Storage and pool fact technical key |
hostTk |
Integer |
Host technical key |
storageTk |
Integer |
Storage technical key |
hostGroupTk |
Integer |
Host group technical key |
tierTk |
Integer |
Tier technical key |
serviceLevelTk |
Integer |
Service level technical key |
storagePoolTk |
Integer |
Storage pool technical key |
internalVolumeTk |
Integer |
Internal volume technical key |
qtreeTk |
Integer |
Qtree technical key |
k8sNamespaceTk |
Integer |
Kubernetes namespace technical key |
k8sNamespaceGroupTk |
Integer |
Kubernetes namespace group technical key |
isVirtual |
String |
Virtual flag |
isBackend |
String |
Backend flag |
protectionType |
String |
Protection type |
isAccessed |
String |
Accessed flag |
isOrphaned |
String |
Orphaned flag |
isProtection |
String |
Protection flag |
isUnused |
String |
Unused flag |
isMasked |
String |
Masked flag |
isMapped |
String |
Mapped flag |
provisionedCapacityMB |
Long |
Provisioned capacity (MB) |
accessedCapacityMB |
Long |
Accessed capacity (MB) |
orphanedCapacityMB |
Long |
Orphaned capacity (MB) |
protectionCapacityMB |
Long |
Protection capacity (MB) |
unusedCapacityMB |
Long |
Unused capacity (MB) |
consumedCapacityMB |
Long |
Consumed capacity (MB) |
daysSinceLastAccessed |
Integer |
Days since last accessed |
Relationships:
-
chargeback_fact (many-to-one)
-
internal_volume_dimension (many-to-one)
-
storage_dimension (many-to-one)
-
storage_and_storage_pool_capacity_fact (many-to-one)
-
host_group_dimension (many-to-one)
-
k8s_namespace_group_dimension (many-to-one)
-
service_level_dimension (many-to-one)
-
tier_dimension (many-to-one)
-
storage_pool_dimension (many-to-one)
-
qtree_dimension (many-to-one)
-
host_dimension (many-to-one)
-
date_dimension (many-to-one)
-
volume_dimension (many-to-one)
volume_last_accessed_time
Primary Key: volumeName, storageIdentifier
| Field | Type | Description |
|---|---|---|
volumeId |
Long |
Volume ID |
volumeName |
String |
Volume name |
storageIdentifier |
String |
Storage identifier |
lastAccessed |
DateTimeOffset |
Last accessed timestamp |