View ocum_report_birt.aggregatecapacityutilization | Generated by SchemaSpy |
View Definition:
select `inventoryaggregate`.`objid` AS `aggrId`,`inventoryaggregate`.`name` AS `aggrName`,`inventoryaggregate`.`clusterId` AS `clusterId`,(select `cluster`.`name` from `netapp_model_view`.`cluster` where (`cluster`.`objid` = `inventoryaggregate`.`clusterId`)) AS `clusterName`,`hapair`.`haPairName` AS `haPair`,`hapair`.`objid` AS `haPairId`,`inventoryaggregate`.`nodeId` AS `nodeId`,`inventoryaggregate`.`sizeTotal` AS `totalDataCapacity`,`inventoryaggregate`.`sizeUsed` AS `usedDataCapacity`,`inventoryaggregate`.`sizeAvail` AS `availableDataCapacity`,`inventoryaggregate`.`snapshotSizeUsed` AS `snapshotReserveUsedCapacity`,`inventoryaggregate`.`snapshotSizeAvail` AS `snapshotReserveAvailCapacity`,`inventoryaggregate`.`snapshotSizeTotal` AS `snapshotReserveTotalCapacity`,`inventoryaggregate`.`totalCommitted` AS `totalCommitted`,`ocum`.`aggregateregressioninfo`.`bytesUsedPerDay` AS `bytesUsedPerDay`,cast((select floor(`ocum`.`aggregate`.`daysUntilFull`) from `ocum`.`aggregate` where (`inventoryaggregate`.`objid` = `ocum`.`aggregate`.`id`)) as unsigned) AS `daysToFull`,`inventoryaggregate`.`aggregateDerivedType` AS `aggregateType`,`inventoryaggregate`.`raidTypeRaw` AS `raidType`,`inventoryaggregate`.`stateRaw` AS `state`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'event.growthRate.sensitivity') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `growthRateSensitivityThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'event.growthRate.minChangePct.aggregate') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `growthRateThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.aggrSpaceFull') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `spaceFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.aggrSpaceNearlyFull') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `spaceNearlyFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.aggrOvercommitted') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `overcommittedThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.aggrNearlyOvercommitted') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `nearlyOvercommittedThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.aggrDaysUntilFull') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `daysUntilFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryaggregate`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.aggrSnapshotFull') and (`ocum`.`optionchainvalue`.`domainObject_type` = 'inventory.ontap.storage.Aggregate'))) AS `snapshotFullThreshold`,(case when (`inventoryaggregate`.`isSnapLock` = FALSE) then 'non_snaplock' else `inventoryaggregate`.`snapLockTypeRaw` end) AS `snapLockType`,`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_report_birt`.`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`)))
Possibly Referenced Tables/Views: