View netapp_model_view.volume 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
objid bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
uuid varchar 255 Globally unique ID of the volume
resourceKey varchar 255  √  null
name varchar 255 Textual name
clusterId bigint 19
vserverId bigint 19
nodeId bigint 19  √  null
aggregateId bigint 19  √  null
exportPolicyId bigint 19  √  null
cloneParentId bigint 19  √  null Parent (source) volume of the clone pair
flexCacheOriginId bigint 19  √  null The name of the flex cache origin volume that contains the authoritative data. Only applicable on FlexCache volumes. ZAPIs: volume-get-iter volume-flexcache-attributes origin
snapshotPolicyId bigint 19  √  null
sisPolicyId bigint 19  √  null
storageServiceId bigint 19  √  null
qosPolicyGroupId bigint 19  √  null
instanceUUID varchar 255  √  null Globally unique ID of the Volume that remains unchanged after a volume move
size bigint 19  √  null Size of volume in bytes. Includes WAFL reserve and snapshot reserve
sizeTotal bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
sizeUsed bigint 19  √  null Used size of the volume in bytes
sizeUsedPercent int 10  √  null DERIVED. 0-100. Percentage bytes used out of total.
sizeAvail bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
sizeAvailPercent int 10  √  null DERIVED. 0-100. Percentage bytes available out of total.
isVserverRoot bit 0  √  null Is the volume the root of a vserver
state enum 11  √  null Volume state
stateRaw varchar 255  √  null
junctionPath varchar 255  √  null
isJunctionActive bit 0  √  null If mounted volume is accessible
junctionParentId bigint 19  √  null ID of the parent volume the QoS Policy Group references
style enum 11  √  null Volume style
styleRaw varchar 255  √  null
styleExtended enum 23  √  null the extended style of the volume.
styleExtendedRaw varchar 255  √  null Identifies license type
derivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
flexgroupUuid varchar 255  √  null UUID for the constituent's FlexGroup or the FlexGroup itself
flexgroupId bigint 19  √  null Volume ObjId of the flexgroup volume which this flexgroup constituent belongs to
flexgroupIndex int 10  √  null the index of the constituent in the FlexGroup
isSisVolume bit 0  √  null True if volume contains shared data (deduplication, file clones) or compressed data
isDataProtectionMirror bit 0  √  null True if volume is a data protection mirror
isLoadSharingMirror bit 0  √  null True if volume is a load sharing mirror
isMoveMirror bit 0  √  null True if this is a move volume
isReplicaVolume bit 0  √  null True if this is a read only replica volume
isSpaceGuaranteeEnabled bit 0  √  null Whether or not the storage guarantee associated with the flexible volume is currently in effect
vmAlignSector int 10  √  null The virtual machine alignment 512 bytes sector number
vmAlignSuffix varchar 255  √  null The virtual machine alignment suffix. The suffix such as ".xyz". is used to identify the files which needs to be aligned
overwriteReserve bigint 19  √  null The size (in bytes) that is reserved for overwriting snapshoted data in an otherwise full volume
overwriteReserveRequired bigint 19  √  null The reserved size (in bytes) that is required to ensure that the reserved space is sufficient to allow all space-reserved files and LUNs to be overwritten when the volume is full
overwriteReserveUsed bigint 19  √  null The reserved size (in bytes) that is not available for new overwrites
overwriteReserveAvail bigint 19  √  null DERIVED. OverwriteReserve - OverwriteReserveUsed.
overwriteReserveActualUsed bigint 19  √  null The reserved size (in bytes) that has been used
snapshotReserveSize bigint 19  √  null The size (in bytes) in the volume that has been set aside as reserve for snapshot usage
percentageSnapshotReserve int 10  √  null Percentage of the volume reserved for snapshots. Integer 0-100. ZAPIs: volume-get-iter volume-space-attributes percentage-snapshot-reserve
sizeUsedBySnapshots bigint 19  √  null The size (in bytes) that is used by snapshots in the volume. ZAPIs: volume-get-iter size-volume-space-attributes size-used-by-snapshots
percentageSnapshotReserveUsed int 10  √  null Percentage of the volume reserved for snapshots that has been used
sizeAvailableForSnapshot bigint 19  √  null Total free space (in bytes) available in the volume and snapshot reserve
percentageFractionalReserve int 10  √  null This field can be used to change the amount of space reserved for overwrites of reserved objects (e.g., files, LUNs) in a volume
deduplicationSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
deduplicationSpaceShared bigint 19  √  null Total disk space shared due to deduplication and file cloning(in bytes).
compressionSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
securityStyle enum 11  √  null The security style associated with this volume
securityStyleRaw varchar 255  √  null
hybridCacheEligibility enum 10  √  null Hybrid cacPlhe eligibility of a volume
hybridCacheEligibilityRaw varchar 255  √  null
inodeFilesUsed 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
inodeFilesTotal 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
inodeBlockType enum 11  √  null The indirect block format of the volume. ZAPIs: volume-get-iter volume-inode-attributes block-type
inodeBlockTypeRaw varchar 255  √  null
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.
quotaStatus enum 12  √  null Primary status of quotas on the indicated volume
quotaStatusRaw varchar 255  √  null Raw value of primary status of quotas on the indicated volume
flexCacheMinReserve bigint 19  √  null The amount of space requested to be preallocated in the aggregate hosting the FlexCache volume. ZAPIs: volume-get-iter volume-flexcache-attributes min-reserve
spaceGuarantee enum 11  √  null The storage guarantee option that is associated with the flexible volume. ZAPIs: volume-get-iter volume-space-attributes space-guarantee
spaceGuaranteeRaw varchar 255  √  null
isSnapshotCloneDependencyEnabled bit 0  √  null Controls the locking of LUN clones. ZAPIs: volume-get-iter volume-snapshot-attributes snapshot-clone-dependency-enabled
logicalSpaceAvail bigint 19  √  null Total available logical space (in bytes) in the volume
logicalSpaceUsed bigint 19  √  null Total used logical space (in bytes) available in the volume
percentLogicalSpaceUsed int 10  √  null Total used logical space available in the volume in terms of percentage
isLogicalSpaceReportingEnabled bit 0  √  null Whether the logical space reporting is enabled or not
isLogicalSpaceEnforcementEnabled bit 0  √  null Whether the logical space enforcement is enabled or not
isI2pEnabled bit 0  √  null If true, native inode-to-parent information is kept for inodes. ZAPIs: volume-get-iter volume-directory-attributes i2p-enabled
isAutoSnapshotsEnabled bit 0  √  null If true, enable automatic snapshots on the volume. ZAPIs: volume-get-iter volume-snapshot-attributes auto-snapshots-enabled
isSnapDirAccessEnabled bit 0  √  null If true, enable the visible .snapshot directory that is normally present at system internal mount points. ZAPIs: volume-get-iter volume-snapshot-attributes snapdir-access-enabled
languageCode varchar 255  √  null The volume language code (e.g. en_US). ZAPIs: volume-get-iter volume-language-attributes language-code
volType enum 11  √  null The type of the volume. ZAPIs: volume-get-iter volume-id-attributes type
volTypeRaw varchar 255  √  null
spaceMgmtOptionTryFirst enum 11  √  null This field controls the strategy to try first when this volume is space-challenged. ZAPIs: volume-get-iter volume-space-attributes space-mgmt-option-try-first
spaceMgmtOptionTryFirstRaw varchar 255  √  null
autoSizeMode enum 11  √  null The current mode of operation of volume autosize. ZAPIs: volume-get-iter volume-autosize-attributes mode
autoSizeModeRaw varchar 255  √  null
autoSizeMaximumSize bigint 19  √  null The maximum size (in bytes) to which the volume would be grown automatically. ZAPIs: volume-get-iter volume-autosize-attributes maximum-size
autoSizeIncrementSize bigint 19  √  null The increment size (in bytes) by which the volume would be grown. ZAPIs: volume-get-iter volume-autosize-attributes increment-size
isAtimeUpdateEnabled bit 0  √  null If false, prevent the update of inode access times when a file is read. ZAPIs: volume-get-iter volume-performance-attributes is-atime-update-enabled
isCreateUcodeEnabled bit 0  √  null This field controls whether all directories in this volume are forced to use the UNICODE format when they are created, both from NFS and CIFS. ZAPIs: volume-get-iter volume-language-attributes is-create-ucode-enabled
isConvertUcodeEnabled bit 0  √  null This field controls whether all directories in this volume are forcibly converted to UNICODE format when accessed from both NFS and CIFS. ZAPIs: volume-get-iter volume-language-attributes is-convert-ucode-enabled
cloneSplitEstimate bigint 19  √  null If volume is a clone, the split Estimate. ZAPIs: volume-clone-get-iter volume-clone-info split-estimate
cloneChildCount int 10  √  null Number of clones for which this volume is the parent. ZAPIs: volume-get-iter volume-clone-attributes clone-child-count
snapshotCount int 10  √  null Number of Snapshot copies in the volume. ZAPIs: volume-get-iter volume-snapshot-attributes snapshot-count
isSnapshotAutoDeleteEnabled bit 0  √  null This option determines if the snapshot autodelete is currently enabled for the volume. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes is-autodelete-enabled
snapshotAutoDeleteCommitment enum 11  √  null This option determines the snapshots that "snapshot autodelete" is allowed to delete to get back space. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes commitment
snapshotAutoDeleteCommitmentRaw varchar 255  √  null
snapshotAutoDeleteDeleteOrder enum 12  √  null This option determines if the oldest or newest snapshot is deleted first. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes delete-order
snapshotAutoDeleteDeleteOrderRaw varchar 255  √  null
snapshotAutoDeleteDeferDelete enum 12  √  null This option determines which kind of snapshots to delete. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes defer-delete
snapshotAutoDeleteDeferDeleteRaw varchar 255  √  null
snapshotAutoDeleteTargetFreeSpace int 10  √  null This option determines when snapshot autodelete should stop deleting snapshot. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes target-free-space
snapshotAutoDeleteTrigger enum 13  √  null This option determines the condition in which snapshots should be automatically deleted. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes trigger
snapshotAutoDeleteTriggerRaw varchar 255  √  null
snapshotAutoDeletePrefix varchar 255  √  null This option provides the prefix string for the "prefix" field value of the "defer-delete" option. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes prefix
snapshotAutoDeleteDestroyList varchar 255  √  null This options specifies the list of service that can be destroyed if the snapshot is backing that service. ZAPIs: volume-get-iter volume-snapshot-autodelete-attributes destroy-list
oldestSnapshotTimestamp timestamp 19  √  null Creation time of the oldest snapshot of this volume
sisStatus enum 12  √  null Status of any sis operation running on the volume. This parameter is not supported on Infinite Volumes. ZAPIs: sis-get-iter status
sisStatusRaw varchar 255  √  null
sisState enum 11  √  null State of sis configured on the volume. ZAPIs: sis-get-iter state
sisStateRaw varchar 255  √  null
sisProgress varchar 255  √  null The progress of the current sis operation with information as to which stage of sis process is currently in progress and how much data is processed for that stage. ZAPIs: sis-get-iter progress
sisType enum 11  √  null Any sis volume with Snapvault qtree in it would be marked as Snapvault and all others would be returned as type Regular. ZAPIs: sis-get-iter sis-status-info.type
sisTypeRaw varchar 255  √  null
sisSchedule varchar 255  √  null The schedule for sis operation on the volume. ZAPIs: sis-get-iter schedule
sisLastOpBeginTimestamp timestamp 19  √  null Start timestamp of the last sis operation. The value is in seconds since January 1, 1970. ZAPIs: sis-get-iter last-op-begin-timestamp
sisLastOpEndTimestamp timestamp 19  √  null End timestamp of the last sis operation. The value is in seconds since January 1, 1970. ZAPIs: sis-get-iter last-op-begin-timestamp
sisLastOpError varchar 255  √  null A human readable error message of the last sis operation. Present when there was an error. ZAPIs: sis-get-iter last-op-error
sisLastOpState enum 11  √  null Completion status for the last operation. ZAPIs: sis-get-iter last-op-state
sisLastOpStateRaw varchar 255  √  null
sisLastOpSize bigint 19  √  null The amount of data processed in bytes for the last sis operation. ZAPIs: sis-get-iter last-op-size
isSisCompressionEnabled bit 0  √  null Compression state of the volume. ZAPIs: sis-get-iter is-compression-enabled
isSisInlineCompressionEnabled bit 0  √  null Inline compression state of the volume. ZAPIs: sis-get-iter is-inline-compression-enabled
percentageDeduplicationSpaceSaved int 10  √  null Percentage of the total disk space that is saved by deduplication and file cloning. ZAPIs: volume-get-iter volume-sis-attributes percentage-deduplication-space-saved
percentageCompressionSpaceSaved int 10  √  null Percentage of the total disk space that is saved by compressing blocks on the referenced file system. ZAPIs: volume-get-iter volume-sis-attributes percentage-compression-space-saved
isSnapDiffEnabled bit 0  √  null Whether to enable Snapdiff. If enabled, the namespace mirrors will be created for Snapdiff use. ZAPI: Volume-infinitevol-attributes.enable-snapdiff
isManagedByService bit 0  √  null Specifies if the volume is managed by GUI services. ZAPI: Volume-infinitevol-attributes.is-managed-by-service
maxDataConstituentSize bigint 19  √  null The maximum size of each data constituent in bytes. The smallest, "maximum FlexVol size" setting on all nodes used by the Infinite Volume, is chosen as the default value. ZAPI:Volume-infinitevol-attributes.max-data-constituent-size
maxNamespaceConstituentSize bigint 19  √  null The maximum size of the namespace constituent. The default value is 10TB. ZAPI: Volume-infinitevol-attributes.max-namespace-constituent-size
constituentRole enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
constituentRoleRaw varchar 255  √  null
isConstituent bit 0  √  null
isFlexgroup bit 0  √  null this indicates if this volume is a flexgroup.
securityUserID varchar 255  √  null The UNIX user ID for the volume. The default value is 0 ('root')
securityGroupID varchar 255  √  null The UNIX group ID for the volume. The default value is 0 ('root')
securityPermissions varchar 255  √  null Unix permission bits in octal string format
cachingPolicy enum 10  √  null cache policy associated with volumes
cachingPolicyRaw varchar 255  √  null raw cache policy associated with volumes
isCftPreCommit bit 0  √  null Indicates whether the volume is in the pre-commit phase of Copy-Free transition
snapLockType enum 12  √  null type of the snaplock volume
snapLockTypeRaw varchar 255  √  null raw type of the snaplock volume
isInlineDedupeEnabled bit 0  √  null Indicates whether or not inline dedupe is enabled
cacheRetentionPriority enum 10  √  null cache retention priority associated with volumes
cacheRetentionPriorityRaw varchar 255  √  null raw cache retention priority associated with volumes
tieringPolicy enum 13  √  null Identifies the associated tiering policy for a volume
tieringPolicyRaw varchar 255  √  null Identifies assicated tiering policy for a volume
tieringMinimumCoolingDays int 10  √  null This is the minimum number of days for ONTAP to consider data to be cold
performanceTierInactiveData bigint 19  √  null This is the amount of cold data in bytes detected by ONTAP
performanceTierInactiveDataPercent int 10  √  null This is the percent of cold data based on used data detected by ONTAP
performanceTierFootprintBytes bigint 19  √  null The footprint of blocks written to the performance tier in bytes
performanceTierFootprintPercent int 10  √  null The footprint of blocks written to the performance tier in percent
cloudTierFootprintBytes bigint 19  √  null The footprint of blocks written to the cloud tier in bytes
cloudTierFootprintPercent int 10  √  null The footprint of blocks written to the cloud tier in percent
isEncrypt bit 0  √  null This field indicates whether or not the volume is encrypted
readRealloc enum 15  √  null This field indicates whether or not read reallocation is enabled for the volume
readReallocRaw varchar 255  √  null This field indicates whether or not read reallocation is enabled for the volume and has raw value
isDataCompactionEnabled bit 0  √  null This field indicates whether or not data compaction is enabled for the sis volume
ontapCreationTime bigint 19  √  null This is the actual creation time of this volume on the filer
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `v`.`objid` AS `objid`,`v`.`uuid` AS `uuid`,`v`.`resourceKey` AS `resourceKey`,`v`.`name` AS `name`,`v`.`clusterId` AS `clusterId`,`v`.`vserverId` AS `vserverId`,`a`.`nodeId` AS `nodeId`,`v`.`aggregateId` AS `aggregateId`,`v`.`exportPolicyId` AS `exportPolicyId`,`r`.`cloneParentId` AS `cloneParentId`,`v`.`flexCacheOriginId` AS `flexCacheOriginId`,`v`.`snapshotPolicyId` AS `snapshotPolicyId`,`v`.`sisPolicyId` AS `sisPolicyId`,`v`.`storageServiceId` AS `storageServiceId`,`v`.`qosPolicyGroupId` AS `qosPolicyGroupId`,`v`.`instanceUUID` AS `instanceUUID`,`v`.`size` AS `size`,`v`.`sizeTotal` AS `sizeTotal`,`v`.`sizeUsed` AS `sizeUsed`,`v`.`sizeUsedPercent` AS `sizeUsedPercent`,`v`.`sizeAvail` AS `sizeAvail`,`v`.`sizeAvailPercent` AS `sizeAvailPercent`,`v`.`isVserverRoot` AS `isVserverRoot`,`v`.`state` AS `state`,`v`.`stateRaw` AS `stateRaw`,`v`.`junctionPath` AS `junctionPath`,`v`.`isJunctionActive` AS `isJunctionActive`,`r`.`junctionParentId` AS `junctionParentId`,`v`.`style` AS `style`,`v`.`styleRaw` AS `styleRaw`,`v`.`styleExtended` AS `styleExtended`,`v`.`styleExtendedRaw` AS `styleExtendedRaw`,`v`.`DerivedStyle` AS `derivedStyle`,`v`.`flexgroupUuid` AS `flexgroupUuid`,`f`.`flexgroupId` AS `flexgroupId`,`v`.`flexgroupIndex` AS `flexgroupIndex`,`v`.`isSisVolume` AS `isSisVolume`,`v`.`isDataProtectionMirror` AS `isDataProtectionMirror`,`v`.`isLoadSharingMirror` AS `isLoadSharingMirror`,`v`.`isMoveMirror` AS `isMoveMirror`,`v`.`isReplicaVolume` AS `isReplicaVolume`,`v`.`isSpaceGuaranteeEnabled` AS `isSpaceGuaranteeEnabled`,`v`.`vmAlignSector` AS `vmAlignSector`,`v`.`vmAlignSuffix` AS `vmAlignSuffix`,`v`.`overwriteReserve` AS `overwriteReserve`,`v`.`overwriteReserveRequired` AS `overwriteReserveRequired`,`v`.`overwriteReserveUsed` AS `overwriteReserveUsed`,`v`.`overwriteReserveAvail` AS `overwriteReserveAvail`,`v`.`overwriteReserveActualUsed` AS `overwriteReserveActualUsed`,`v`.`snapshotReserveSize` AS `snapshotReserveSize`,`v`.`percentageSnapshotReserve` AS `percentageSnapshotReserve`,`v`.`sizeUsedBySnapshots` AS `sizeUsedBySnapshots`,`v`.`percentageSnapshotReserveUsed` AS `percentageSnapshotReserveUsed`,`v`.`sizeAvailableForSnapshot` AS `sizeAvailableForSnapshot`,`v`.`percentageFractionalReserve` AS `percentageFractionalReserve`,`v`.`deduplicationSpaceSaved` AS `deduplicationSpaceSaved`,`v`.`deduplicationSpaceShared` AS `deduplicationSpaceShared`,`v`.`compressionSpaceSaved` AS `compressionSpaceSaved`,`v`.`securityStyle` AS `securityStyle`,`v`.`securityStyleRaw` AS `securityStyleRaw`,`v`.`hybridCacheEligibility` AS `hybridCacheEligibility`,`v`.`hybridCacheEligibilityRaw` AS `hybridCacheEligibilityRaw`,`v`.`inodeFilesUsed` AS `inodeFilesUsed`,`v`.`inodeFilesTotal` AS `inodeFilesTotal`,`v`.`inodeBlockType` AS `inodeBlockType`,`v`.`inodeBlockTypeRaw` AS `inodeBlockTypeRaw`,`v`.`quotaCommitted` AS `quotaCommitted`,`v`.`quotaOverCommitted` AS `quotaOverCommitted`,`v`.`quotaStatus` AS `quotaStatus`,`v`.`quotaStatusRaw` AS `quotaStatusRaw`,`v`.`flexCacheMinReserve` AS `flexCacheMinReserve`,`v`.`spaceGuarantee` AS `spaceGuarantee`,`v`.`spaceGuaranteeRaw` AS `spaceGuaranteeRaw`,`v`.`isSnapshotCloneDependencyEnabled` AS `isSnapshotCloneDependencyEnabled`,`v`.`logicalSpaceAvail` AS `logicalSpaceAvail`,`v`.`logicalSpaceUsed` AS `logicalSpaceUsed`,`v`.`percentLogicalSpaceUsed` AS `percentLogicalSpaceUsed`,`v`.`isLogicalSpaceReportingEnabled` AS `isLogicalSpaceReportingEnabled`,`v`.`isLogicalSpaceEnforcementEnabled` AS `isLogicalSpaceEnforcementEnabled`,`v`.`isI2pEnabled` AS `isI2pEnabled`,`v`.`isAutoSnapshotsEnabled` AS `isAutoSnapshotsEnabled`,`v`.`isSnapDirAccessEnabled` AS `isSnapDirAccessEnabled`,`v`.`languageCode` AS `languageCode`,`v`.`volType` AS `volType`,`v`.`volTypeRaw` AS `volTypeRaw`,`v`.`spaceMgmtOptionTryFirst` AS `spaceMgmtOptionTryFirst`,`v`.`spaceMgmtOptionTryFirstRaw` AS `spaceMgmtOptionTryFirstRaw`,`v`.`autoSizeMode` AS `autoSizeMode`,`v`.`autoSizeModeRaw` AS `autoSizeModeRaw`,`v`.`autoSizeMaximumSize` AS `autoSizeMaximumSize`,`v`.`autoSizeIncrementSize` AS `autoSizeIncrementSize`,`v`.`isAtimeUpdateEnabled` AS `isAtimeUpdateEnabled`,`v`.`isCreateUcodeEnabled` AS `isCreateUcodeEnabled`,`v`.`isConvertUcodeEnabled` AS `isConvertUcodeEnabled`,`v`.`cloneSplitEstimate` AS `cloneSplitEstimate`,`v`.`cloneChildCount` AS `cloneChildCount`,`v`.`snapshotCount` AS `snapshotCount`,`v`.`isSnapshotAutoDeleteEnabled` AS `isSnapshotAutoDeleteEnabled`,`v`.`snapshotAutoDeleteCommitment` AS `snapshotAutoDeleteCommitment`,`v`.`snapshotAutoDeleteCommitmentRaw` AS `snapshotAutoDeleteCommitmentRaw`,`v`.`snapshotAutoDeleteDeleteOrder` AS `snapshotAutoDeleteDeleteOrder`,`v`.`snapshotAutoDeleteDeleteOrderRaw` AS `snapshotAutoDeleteDeleteOrderRaw`,`v`.`snapshotAutoDeleteDeferDelete` AS `snapshotAutoDeleteDeferDelete`,`v`.`snapshotAutoDeleteDeferDeleteRaw` AS `snapshotAutoDeleteDeferDeleteRaw`,`v`.`snapshotAutoDeleteTargetFreeSpace` AS `snapshotAutoDeleteTargetFreeSpace`,`v`.`snapshotAutoDeleteTrigger` AS `snapshotAutoDeleteTrigger`,`v`.`snapshotAutoDeleteTriggerRaw` AS `snapshotAutoDeleteTriggerRaw`,`v`.`snapshotAutoDeletePrefix` AS `snapshotAutoDeletePrefix`,`v`.`snapshotAutoDeleteDestroyList` AS `snapshotAutoDeleteDestroyList`,`v`.`oldestSnapshotTimestamp` AS `oldestSnapshotTimestamp`,`v`.`sisStatus` AS `sisStatus`,`v`.`sisStatusRaw` AS `sisStatusRaw`,`v`.`sisState` AS `sisState`,`v`.`sisStateRaw` AS `sisStateRaw`,`v`.`sisProgress` AS `sisProgress`,`v`.`sisType` AS `sisType`,`v`.`sisTypeRaw` AS `sisTypeRaw`,`v`.`sisSchedule` AS `sisSchedule`,`v`.`sisLastOpBeginTimestamp` AS `sisLastOpBeginTimestamp`,`v`.`sisLastOpEndTimestamp` AS `sisLastOpEndTimestamp`,`v`.`sisLastOpError` AS `sisLastOpError`,`v`.`sisLastOpState` AS `sisLastOpState`,`v`.`sisLastOpStateRaw` AS `sisLastOpStateRaw`,`v`.`sisLastOpSize` AS `sisLastOpSize`,`v`.`isSisCompressionEnabled` AS `isSisCompressionEnabled`,`v`.`isSisInlineCompressionEnabled` AS `isSisInlineCompressionEnabled`,`v`.`percentageDeduplicationSpaceSaved` AS `percentageDeduplicationSpaceSaved`,`v`.`percentageCompressionSpaceSaved` AS `percentageCompressionSpaceSaved`,`v`.`isSnapDiffEnabled` AS `isSnapDiffEnabled`,`v`.`isManagedByService` AS `isManagedByService`,`v`.`maxDataConstituentSize` AS `maxDataConstituentSize`,`v`.`maxNamespaceConstituentSize` AS `maxNamespaceConstituentSize`,`v`.`constituentRole` AS `constituentRole`,`v`.`constituentRoleRaw` AS `constituentRoleRaw`,`v`.`IsConstituent` AS `isConstituent`,`v`.`isFlexgroup` AS `isFlexgroup`,`v`.`securityUserID` AS `securityUserID`,`v`.`securityGroupID` AS `securityGroupID`,`v`.`securityPermissions` AS `securityPermissions`,`v`.`cachingPolicy` AS `cachingPolicy`,`v`.`cachingPolicyRaw` AS `cachingPolicyRaw`,`v`.`isCftPreCommit` AS `isCftPreCommit`,`v`.`snapLockType` AS `snapLockType`,`v`.`snapLockTypeRaw` AS `snapLockTypeRaw`,`v`.`isInlineDedupeEnabled` AS `isInlineDedupeEnabled`,`v`.`cacheRetentionPriority` AS `cacheRetentionPriority`,`v`.`cacheRetentionPriorityRaw` AS `cacheRetentionPriorityRaw`,`v`.`tieringPolicy` AS `tieringPolicy`,`v`.`tieringPolicyRaw` AS `tieringPolicyRaw`,`v`.`tieringMinimumCoolingDays` AS `tieringMinimumCoolingDays`,`v`.`performanceTierInactiveData` AS `performanceTierInactiveData`,`v`.`performanceTierInactiveDataPercent` AS `performanceTierInactiveDataPercent`,`v`.`performanceTierFootprintBytes` AS `performanceTierFootprintBytes`,`v`.`performanceTierFootprintPercent` AS `performanceTierFootprintPercent`,`v`.`cloudTierFootprintBytes` AS `cloudTierFootprintBytes`,`v`.`cloudTierFootprintPercent` AS `cloudTierFootprintPercent`,`v`.`isEncrypt` AS `isEncrypt`,`v`.`readRealloc` AS `readRealloc`,`v`.`readReallocRaw` AS `readReallocRaw`,`v`.`isDataCompactionEnabled` AS `isDataCompactionEnabled`,`v`.`ontapCreationTime` AS `ontapCreationTime`,`v`.`createtime` AS `createTime`,`v`.`updatetime` AS `updateTime` from (((`netapp_model`.`volume` `v` left join `netapp_model`.`volume_self_relationship` `r` on((`v`.`objid` = `r`.`objid`))) left join `netapp_model`.`volume_flexgroup_constituent_relationship` `f` on((`v`.`objid` = `f`.`objid`))) left join `netapp_model`.`aggregate` `a` on((`v`.`aggregateId` = `a`.`objid`))) where (`v`.`objState` = 'LIVE')