View ocum.volumelivelistdtoview | Generated by SchemaSpy |
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`)))