View ocum.aggregatelivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventoryaggregate`.`objid` AS `id`,`inventoryaggregate`.`name` AS `name`,`ocum`.`aggregate`.`healthStatus` AS `healthStatus`,`inventoryaggregate`.`stateRaw` AS `state`,`inventoryclusternode`.`objid` AS `clusterNodeId`,`inventoryclusternode`.`name` AS `clusterNodeName`,`ocum`.`clusternode`.`healthStatus` AS `clusterNodeHealthStatus`,`inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`inventoryaggregate`.`sizeUsed` AS `dfBytesUsed`,`aggregatecalculationsview`.`dfBytesUsedPercent` AS `dfBytesUsedPercent`,`inventoryaggregate`.`sizeAvail` AS `dfBytesAvail`,`aggregatecalculationsview`.`dfBytesAvailPercent` AS `dfBytesAvailPercent`,`inventoryaggregate`.`sizeTotal` AS `dfBytesTotal`,`inventoryaggregate`.`totalCommitted` AS `dfBytesTotalCommitted`,`inventoryaggregate`.`raidStatus` AS `raidStatus`,`inventoryaggregate`.`aggregateDerivedType` AS `aggregateDerivedType`,`inventoryaggregate`.`totalUsedExternalLicensedSpace` AS `usedExternalTierCapacity`,(case when (`inventoryaggregate`.`raidTypeRaw` = 'raid_0') then 'raid0' when (`inventoryaggregate`.`raidTypeRaw` = 'raid_4') then 'raid4' else `inventoryaggregate`.`raidTypeRaw` end) AS `raidType`,(case when (`inventoryaggregate`.`isComposite` = TRUE) then 'fabricPool' when (`inventoryaggregate`.`aggregateTypeRaw` = 'ssd') then 'ssd' when (`inventoryaggregate`.`isHybridEnabled` = TRUE) then 'flashPool' when ((`inventoryaggregate`.`aggregateTypeRaw` = 'vmdisk') or (`inventoryaggregate`.`aggregateTypeRaw` = 'hdd') or (`inventoryaggregate`.`aggregateTypeRaw` = 'lun')) then 'standard' end) AS `aggregateType`,`inventoryaggregate`.`isHybridEnabled` AS `isHybridEnabled`,(case when isnull(`inventoryaggregate`.`isCftPreCommit`) then FALSE else `inventoryaggregate`.`isCftPreCommit` end) AS `isCftPrecommit`,`inventoryaggregate`.`hasLocalRoot` AS `hasLocalRoot`,`inventoryaggregate`.`hasPartnerRoot` AS `hasPartnerRoot`,`inventoryaggregate`.`totalStorageEfficiencyRatio` AS `totalStorageEfficiencyRatio`,`ocum`.`resourcepoolaggregates`.`resourcePool_id` AS `resourcePoolId`,`inventorycluster`.`versionGeneration` AS `versionGeneration`,`inventorycluster`.`versionMajor` AS `versionMajor`,`inventorycluster`.`versionMinor` AS `versionMinor`,sum(`inventoryplex`.`resyncPercent`) AS `resyncPercent`,`inventoryaggregate`.`mirrorStatusRaw` AS `mirrorStatusRaw`,(case when (`inventoryaggregate`.`isSnapLock` = FALSE) then 'non_snaplock' else `inventoryaggregate`.`snapLockTypeRaw` end) AS `snapLockType`,`ocumschemacluster`.`fqdn` AS `clusterFqdn` from (((((((((`netapp_model_view`.`aggregate` `inventoryaggregate` straight_join `ocum`.`aggregate` on((`ocum`.`aggregate`.`id` = `inventoryaggregate`.`objid`))) straight_join `netapp_model_view`.`node` `inventoryclusternode` on((`inventoryclusternode`.`objid` = `inventoryaggregate`.`nodeId`))) straight_join `ocum`.`clusternode` on((`ocum`.`clusternode`.`id` = `inventoryclusternode`.`objid`))) straight_join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryaggregate`.`clusterId`))) straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) straight_join `ocum`.`aggregatecalculationsview` on((`aggregatecalculationsview`.`aggregateId` = `inventoryaggregate`.`objid`))) left join `ocum`.`resourcepoolaggregates` on((`ocum`.`resourcepoolaggregates`.`aggregate_id` = `inventoryaggregate`.`objid`))) left join `netapp_model_view`.`plex` `inventoryplex` on((`inventoryplex`.`aggregateId` = `inventoryaggregate`.`objid`))) join `ocum`.`cluster` `ocumschemacluster` on((`ocumschemacluster`.`cluster_id` = `inventoryaggregate`.`clusterId`))) group by `inventoryaggregate`.`objid`
Possibly Referenced Tables/Views: