View ocum.storagesummary | Generated by SchemaSpy |
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: