View ocum.volumelivelistdtoview 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
objectId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
id bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
name varchar 255 Textual name
volStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
styleExtended varchar 255  √  null Identifies license type
healthStatus int 10
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
vserverHealthStatus int 10
aggregateId bigint 19  √  null Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregateName varchar 255  √  null Textual name
aggregateCount int 10  √  1
aggregateHealthStatus int 10  √  null
state varchar 255  √  null
dfBytesActualSize bigint 19  √  null Size of volume in bytes. Includes WAFL reserve and snapshot reserve
dfBytesUsed bigint 19  √  null Used size of the volume in bytes
dfBytesTotal bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
dfBytesAvail bigint 19  √  null
dfBytesAvailablePercent decimal 27,4  √  null
dfBytesUsedPercent decimal 26,4  √  null
dfBytesLogicalSpaceUsedPercent int 10  √  null Total used logical space available in the volume in terms of percentage
logicalSpaceReportingStatus varchar 13
junctionPath varchar 255  √  null
isThinProvisioned int 10  √  null
lastVolumeMoveState varchar 40  √  null
protectionRole varchar 13
snapLockType varchar 255  √  null
dedupeEnabled int 10  √  null
compressionState int 10  √  null
cachingPolicy varchar 255  √  null raw cache policy associated with volumes
clusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
clusterNodeName varchar 255  √  null Textual name
nodeCount int 10  √  1
clusterNodeHealthStatus int 10  √  null
volType varchar 255  √  null
clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterName varchar 255 Textual name
clusterVersion varchar 255  √  null Version of the cluster
clusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
clusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
clusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
tieringPolicy varchar 255  √  null Identifies assicated tiering policy for a volume
clusterHealthStatus int 10
localSnapshotPolicyName varchar 255  √  null A human readable string describing the name of the snapshot scheduling policy.
constituentRole varchar 255  √  null
storageClassName varchar 255  √  null Storage Service Name. ZAPIs: volume-storage-service-get-iter.storage-service-info.storage-service
clusterFqdn varchar 255  √  null
isCftPrecommit int 10  √  null
cacheRetentionPriority varchar 255  √  null raw cache retention priority associated with volumes
syncMirrorRelationshipParticipantStatus varchar 21  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryvolume`.`objid` AS `objectId`,`inventoryvolume`.`objid` AS `id`,`inventoryvolume`.`name` AS `name`,`inventoryvolume`.`derivedStyle` AS `volStyle`,`inventoryvolume`.`styleExtendedRaw` AS `styleExtended`,`ocum`.`volume`.`healthStatus` AS `healthStatus`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus`,`inventoryaggregate`.`objid` AS `aggregateId`,`inventoryaggregate`.`name` AS `aggregateName`,`ocum`.`volume`.`aggregateCount` AS `aggregateCount`,`ocum`.`aggregate`.`healthStatus` AS `aggregateHealthStatus`,`inventoryvolume`.`stateRaw` AS `state`,`inventoryvolume`.`size` AS `dfBytesActualSize`,`inventoryvolume`.`sizeUsed` AS `dfBytesUsed`,`inventoryvolume`.`sizeTotal` AS `dfBytesTotal`,(`inventoryvolume`.`sizeTotal` - `inventoryvolume`.`sizeUsed`) AS `dfBytesAvail`,(case when (`inventoryvolume`.`sizeTotal` = 0) then 0 else (((`inventoryvolume`.`sizeTotal` - `inventoryvolume`.`sizeUsed`) / `inventoryvolume`.`sizeTotal`) * 100) end) AS `dfBytesAvailablePercent`,`volumecalculationsview`.`dfBytesUsedPercent` AS `dfBytesUsedPercent`,`inventoryvolume`.`percentLogicalSpaceUsed` AS `dfBytesLogicalSpaceUsedPercent`,(case when (`inventoryvolume`.`isLogicalSpaceReportingEnabled` = TRUE) then 'enabled' when (`inventoryvolume`.`isLogicalSpaceReportingEnabled` = FALSE) then 'disabled' else 'notApplicable' end) AS `logicalSpaceReportingStatus`,`inventoryvolume`.`junctionPath` AS `junctionPath`,(case when isnull(`inventoryvolume`.`spaceGuaranteeRaw`) then NULL when ((`inventoryvolume`.`spaceGuaranteeRaw` = 'none') or (`inventoryvolume`.`spaceGuaranteeRaw` = 'file')) then TRUE else FALSE end) AS `isThinProvisioned`,`ocum`.`volumemovehistory`.`moveState` AS `lastVolumeMoveState`,(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`,(`inventoryvolume`.`sisStateRaw` = 'enabled') AS `dedupeEnabled`,(`inventoryvolume`.`isSisCompressionEnabled` = TRUE) AS `compressionState`,`inventoryvolume`.`cachingPolicyRaw` AS `cachingPolicy`,`inventoryclusternode`.`objid` AS `clusterNodeId`,`inventoryclusternode`.`name` AS `clusterNodeName`,`ocum`.`volume`.`nodeCount` AS `nodeCount`,`ocum`.`clusternode`.`healthStatus` AS `clusterNodeHealthStatus`,`inventoryvolume`.`volTypeRaw` AS `volType`,`inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`inventorycluster`.`version` AS `clusterVersion`,`inventorycluster`.`versionGeneration` AS `clusterVersionGeneration`,`inventorycluster`.`versionMajor` AS `clusterVersionMajor`,`inventorycluster`.`versionMinor` AS `clusterVersionMinor`,`inventoryvolume`.`tieringPolicyRaw` AS `tieringPolicy`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`inventorysnapshotpolicy`.`name` AS `localSnapshotPolicyName`,`inventoryvolume`.`constituentRoleRaw` AS `constituentRole`,`inventorystorageclass`.`storageServiceName` AS `storageClassName`,`ocumschemacluster`.`fqdn` AS `clusterFqdn`,(case when isnull(`inventoryvolume`.`isCftPreCommit`) then FALSE else `inventoryvolume`.`isCftPreCommit` end) AS `isCftPrecommit`,`inventoryvolume`.`cacheRetentionPriorityRaw` AS `cacheRetentionPriority`,(case when ((`ocum`.`volume`.`isSnapMirrorDestination` = TRUE) and (`incominginventorysnapmirror`.`derivedRelationshipType` in ('sync_mirror_strict','sync_mirror'))) then 'syncMirrorDestination' when ((`syncmirrorrelationshipsource`.`derivedRelationshipType` = 'sync_mirror') or (`syncmirrorrelationshipsource`.`derivedRelationshipType` = 'sync_mirror_strict')) then 'syncMirrorSource' else NULL end) AS `syncMirrorRelationshipParticipantStatus` from (((((((((((((((((((((`netapp_model_view`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) straight_join `ocum`.`volumecalculationsview` on((`volumecalculationsview`.`volumeId` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`storage_service` `inventorystorageclass` on(((`inventorystorageclass`.`objid` = `inventoryvolume`.`storageServiceId`) and (`inventorystorageclass`.`storageServiceIdentifier` >= 0)))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryvolume`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) left join `netapp_model_view`.`aggregate` `inventoryaggregate` on((`inventoryaggregate`.`objid` = `inventoryvolume`.`aggregateId`))) left join `ocum`.`aggregate` on((`ocum`.`aggregate`.`id` = `inventoryaggregate`.`objid`))) left join `netapp_model_view`.`node` `inventoryclusternode` on((`inventoryclusternode`.`objid` = `inventoryvolume`.`nodeId`))) left join `ocum`.`clusternode` on((`ocum`.`clusternode`.`id` = `inventoryclusternode`.`objid`))) straight_join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryvolume`.`clusterId`))) join `ocum`.`cluster` `ocumschemacluster` on((`ocumschemacluster`.`cluster_id` = `inventoryvolume`.`clusterId`))) straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) left join `ocum`.`volumelivelistmaxvolumemovejobview` `maxmovedata` on((`maxmovedata`.`volumeId` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`volume_move_job` `inventoryvolumemovehistory` on(((`inventoryvolumemovehistory`.`volumeId` = `maxmovedata`.`volumeId`) and (`inventoryvolumemovehistory`.`startTime` = `maxmovedata`.`maxStartTime`) and (`inventoryvolumemovehistory`.`updateTime` = `maxmovedata`.`maxUpdateTime`)))) left join `ocum`.`volumemovehistory` on((`ocum`.`volumemovehistory`.`id` = `inventoryvolumemovehistory`.`objid`))) left join `ocum`.`volumeoutgoingrelationshipview` `outgoinginventorysnapmirror` on((`outgoinginventorysnapmirror`.`sourceVolumeId` = `inventoryvolume`.`objid`))) 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 `netapp_model_view`.`snap_mirror` `syncmirrorrelationshipsource` on(((`inventoryvolume`.`objid` = `syncmirrorrelationshipsource`.`sourceVolumeId`) and ((`syncmirrorrelationshipsource`.`derivedRelationshipType` = 'sync_mirror') or (`syncmirrorrelationshipsource`.`derivedRelationshipType` = 'sync_mirror_strict'))))) left join `ocum`.`storageserviceconnectionmember` `incomingconnectionmember` on((`incomingconnectionmember`.`relationship_id` = `incominginventorysnapmirror`.`objid`))) left join `ocum`.`storageserviceconnection` `incomingconnection` on((`incomingconnection`.`id` = `incomingconnectionmember`.`connection_id`))) left join `netapp_model_view`.`snapshot_policy` `inventorysnapshotpolicy` on((`inventorysnapshotpolicy`.`objid` = `inventoryvolume`.`snapshotPolicyId`)))
 
Possibly Referenced Tables/Views: