View ocum.storagesummary Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
resourceKey varchar 512
clusterName varchar 255 Textual name
haPair varchar 255  √  null
ontapVersion varchar 1024  √  null
clusterFqdn varchar 255  √  null
model varchar 255  √  null Hardware model of this node.
unconfiguredRawCapacity decimal 10,3  √  null
rawCapacity decimal 10,3  √  null
aggregateUsedCapacity decimal 10,3  √  null
aggregateCapacity decimal 10,3  √  null
volumeCapacity decimal 10,3  √  null
volumeUsedCapacity decimal 10,3  √  null
volumeProtectionCapacity decimal 10,3  √  null
allocatedLunCapacity decimal 10,3  √  null
unallocatedLunCapacity decimal 10,3  √  null
totalExternalCapacityTierLicensedSpace decimal 10,3  √  null
totalExternalCapacityTierLicensedSpaceUsed decimal 10,3  √  null
totalClusterStorageGridCapacitySpaceUsed decimal 10,3  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `clusterunconfiguredcapacitymapping`.`objid` AS `clusterId`,`clusterunconfiguredcapacitymapping`.`resourceKey` AS `resourceKey`,`clusterunconfiguredcapacitymapping`.`ClusterName` AS `clusterName`,cast(`halevelmapping`.`haPairName` as char(255) charset utf8mb4) AS `haPair`,`halevelmapping`.`ontapVersion` AS `ontapVersion`,`ocumschemacluster`.`fqdn` AS `clusterFqdn`,`halevelmapping`.`model` AS `model`,`ocum`.`na_numBytesToTeraBytes`(`clusterunconfiguredcapacitymapping`.`unconfiguredRawCapacity`) AS `unconfiguredRawCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`rawDiskBytesTotal`) AS `rawCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`aggregateBytesUsed`) AS `aggregateUsedCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`aggregateBytesTotal`) AS `aggregateCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`totalVolumeCapacity`) AS `volumeCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`volumeUsedCapacity`) AS `volumeUsedCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`volumeProtectionCapacity`) AS `volumeProtectionCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`assignedLunCapacity`) AS `allocatedLunCapacity`,`ocum`.`na_numBytesToTeraBytes`(`halevelmapping`.`unassignedLunCapacity`) AS `unallocatedLunCapacity`,`ocum`.`na_numBytesToTeraBytes`(`clusterunconfiguredcapacitymapping`.`TotExternalCapaityTierLicensedSpace`) AS `totalExternalCapacityTierLicensedSpace`,`ocum`.`na_numBytesToTeraBytes`(`clusterunconfiguredcapacitymapping`.`TotExternalCapacityTierLicensedSpaceUsed`) AS `totalExternalCapacityTierLicensedSpaceUsed`,`ocum`.`na_numBytesToTeraBytes`(`clusterunconfiguredcapacitymapping`.`TotExternalCapacityTierUnLicensedSpaceUsed`) AS `totalClusterStorageGridCapacitySpaceUsed` from ((`ocum`.`clusterunconfiguredcapacitymapping` join `ocum`.`halevelmapping` on((`halevelmapping`.`clusterId` = `clusterunconfiguredcapacitymapping`.`objid`))) join `ocum`.`cluster` `ocumschemacluster` on((`ocumschemacluster`.`cluster_id` = `halevelmapping`.`clusterId`)))
 
Possibly Referenced Tables/Views: