View ocum_report_birt.unprotectvolumeview 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
clusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterName varchar 255  √  null Textual name
SVM varchar 255  √  null Textual name
volume varchar 255 Textual name
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
daysToFull bigint unsigned 20  √  null
spaceFullThreshold varchar 255  √  null
spaceNearlyFullThreshold varchar 255  √  null
growthRateThreshold varchar 255  √  null
noofinodes 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
inodeutilization 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
quotaCommittedCapacity bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
quotaOvercommittedCapacity bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
snapshotAutodelete varchar 1024  √  null
deduplicationEnabled varchar 1024  √  null
dedupSpaceSavings bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
compressionEnabled varchar 1024  √  null
compressionSpaceSavings bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
thinProvisioning varchar 1024  √  null
autogrow varchar 1024  √  null
spaceGuarantee varchar 255  √  null
volumeState varchar 255  √  null
bytesUsedPerDay double 22  √  0
protectionRole varchar 13
snapLockType varchar 255  √  null
expiryDate varchar 64  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`inventoryvserver`.`name` AS `SVM`,`inventoryvolume`.`name` AS `volume`,`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`,cast(floor(`calculationview`.`daysUntilFull`) as unsigned) AS `daysToFull`,(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` = 'inventory.ontap.storage.FlexVol'))) 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` = 'inventory.ontap.storage.FlexVol'))) AS `spaceNearlyFullThreshold`,(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` = 'inventory.ontap.storage.FlexVol'))) AS `growthRateThreshold`,`inventoryvolume`.`inodeFilesTotal` AS `noofinodes`,`inventoryvolume`.`inodeFilesUsed` AS `inodeutilization`,`inventoryvolume`.`quotaCommitted` AS `quotaCommittedCapacity`,`inventoryvolume`.`quotaOverCommitted` AS `quotaOvercommittedCapacity`,`ocum`.`na_boolToEnabledDisabled`(`inventoryvolume`.`isSnapshotAutoDeleteEnabled`) AS `snapshotAutodelete`,`ocum`.`na_boolToEnabledDisabled`((`inventoryvolume`.`sisStateRaw` = 'enabled')) AS `deduplicationEnabled`,`inventoryvolume`.`deduplicationSpaceSaved` AS `dedupSpaceSavings`,`ocum`.`na_boolToEnabledDisabled`((`inventoryvolume`.`isSisCompressionEnabled` = TRUE)) AS `compressionEnabled`,`inventoryvolume`.`compressionSpaceSaved` AS `compressionSpaceSavings`,`ocum`.`na_boolToYesNo`((case when isnull(`inventoryvolume`.`spaceGuaranteeRaw`) then NULL when ((`inventoryvolume`.`spaceGuaranteeRaw` = 'none') or (`inventoryvolume`.`spaceGuaranteeRaw` = 'file')) then 1 else 0 end)) AS `thinProvisioning`,`ocum`.`na_boolToEnabledDisabled`(((`inventoryvolume`.`autoSizeModeRaw` = 'grow') or (`inventoryvolume`.`autoSizeModeRaw` = 'grow_shrink'))) AS `autogrow`,`inventoryvolume`.`spaceGuaranteeRaw` AS `spaceGuarantee`,`inventoryvolume`.`stateRaw` AS `volumeState`,`ocum`.`volumeregressioninfo`.`bytesUsedPerDay` AS `bytesUsedPerDay`,(case when ((`inventoryvolume`.`volTypeRaw` = 'rw') and isnull(`incominginventorysnapmirror`.`objid`) and isnull(`outgoinginventorysnapmirror`.`sourceVolumeId`)) then 'unprotected' when ((`inventoryvolume`.`volTypeRaw` = 'rw') and (`outgoinginventorysnapmirror`.`sourceVolumeId` is not null)) then 'protected' when ((`inventoryvolume`.`volTypeRaw` = 'dp') or ((`inventoryvolume`.`volTypeRaw` = 'rw') and (`incominginventorysnapmirror`.`objid` is not null) and ((`incominginventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'vault')))) then 'destination' else 'notApplicable' end) AS `protectionRole`,(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` from (((((((((`netapp_model_view`.`volume` `inventoryvolume` join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) left join `ocum`.`volumeregressioninfo` on((`ocum`.`volumeregressioninfo`.`volume_id` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryvolume`.`vserverId`))) left join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryvolume`.`clusterId`))) left join `netapp_model_view`.`snap_mirror` `incominginventorysnapmirror` on(((`incominginventorysnapmirror`.`destinationVolumeId` = `inventoryvolume`.`objid`) and ((`incominginventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'vault'))))) left join `ocum`.`volumeoutgoingrelationshipview` `outgoinginventorysnapmirror` on((`outgoinginventorysnapmirror`.`sourceVolumeId` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`snap_mirror_policy` `inventorysnapmirrorpolicy` on((`inventorysnapmirrorpolicy`.`objid` = `incominginventorysnapmirror`.`snapMirrorPolicyId`))) left join `netapp_model_view`.`job_schedule` `inventoryjobschedule` on((`inventoryjobschedule`.`objid` = `incominginventorysnapmirror`.`jobScheduleId`))) join `ocum`.`managedvolumecalculationsview` `calculationview` on(((`calculationview`.`volumeId` = `inventoryvolume`.`objid`) and (`inventoryvolume`.`derivedStyle` = 'FLEXVOL') and (`inventoryvolume`.`volTypeRaw` = 'rw') and isnull(`incominginventorysnapmirror`.`objid`) and isnull(`outgoinginventorysnapmirror`.`sourceVolumeId`))))