View ocum.aggregatecapacityutilizationview | Generated by SchemaSpy |
View Definition:
select `inventoryaggregate`.`objid` AS `aggrId`,`inventoryaggregate`.`name` AS `aggrName`,`inventoryaggregate`.`clusterId` AS `clusterId`,`ocumschemacluster`.`fqdn` AS `clusterFqdn`,(select `cluster`.`name` from `netapp_model_view`.`cluster` where (`cluster`.`objid` = `inventoryaggregate`.`clusterId`)) AS `clusterName`,(select `node`.`name` from `netapp_model_view`.`node` where (`node`.`objid` = `inventoryaggregate`.`nodeId`)) AS `clusterNodeName`,`inventoryaggregate`.`nodeId` AS `clusternodeId`,`inventoryaggregate`.`resourceKey` AS `resourcekey`,`hapair`.`haPairName` AS `haPair`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`sizeTotal`) AS `totalDataCapacity`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`sizeUsed`) AS `usedDataCapacity`,(case when ((`inventoryaggregate`.`sizeTotal` = 0) or isnull(`inventoryaggregate`.`sizeTotal`)) then NULL else round(((`inventoryaggregate`.`sizeUsed` * 100) / `inventoryaggregate`.`sizeTotal`),2) end) AS `usedDataCapacityPercentage`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`sizeAvail`) AS `availableDataCapacity`,(case when ((`inventoryaggregate`.`sizeTotal` = 0) or isnull(`inventoryaggregate`.`sizeTotal`)) then NULL else round(((`inventoryaggregate`.`sizeAvail` * 100) / `inventoryaggregate`.`sizeTotal`),2) end) AS `availableDataCapacityPercentage`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`snapshotSizeUsed`) AS `snapshotReserveUsedCapacity`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`snapshotSizeAvail`) AS `snapshotReserveAvailCapacity`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`snapshotSizeTotal`) AS `snapshotReserveTotalCapacity`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`totalCommitted`) AS `totalCommitted`,`ocum`.`aggregateregressioninfo`.`bytesUsedPerDay` AS `bytesUsedPerDay`,(case when ((`inventoryaggregate`.`sizeTotal` = 0) or isnull(`inventoryaggregate`.`sizeTotal`) or (`inventoryaggregate`.`totalCommitted` < `inventoryaggregate`.`sizeTotal`)) then 0 else round((((`inventoryaggregate`.`totalCommitted` - `inventoryaggregate`.`sizeTotal`) * 100) / `inventoryaggregate`.`sizeTotal`),2) end) AS `overCommittedCapacityPercentage`,cast((select floor(`ocum`.`aggregate`.`daysUntilFull`) from `ocum`.`aggregate` where (`inventoryaggregate`.`objid` = `ocum`.`aggregate`.`id`)) as unsigned) AS `daysToFull`,(case when ((`inventoryaggregate`.`sizeTotal` = 0) or isnull(`inventoryaggregate`.`sizeTotal`) or (`ocum`.`aggregateregressioninfo`.`bytesUsedPerDay` < 0)) then 0 else round(((`ocum`.`aggregateregressioninfo`.`bytesUsedPerDay` * 100) / `inventoryaggregate`.`sizeTotal`),2) end) AS `dailyGrowthRate`,ifnull(`inventoryaggregate`.`aggregateDerivedType`,'NOT_MAPPED') AS `aggregateType`,(case when isnull(`inventoryaggregate`.`raidTypeRaw`) then 'NOT_MAPPED' else `inventoryaggregate`.`raidType` end) AS `raidtype`,ifnull(`inventoryaggregate`.`stateRaw`,'NOT_MAPPED') AS `state`,(case when (`inventoryaggregate`.`isSnapLock` = FALSE) then 'non_snaplock' when isnull(`inventoryaggregate`.`isSnapLock`) then 'NOT_MAPPED' else `inventoryaggregate`.`snapLockTypeRaw` end) AS `snapLockType`,(case when ((`inventoryaggregate`.`snapshotSizeTotal` = 0) or isnull(`inventoryaggregate`.`snapshotSizeUsed`) or isnull(`inventoryaggregate`.`snapshotSizeTotal`)) then 0 when (`inventoryaggregate`.`snapshotSizeUsed` >= `inventoryaggregate`.`snapshotSizeTotal`) then 100 else format(((`inventoryaggregate`.`snapshotSizeUsed` * 100.0) / `inventoryaggregate`.`snapshotSizeTotal`),2) end) AS `snapshotReserveUsedPercentage`,(case when (isnull(`inventoryaggregate`.`snapshotSizeAvail`) or isnull(`inventoryaggregate`.`snapshotSizeTotal`) or (`inventoryaggregate`.`snapshotSizeTotal` = 0)) then 0 else format(((`inventoryaggregate`.`snapshotSizeAvail` * 100.0) / `inventoryaggregate`.`snapshotSizeTotal`),2) end) AS `snapshotReserveAvailPercentage`,`na_numBytesToGigaBytes`(`inventoryaggregate`.`totalUsedExternalLicensedSpace`) AS `usedExternalCapacityTierSpace`,(select `objectstore`.`name` from `netapp_model_view`.`objectstore_config` `objectstore` join `netapp_model_view`.`aggregate_objectstore_config_mapping` `objectstoremapping` where ((`objectstore`.`objid` = `objectstoremapping`.`objectstoreId`) and (`objectstoremapping`.`aggregateId` = `inventoryaggregate`.`objid`))) AS `objectStoreName` from ((((`netapp_model_view`.`aggregate` `inventoryaggregate` left join `ocum`.`hapairview` `hapair` on(((`inventoryaggregate`.`nodeId` = `hapair`.`node1Id`) or (`inventoryaggregate`.`nodeId` = `hapair`.`node2Id`)))) left join `ocum`.`aggregateregressioninfo` on((`inventoryaggregate`.`objid` = `ocum`.`aggregateregressioninfo`.`aggregate_id`))) join `ocum`.`aggregate` on((`inventoryaggregate`.`objid` = `ocum`.`aggregate`.`id`))) join `ocum`.`cluster` `ocumschemacluster` on((`inventoryaggregate`.`clusterId` = `ocumschemacluster`.`cluster_id`)))
Possibly Referenced Tables/Views: