View ocum.volumerelationshiplivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventorysnapmirror`.`objid` AS `objectId`,`inventorysnapmirror`.`objid` AS `id`,`inventorysnapmirror`.`relationshipControlPlane` AS `controlPlane`,`inventorysnapmirror`.`relationshipTypeRaw` AS `relationshipType`,`inventorysnapmirror`.`derivedRelationshipType` AS `derivedRelationshipType`,`inventorysnapmirror`.`mirrorStateRaw` AS `relationshipState`,`ocumschemasourcecluster`.`fqdn` AS `sourceClusterFqdn`,`ocumschemadestinationcluster`.`fqdn` AS `destinationClusterFqdn`,(case when (((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) and (`snapmirror`.`overallStatus` <> 'NORMAL')) then FALSE else `inventorysnapmirror`.`isHealthy` end) AS `isHealthy`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then NULL else `inventorysnapmirror`.`lastTransferDuration` end) AS `lastTransferDuration`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then NULL else `inventorysnapmirror`.`lastTransferSize` end) AS `lastTransferSize`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then NULL else `inventorysnapmirror`.`lastTransferEndTimestamp` end) AS `lastTransferEndTime`,`inventorysnapmirror`.`lagTime` AS `lagDuration`,`inventorysnapmirror`.`relationshipStatusRaw` AS `relationshipStatus`,`inventorysnapmirror`.`unhealthyReason` AS `unhealthyReason`,`snapmirror`.`name` AS `name`,`snapmirror`.`healthStatus` AS `healthStatus`,`snapmirror`.`overallStatus` AS `overallStatus`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then 'NOT_APPLICABLE' else `snapmirror`.`lagStatus` end) AS `lagStatus`,(unix_timestamp(`snapmirror`.`lastSuccessfulTransferEndTimestamp`) * 1000) AS `lastSuccessfulUpdateTime`,coalesce(concat(`inventorydestcluster`.`name`,'://',`inventorydestvserver`.`name`,'/',`inventorydestvolume`.`name`),'') AS `destinationPath`,`inventorydestvolume`.`objid` AS `destinationVolumeId`,`inventorydestvolume`.`name` AS `destinationVolumeName`,`destvolume`.`healthStatus` AS `destinationVolumeHealthStatus`,`inventorydestvolume`.`stateRaw` AS `destinationVolumeState`,`inventorydestvolume`.`volTypeRaw` AS `destinationVolumeType`,`inventorydestvserver`.`objid` AS `destinationVserverId`,`inventorydestvserver`.`name` AS `destinationVserverName`,`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`,`inventorydestcluster`.`name` AS `destinationClusterName`,`destcluster`.`healthStatus` AS `destinationClusterHealthStatus`,`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`,`inventorysrcvolume`.`name` AS `sourceVolumeName`,`srcvolume`.`healthStatus` AS `sourceVolumeHealthStatus`,`inventorysrcvolume`.`stateRaw` AS `sourceVolumeState`,`inventorysrcvolume`.`volTypeRaw` AS `sourceVolumeType`,`inventorysrcvserver`.`objid` AS `sourceVserverId`,`inventorysrcvserver`.`name` AS `sourceVserverName`,`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`,`inventorysrccluster`.`name` AS `sourceClusterName`,`srccluster`.`healthStatus` AS `sourceClusterHealthStatus`,`inventorysrccluster`.`version` AS `sourceClusterVersion`,`inventorysrccluster`.`versionGeneration` AS `sourceClusterVersionGeneration`,`inventorysrccluster`.`versionMajor` AS `sourceClusterVersionMajor`,`inventorysrccluster`.`versionMinor` AS `sourceClusterVersionMinor`,`inventorysnapmirrorpolicy`.`objid` AS `snapMirrorPolicyId`,`inventorysnapmirrorpolicy`.`name` AS `snapMirrorPolicyName`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then 'Not Applicable' else `inventorysnapmirrorpolicy`.`transferPriorityRaw` end) AS `transferPriority`,`inventorysnapmirrorpolicy`.`type` AS `snapMirrorPolicyType`,`snapmirror`.`isVersionFlexibleReplicationEnabled` AS `versionFlexibleReplication`,`srcvolume`.`nodeCount` AS `sourceNodeCount`,`destvolume`.`nodeCount` AS `destinationNodeCount`,`inventorysrcvolume`.`derivedStyle` AS `sourceVolumeStyle`,`inventorydestvolume`.`derivedStyle` AS `destinationVolumeStyle`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then 0 else `inventoryjobschedule`.`objid` end) AS `scheduleId`,(case when ((`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror_strict') or (`inventorysnapmirror`.`derivedRelationshipType` = 'sync_mirror')) then 'Not Applicable' else `inventoryjobschedule`.`name` end) AS `scheduleName`,`inventorystorageservice`.`storageServiceName` AS `storageServiceName` 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` = `inventorydestvolume`.`nodeId`))) left join `ocum`.`clusternode` `destclusternode` on((`destclusternode`.`id` = `inventorysnapmirror`.`destinationNodeId`))) left join `netapp_model_view`.`aggregate` `inventorydestaggregate` on((`inventorydestaggregate`.`objid` = `inventorydestvolume`.`aggregateId`))) left 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`))) left join `ocum`.`cluster` `ocumschemasourcecluster` on((`inventorysnapmirror`.`sourceClusterId` = `ocumschemasourcecluster`.`cluster_id`))) left join `ocum`.`cluster` `ocumschemadestinationcluster` on((`inventorysnapmirror`.`destinationClusterId` = `ocumschemadestinationcluster`.`cluster_id`))) where (((`inventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`inventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`inventorysnapmirror`.`relationshipTypeRaw` = 'vault')) and (isnull(`inventorysrcvserver`.`isRepository`) or (`inventorysrcvserver`.`isRepository` = 0)))
Possibly Referenced Tables/Views: