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