View ocum_report_birt.clusterunconfiguredcapacitymapping | Generated by SchemaSpy |
View Definition:
select `cluster`.`objid` AS `objid`,`cluster`.`name` AS `ClusterName`,`cluster`.`totalExternalLicensedSpace` AS `TotExternalCapaityTierLicensedSpace`,`diskcapacitymapping`.`unconfiguredRawCapacity` AS `unconfiguredRawCapacity`,sum((case when (`objectstore_space_detail`.`isLicensed` is true) then `objectstore_space_detail`.`usedSpace` else 0 end)) AS `TotExternalCapacityTierLicensedSpaceUsed`,sum((case when (`objectstore_space_detail`.`isLicensed` is false) then `objectstore_space_detail`.`usedSpace` else 0 end)) AS `TotExternalCapacityTierUnLicensedSpaceUsed` from ((`netapp_model_view`.`cluster` left join `ocum_report_birt`.`diskcapacitymapping` on((`cluster`.`objid` = `diskcapacitymapping`.`clusterId`))) left join `netapp_model_view`.`objectstore_space_detail` on((`cluster`.`objid` = `objectstore_space_detail`.`clusterId`))) group by `cluster`.`objid`
Possibly Referenced Tables/Views: