View ocum_report.volume | Generated by SchemaSpy |
View Definition:
select `volume`.`objid` AS `id`,`volume`.`uuid` AS `uuid`,`volume`.`name` AS `name`,`volume`.`clusterId` AS `clusterId`,`volume`.`vserverId` AS `svmId`,`volume`.`nodeId` AS `nodeId`,`volume`.`aggregateId` AS `aggregateId`,`volume`.`exportPolicyId` AS `exportPolicyId`,`volume`.`size` AS `size`,`volume`.`sizeTotal` AS `sizeTotal`,`volume`.`sizeUsed` AS `sizeUsed`,`volume`.`sizeUsedPercent` AS `sizeUsedPercent`,`volume`.`sizeAvail` AS `sizeAvail`,`volume`.`sizeAvailPercent` AS `sizeAvailPercent`,`volume`.`isVserverRoot` AS `isSvmRoot`,`volume`.`stateRaw` AS `state`,`volume`.`junctionPath` AS `junctionPath`,`volume`.`isJunctionActive` AS `isJunctionActive`,`volume`.`junctionParentId` AS `junctionParentId`,`volume`.`styleRaw` AS `style`,`volume`.`derivedStyle` AS `derivedStyle`,`volume`.`isSisVolume` AS `isSisVolume`,`volume`.`isDataProtectionMirror` AS `isDataProtectionMirror`,`volume`.`isLoadSharingMirror` AS `isLoadSharingMirror`,`volume`.`isMoveMirror` AS `isMoveMirror`,`volume`.`isReplicaVolume` AS `isReplicaVolume`,`volume`.`isSpaceGuaranteeEnabled` AS `isSpaceGuaranteeEnabled`,`volume`.`vmAlignSector` AS `vmAlignSector`,`volume`.`vmAlignSuffix` AS `vmAlignSuffix`,`volume`.`overwriteReserve` AS `overwriteReserve`,`volume`.`overwriteReserveRequired` AS `overwriteReserveRequired`,`volume`.`overwriteReserveUsed` AS `overwriteReserveUsed`,`volume`.`overwriteReserveAvail` AS `overwriteReserveAvail`,`volume`.`overwriteReserveActualUsed` AS `overwriteReserveActualUsed`,`volume`.`snapshotReserveSize` AS `snapshotReserveSize`,`volume`.`percentageSnapshotReserve` AS `percentageSnapshotReserve`,`volume`.`sizeUsedBySnapshots` AS `sizeUsedBySnapshots`,`volume`.`percentageSnapshotReserveUsed` AS `percentageSnapshotReserveUsed`,`volume`.`sizeAvailableForSnapshot` AS `sizeAvailableForSnapshot`,`volume`.`percentageFractionalReserve` AS `percentageFractionalReserve`,`volume`.`deduplicationSpaceSaved` AS `deduplicationSpaceSaved`,`volume`.`compressionSpaceSaved` AS `compressionSpaceSaved`,`volume`.`securityStyleRaw` AS `securityStyle`,`volume`.`hybridCacheEligibilityRaw` AS `hybridCacheEligibility`,`volume`.`inodeFilesUsed` AS `inodeFilesUsed`,`volume`.`inodeFilesTotal` AS `inodeFilesTotal`,`volume`.`inodeBlockTypeRaw` AS `inodeBlockType`,`volume`.`quotaCommitted` AS `quotaCommitted`,`volume`.`quotaOverCommitted` AS `quotaOverCommitted`,`volume`.`quotaStatusRaw` AS `quotaStatus`,`volume`.`flexCacheMinReserve` AS `flexCacheMinReserve`,`volume`.`spaceGuaranteeRaw` AS `spaceGuarantee`,`volume`.`isSnapshotCloneDependencyEnabled` AS `isSnapshotCloneDependencyEnabled`,`volume`.`isI2pEnabled` AS `isI2pEnabled`,`volume`.`isAutoSnapshotsEnabled` AS `isAutoSnapshotsEnabled`,`volume`.`isSnapDirAccessEnabled` AS `isSnapDirAccessEnabled`,`volume`.`languageCode` AS `languageCode`,`volume`.`volTypeRaw` AS `volType`,`volume`.`spaceMgmtOptionTryFirstRaw` AS `spaceMgmtOptionTryFirst`,`volume`.`autoSizeModeRaw` AS `autoSizeMode`,`volume`.`autoSizeMaximumSize` AS `autoSizeMaximumSize`,`volume`.`autoSizeIncrementSize` AS `autoSizeIncrementSize`,`volume`.`isAtimeUpdateEnabled` AS `isAtimeUpdateEnabled`,`volume`.`isCreateUcodeEnabled` AS `isCreateUcodeEnabled`,`volume`.`isConvertUcodeEnabled` AS `isConvertUcodeEnabled`,`volume`.`cloneSplitEstimate` AS `cloneSplitEstimate`,`volume`.`cloneChildCount` AS `cloneChildCount`,`volume`.`snapshotCount` AS `snapshotCount`,`volume`.`isSnapshotAutoDeleteEnabled` AS `isSnapshotAutoDeleteEnabled`,`volume`.`snapshotAutoDeleteCommitmentRaw` AS `snapshotAutoDeleteCommitment`,`volume`.`snapshotAutoDeleteDeleteOrderRaw` AS `snapshotAutoDeleteDeleteOrder`,`volume`.`snapshotAutoDeleteDeferDeleteRaw` AS `snapshotAutoDeleteDeferDelete`,`volume`.`snapshotAutoDeleteTargetFreeSpace` AS `snapshotAutoDeleteTargetFreeSpace`,`volume`.`snapshotAutoDeleteTriggerRaw` AS `snapshotAutoDeleteTrigger`,`volume`.`snapshotAutoDeletePrefix` AS `snapshotAutoDeletePrefix`,`volume`.`snapshotAutoDeleteDestroyList` AS `snapshotAutoDeleteDestroyList`,`volume`.`oldestSnapshotTimestamp` AS `oldestSnapshotTimestamp`,`volume`.`sisStatusRaw` AS `sisStatus`,`volume`.`sisStateRaw` AS `sisState`,`volume`.`sisProgress` AS `sisProgress`,`volume`.`sisTypeRaw` AS `sisType`,`volume`.`sisSchedule` AS `sisSchedule`,`volume`.`sisLastOpBeginTimestamp` AS `sisLastOpBeginTimestamp`,`volume`.`sisLastOpEndTimestamp` AS `sisLastOpEndTimestamp`,`volume`.`sisLastOpError` AS `sisLastOpError`,`volume`.`sisLastOpStateRaw` AS `sisLastOpState`,`volume`.`sisLastOpSize` AS `sisLastOpSize`,`volume`.`isSisCompressionEnabled` AS `isSisCompressionEnabled`,`volume`.`isSisInlineCompressionEnabled` AS `isSisInlineCompressionEnabled`,`volume`.`percentageDeduplicationSpaceSaved` AS `percentageDeduplicationSpaceSaved`,`volume`.`percentageCompressionSpaceSaved` AS `percentageCompressionSpaceSaved`,`volume`.`isSnapDiffEnabled` AS `isSnapDiffEnabled`,`volume`.`isManagedByService` AS `isManagedByService`,`volume`.`maxDataConstituentSize` AS `maxDataConstituentSize`,`volume`.`maxNamespaceConstituentSize` AS `maxNamespaceConstituentSize`,`volume`.`constituentRoleRaw` AS `constituentRole`,`volume`.`isConstituent` AS `isConstituent`,`volume`.`cachingPolicyRaw` AS `cachingPolicy`,`volume`.`cacheRetentionPriorityRaw` AS `cacheRetentionPriority`,`volume`.`tieringPolicyRaw` AS `tieringPolicy` from `netapp_model_view`.`volume`
Possibly Referenced Tables/Views: