View ocum_report_birt.clusterunconfiguredcapacitymapping 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
objid bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
ClusterName varchar 255 Textual name
TotExternalCapaityTierLicensedSpace bigint 19  √  null
unconfiguredRawCapacity decimal 60  √  null
TotExternalCapacityTierLicensedSpaceUsed decimal 41  √  null
TotExternalCapacityTierUnLicensedSpaceUsed decimal 41  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

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: