View ocum_report_birt.aggregatecapacityutilization 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
aggrId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggrName varchar 255 Textual name
clusterId bigint 19
clusterName varchar 255  √  null
haPair varchar 255  √  null
haPairId bigint 19  √  null Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
nodeId bigint 19
totalDataCapacity bigint 19  √  null Total size (in bytes) of the referenced file system . If the referenced file system is restricted or offline, a value of 0 is returned
usedDataCapacity bigint 19  √  null Number of bytes used in the referenced file system. If the referenced file system is restricted or offline, a value of 0 is returned
availableDataCapacity bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-space-attributes size-available
snapshotReserveUsedCapacity bigint 19  √  null Number of bytes used in the referenced file system. If the referenced file system is restricted or offline, a value of 0 is returned
snapshotReserveAvailCapacity bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-snapshot-attributes size-available
snapshotReserveTotalCapacity bigint 19  √  null Total size (in bytes) of the referenced file system. If the referenced file system is restricted or offline, a value 0 is returned
totalCommitted bigint 19  √  null A derived measure of the committed capacity of all Volumes on this Aggregate. "Committed" here is defined as the total capacity a volume might consume if entirely full.
bytesUsedPerDay double 22  √  0
daysToFull bigint unsigned 20  √  null
aggregateType enum 17  √  null Aggregate Derived Type.
raidType varchar 255  √  null
state varchar 255  √  null
growthRateSensitivityThreshold varchar 255  √  null
growthRateThreshold varchar 255  √  null
spaceFullThreshold varchar 255  √  null
spaceNearlyFullThreshold varchar 255  √  null
overcommittedThreshold varchar 255  √  null
nearlyOvercommittedThreshold varchar 255  √  null
daysUntilFullThreshold varchar 255  √  null
snapshotFullThreshold varchar 255  √  null
snapLockType varchar 255  √  null
usedExternalCapacityTierSpace bigint 19  √  null
objectStoreName varchar 255  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

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: