View ocum_report_birt.volumecapacityutilization 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
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumeName varchar 255 Textual name
state varchar 255  √  null
clusterId bigint 19
clusterName varchar 255  √  null
vserverId bigint 19
vserverName varchar 255  √  null
totalDataCapacity bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
usedDataCapacity bigint 19  √  null Used size of the volume in bytes
availableDataCapacity bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
snapshotUsedCapacity double 22  √  null
snapshotAvailableCapacity double 22  √  null
snapshotTotalCapacity bigint 19  √  null The size (in bytes) in the volume that has been set aside as reserve for snapshot usage
quotaCommitted bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
quotaOverCommitted bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
numberOfInodes bigint 19  √  null Total user-visible file (inode) count, i.e., current maximum number of user-visible files (inodes) that this volume can currently hold. ZAPIs: volume-get-iter volume-inode-attributes files-total
numberOfInodesUsed bigint 19  √  null Number of user-visible files (inodes) used. This field is valid only when the volume is online. ZAPIs: volume-get-iter volume-inode-attributes files-used
daysToFull bigint unsigned 20  √  null
bytesUsedPerDay double 22  √  0
isSnapshotAutoDeleteEnabled varchar 1024  √  null
dedupeEnabled varchar 1024  √  null
compressionState varchar 1024  √  null
deduplicationSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
compressionSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
isThinProvisioned varchar 1024  √  null
autoGrowState varchar 1024  √  null
spaceGuarantee varchar 255  √  null
growthRateSensitivityThreshold varchar 255  √  null
growthRateThreshold varchar 255  √  null
spaceFullThreshold varchar 255  √  null
spaceNearlyFullThreshold varchar 255  √  null
daysUntilFullThreshold varchar 255  √  null
snapshotCountThreshold varchar 255  √  null
snapshotReserveDaysUntilFullThreshold varchar 255  √  null
SnapshotFullThreshold varchar 255  √  null
quotaNearlyOvercommittedThreshold varchar 255  √  null
quotaOvercommittedThreshold varchar 255  √  null
inodesNearlyFullThreshold varchar 255  √  null
inodesFullThreshold varchar 255  √  null
cachingPolicy varchar 255  √  null raw cache policy associated with volumes
cacheRetentionPriority varchar 255  √  null raw cache retention priority associated with volumes
snapLockType varchar 255  √  null
expiryDate varchar 64  √  null
tieringPolicy varchar 255  √  null Identifies assicated tiering policy for a volume

Analyzed at Tue Apr 23 04:53 EDT 2019

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'))