View ocum.aggregatestoragepoollivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventoryaggregate`.`objid` AS `Id`,`inventoryaggregate`.`name` AS `name`,`ocum`.`aggregate`.`healthStatus` AS `healthStatus`,`inventorystoragepool`.`objid` AS `storagePoolid`,`inventorystoragepool`.`name` AS `storagePoolName`,0 AS `storagePoolHealthStatus`,`inventorystoragepool`.`diskCount` AS `containerDisksCount`,`inventorystoragepoolaggregaterelationship`.`usedCapacity` AS `allocatedCache`,`inventorystoragepoolaggregaterelationship`.`allocatedUnitCount` AS `allocationUnits` from (((`netapp_model_view`.`storage_pool` `inventorystoragepool` join `netapp_model_view`.`storage_pool_aggregate_relationship` `inventorystoragepoolaggregaterelationship` on((`inventorystoragepool`.`objid` = `inventorystoragepoolaggregaterelationship`.`storagePoolId`))) join `netapp_model_view`.`aggregate` `inventoryaggregate` on((`inventoryaggregate`.`objid` = `inventorystoragepoolaggregaterelationship`.`aggregateId`))) join `ocum`.`aggregate` on((`ocum`.`aggregate`.`id` = `inventoryaggregate`.`objid`)))
Possibly Referenced Tables/Views: