View netapp_model_view.volume | Generated by SchemaSpy |
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')