View ocum_report.volumerelationshipinventoryview | Generated by SchemaSpy |
View Definition:
select `inventorysrcvolume`.`name` AS `sourceVolumeName`,`inventorysrcvserver`.`name` AS `sourceVserverName`,`inventorysrccluster`.`name` AS `sourceClusterName`,`inventorydestvolume`.`name` AS `destinationVolumeName`,`inventorydestvserver`.`name` AS `destinationVserverName`,`inventorydestcluster`.`name` AS `destinationClusterName`,`inventorysnapmirror`.`relationshipTypeRaw` AS `relationshipType`,`inventorysnapmirror`.`mirrorStateRaw` AS `relationshipState`,`inventorysnapmirror`.`isHealthy` AS `isHealthy`,`inventorysnapmirror`.`relationshipStatusRaw` AS `relationshipStatus`,`snapmirror`.`lastSuccessfulTransferEndTimestamp` AS `lastSuccessfulUpdateTime`,`inventorysnapmirror`.`lastTransferDuration` AS `lastTransferDuration`,`inventorysnapmirror`.`lastTransferSize` AS `lastTransferSize`,`inventorysnapmirror`.`lastTransferEndTimestamp` AS `lastTransferEndTime`,`inventorysnapmirror`.`unhealthyReason` AS `unhealthyReason`,`inventorysnapmirror`.`lagTime` AS `lagDuration`,`snapmirror`.`lagStatus` AS `lagStatus`,`snapmirror`.`isVersionFlexibleReplicationEnabled` AS `versionFlexibleReplication`,`inventorysnapmirror`.`objid` AS `objectId`,`inventorysnapmirror`.`objid` AS `id`,`inventorysnapmirror`.`relationshipControlPlane` AS `controlPlane`,`snapmirror`.`name` AS `name`,`snapmirror`.`healthStatus` AS `healthStatus`,`snapmirror`.`overallStatus` AS `overallStatus`,coalesce(concat(`inventorydestcluster`.`name`,'://',`inventorydestvserver`.`name`,'/',`inventorydestvolume`.`name`),'') AS `destinationPath`,`inventorydestvolume`.`objid` AS `destinationVolumeId`,`destvolume`.`healthStatus` AS `destinationVolumeHealthStatus`,`inventorydestvolume`.`stateRaw` AS `destinationVolumeState`,`inventorydestvolume`.`volTypeRaw` AS `destinationVolumeType`,`inventorydestvserver`.`objid` AS `destinationVserverId`,`destvserver`.`healthStatus` AS `destinationVserverHealthStatus`,`inventorydestaggregate`.`objid` AS `destinationAggregateId`,`inventorydestaggregate`.`name` AS `destinationAggregateName`,`destaggregate`.`healthStatus` AS `destinationAggregateHealthStatus`,`inventorydestclusternode`.`objid` AS `destinationClusterNodeId`,`inventorydestclusternode`.`name` AS `destinationClusterNodeName`,`destclusternode`.`healthStatus` AS `destinationClusterNodeHealthStatus`,`inventorydestcluster`.`objid` AS `destinationClusterId`,`destcluster`.`healthStatus` AS `destinationClusterHealthStatus`,`ocum`.`na_shortOSVersion`(`inventorydestcluster`.`version`) AS `destinationClusterVersion`,`inventorydestcluster`.`versionGeneration` AS `destinationClusterVersionGeneration`,`inventorydestcluster`.`versionMajor` AS `destinationClusterVersionMajor`,`inventorydestcluster`.`versionMinor` AS `destinationClusterVersionMinor`,coalesce(concat(`inventorysrccluster`.`name`,'://',`inventorysrcvserver`.`name`,'/',`inventorysrcvolume`.`name`),'') AS `sourcePath`,`inventorysrcvolume`.`objid` AS `sourceVolumeId`,`srcvolume`.`healthStatus` AS `sourceVolumeHealthStatus`,`inventorysrcvolume`.`stateRaw` AS `sourceVolumeState`,`inventorysrcvolume`.`volTypeRaw` AS `sourceVolumeType`,`inventorysrcvserver`.`objid` AS `sourceVserverId`,`srcvserver`.`healthStatus` AS `sourceVserverHealthStatus`,`inventorysrcaggregate`.`objid` AS `sourceAggregateId`,`inventorysrcaggregate`.`name` AS `sourceAggregateName`,`srcaggregate`.`healthStatus` AS `sourceAggregateHealthStatus`,`inventorysrcclusternode`.`objid` AS `sourceClusterNodeId`,`inventorysrcclusternode`.`name` AS `sourceClusterNodeName`,`srcclusternode`.`healthStatus` AS `sourceClusterNodeHealthStatus`,`inventorysrccluster`.`objid` AS `sourceClusterId`,`srccluster`.`healthStatus` AS `sourceClusterHealthStatus`,`ocum`.`na_shortOSVersion`(`inventorysrccluster`.`version`) AS `sourceClusterVersion`,`inventorysrccluster`.`versionGeneration` AS `sourceClusterVersionGeneration`,`inventorysrccluster`.`versionMajor` AS `sourceClusterVersionMajor`,`inventorysrccluster`.`versionMinor` AS `sourceClusterVersionMinor`,`inventorysnapmirrorpolicy`.`objid` AS `snapMirrorPolicyId`,`inventorysnapmirrorpolicy`.`name` AS `snapMirrorPolicyName`,`inventorysnapmirrorpolicy`.`transferPriorityRaw` AS `transferPriority`,`inventorysnapmirrorpolicy`.`type` AS `snapMirrorPolicyType`,`inventoryjobschedule`.`objid` AS `scheduleId`,`inventoryjobschedule`.`name` AS `scheduleName` from ((((((((((((((((((((((((((`netapp_model_view`.`snap_mirror` `inventorysnapmirror` straight_join `ocum`.`snapmirrorrelationship` `snapmirror` on((`snapmirror`.`id` = `inventorysnapmirror`.`objid`))) straight_join `netapp_model_view`.`volume` `inventorydestvolume` on((`inventorydestvolume`.`objid` = `inventorysnapmirror`.`destinationVolumeId`))) straight_join `ocum`.`volume` `destvolume` on((`destvolume`.`id` = `inventorysnapmirror`.`destinationVolumeId`))) left join `netapp_model_view`.`volume` `inventorysrcvolume` on((`inventorysrcvolume`.`objid` = `inventorysnapmirror`.`sourceVolumeId`))) left join `ocum`.`volume` `srcvolume` on((`srcvolume`.`id` = `inventorysnapmirror`.`sourceVolumeId`))) straight_join `netapp_model_view`.`vserver` `inventorydestvserver` on((`inventorydestvserver`.`objid` = `inventorysnapmirror`.`destinationVserverId`))) straight_join `ocum`.`vserver` `destvserver` on((`destvserver`.`id` = `inventorysnapmirror`.`destinationVserverId`))) straight_join `netapp_model_view`.`cluster` `inventorydestcluster` on((`inventorydestcluster`.`objid` = `inventorysnapmirror`.`destinationClusterId`))) straight_join `ocum`.`cluster` `destcluster` on((`destcluster`.`id` = `inventorysnapmirror`.`destinationClusterId`))) left join `netapp_model_view`.`node` `inventorydestclusternode` on((`inventorydestclusternode`.`objid` = `inventorysnapmirror`.`destinationNodeId`))) left join `ocum`.`clusternode` `destclusternode` on((`destclusternode`.`id` = `inventorysnapmirror`.`destinationNodeId`))) straight_join `netapp_model_view`.`aggregate` `inventorydestaggregate` on((`inventorydestaggregate`.`objid` = `inventorydestvolume`.`aggregateId`))) straight_join `ocum`.`aggregate` `destaggregate` on((`destaggregate`.`id` = `inventorydestvolume`.`aggregateId`))) left join `netapp_model_view`.`vserver` `inventorysrcvserver` on((`inventorysrcvserver`.`objid` = `inventorysnapmirror`.`sourceVserverId`))) left join `ocum`.`vserver` `srcvserver` on((`srcvserver`.`id` = `inventorysnapmirror`.`sourceVserverId`))) left join `netapp_model_view`.`cluster` `inventorysrccluster` on((`inventorysrccluster`.`objid` = `inventorysnapmirror`.`sourceClusterId`))) left join `ocum`.`cluster` `srccluster` on((`srccluster`.`id` = `inventorysnapmirror`.`sourceClusterId`))) left join `netapp_model_view`.`node` `inventorysrcclusternode` on((`inventorysrcclusternode`.`objid` = `inventorysrcvolume`.`nodeId`))) left join `ocum`.`clusternode` `srcclusternode` on((`srcclusternode`.`id` = `inventorysrcvolume`.`nodeId`))) left join `netapp_model_view`.`aggregate` `inventorysrcaggregate` on((`inventorysrcaggregate`.`objid` = `inventorysrcvolume`.`aggregateId`))) left join `ocum`.`aggregate` `srcaggregate` on((`srcaggregate`.`id` = `inventorysrcvolume`.`aggregateId`))) left join `netapp_model_view`.`storage_service` `inventorystorageservice` on(((`inventorystorageservice`.`objid` = `inventorydestvolume`.`storageServiceId`) and (`inventorystorageservice`.`storageServiceIdentifier` >= 0)))) left join `ocum`.`storageserviceconnectionmember` on((`ocum`.`storageserviceconnectionmember`.`relationship_id` = `inventorysnapmirror`.`objid`))) left join `ocum`.`storageserviceconnection` on((`ocum`.`storageserviceconnection`.`id` = `ocum`.`storageserviceconnectionmember`.`connection_id`))) left join `netapp_model_view`.`snap_mirror_policy` `inventorysnapmirrorpolicy` on((`inventorysnapmirrorpolicy`.`objid` = `inventorysnapmirror`.`snapMirrorPolicyId`))) left join `netapp_model_view`.`job_schedule` `inventoryjobschedule` on((`inventoryjobschedule`.`objid` = `inventorysnapmirror`.`jobScheduleId`))) where (((`inventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`inventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`inventorysnapmirror`.`relationshipTypeRaw` = 'vault')) and (isnull(`inventorysrcvserver`.`isRepository`) or (`inventorysrcvserver`.`isRepository` = 0)))