View ocum.aggregatestoragepoollivelistdtoview 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
Id bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
name varchar 255 Textual name
healthStatus int 10
storagePoolid bigint 19 Locally unique object identifier. ZAPI: storage-pool-get-iter.storage-pool-info
storagePoolName varchar 255 The cluster-wide unique name of the storage pool.
storagePoolHealthStatus int 10 0
containerDisksCount bigint 19 The number of disks that are part of the storage pool
allocatedCache bigint 19  √  null Capacity provisioned by aggregate from storage pool
allocationUnits bigint 19  √  null No of memory units provisioned by aggregate from storage pool

Analyzed at Tue Apr 23 05:29 EDT 2019

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: