View ocum_report_birt.volumecapacityutilization | Generated by SchemaSpy |
View Definition:
select `inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`inventoryvolume`.`stateRaw` AS `state`,`inventoryvolume`.`clusterId` AS `clusterId`,(select `cluster`.`name` from `netapp_model_view`.`cluster` where (`cluster`.`objid` = `inventoryvolume`.`clusterId`)) AS `clusterName`,`inventoryvolume`.`vserverId` AS `vserverId`,(select `vserver`.`name` from `netapp_model_view`.`vserver` where (`vserver`.`objid` = `inventoryvolume`.`vserverId`)) AS `vserverName`,`inventoryvolume`.`sizeTotal` AS `totalDataCapacity`,`inventoryvolume`.`sizeUsed` AS `usedDataCapacity`,`inventoryvolume`.`sizeAvail` AS `availableDataCapacity`,`ocum`.`volume`.`dfSnapshotBytesUsed` AS `snapshotUsedCapacity`,`ocum`.`volume`.`dfSnapshotBytesAvail` AS `snapshotAvailableCapacity`,`inventoryvolume`.`snapshotReserveSize` AS `snapshotTotalCapacity`,`inventoryvolume`.`quotaCommitted` AS `quotaCommitted`,`inventoryvolume`.`quotaOverCommitted` AS `quotaOverCommitted`,`inventoryvolume`.`inodeFilesTotal` AS `numberOfInodes`,`inventoryvolume`.`inodeFilesUsed` AS `numberOfInodesUsed`,cast(floor(`calculationview`.`daysUntilFull`) as unsigned) AS `daysToFull`,`ocum`.`volumeregressioninfo`.`bytesUsedPerDay` AS `bytesUsedPerDay`,`ocum`.`na_boolToEnabledDisabled`(`inventoryvolume`.`isSnapshotAutoDeleteEnabled`) AS `isSnapshotAutoDeleteEnabled`,`ocum`.`na_boolToEnabledDisabled`((`inventoryvolume`.`sisStateRaw` = 'enabled')) AS `dedupeEnabled`,`ocum`.`na_boolToEnabledDisabled`((`inventoryvolume`.`isSisCompressionEnabled` = TRUE)) AS `compressionState`,`inventoryvolume`.`deduplicationSpaceSaved` AS `deduplicationSpaceSaved`,`inventoryvolume`.`compressionSpaceSaved` AS `compressionSpaceSaved`,`ocum`.`na_boolToYesNo`(((`inventoryvolume`.`spaceGuaranteeRaw` = 'none') or (`inventoryvolume`.`spaceGuaranteeRaw` = 'file'))) AS `isThinProvisioned`,`ocum`.`na_boolToEnabledDisabled`(((`inventoryvolume`.`autoSizeModeRaw` = 'grow') or (`inventoryvolume`.`autoSizeModeRaw` = 'grow_shrink'))) AS `autoGrowState`,`inventoryvolume`.`spaceGuaranteeRaw` AS `spaceGuarantee`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'event.growthRate.sensitivity') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `growthRateSensitivityThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'event.growthRate.minChangePct.volume') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `growthRateThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volSpaceFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `spaceFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volSpaceNearlyFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `spaceNearlyFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volDaysUntilFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `daysUntilFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volSnapshotCount') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `snapshotCountThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volSnapshotReserveDaysUntilFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `snapshotReserveDaysUntilFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volSnapshotFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `SnapshotFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volQuotaNearlyOvercommitted') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `quotaNearlyOvercommittedThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.volQuotaOvercommitted') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `quotaOvercommittedThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.inodesNearlyFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `inodesNearlyFullThreshold`,(select `ocum`.`optionchainvalue`.`optionValue` from `ocum`.`optionchainvalue` where ((`ocum`.`optionchainvalue`.`domainObject_id` = `inventoryvolume`.`objid`) and (`ocum`.`optionchainvalue`.`optionName` = 'threshold.inodesFull') and (`ocum`.`optionchainvalue`.`domainObject_type` in ('inventory.ontap.storage.FlexVol','inventory.ontap.storage.FlexGroup')))) AS `inodesFullThreshold`,`inventoryvolume`.`cachingPolicyRaw` AS `cachingPolicy`,`inventoryvolume`.`cacheRetentionPriorityRaw` AS `cacheRetentionPriority`,(case when isnull(`inventoryvolume`.`snapLockTypeRaw`) then 'non_snaplock' else `inventoryvolume`.`snapLockTypeRaw` end) AS `snapLockType`,(select `snaplock`.`volumeExpiryTime` from `netapp_model_view`.`snaplock` where (`snaplock`.`volumeId` = `inventoryvolume`.`objid`)) AS `expiryDate`,`inventoryvolume`.`tieringPolicyRaw` AS `tieringPolicy` from (((`netapp_model_view`.`volume` `inventoryvolume` join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) join `ocum`.`managedvolumecalculationsview` `calculationview` on((`calculationview`.`volumeId` = `inventoryvolume`.`objid`))) left join `ocum`.`volumeregressioninfo` on((`ocum`.`volumeregressioninfo`.`volume_id` = `inventoryvolume`.`objid`))) where (`inventoryvolume`.`derivedStyle` in ('FLEXVOL','FLEXGROUP'))