View ocum_report_birt.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
clusterName varchar 255 Textual name
haPair varchar 255  √  null
ontapVersion varchar 1024  √  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 04:53 EDT 2019

View Definition:
select `clusterunconfiguredcapacitymapping`.`ClusterName` AS `clusterName`,cast(`halevelmapping`.`haPairName` as char(255) charset utf8mb4) AS `haPair`,`halevelmapping`.`ontapVersion` AS `ontapVersion`,`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_report_birt`.`clusterunconfiguredcapacitymapping` join `ocum_report_birt`.`halevelmapping` on((`halevelmapping`.`clusterId` = `clusterunconfiguredcapacitymapping`.`objid`)))
 
Possibly Referenced Tables/Views: