View netapp_model_view.snap_mirror | Generated by SchemaSpy |
View Definition:
select `sm`.`objid` AS `objid`,`sm`.`uuid` AS `uuid`,`sm`.`resourceKey` AS `resourceKey`,`rel`.`vserverSnapMirrorId` AS `vserverSnapMirrorId`,`sm`.`clusterId` AS `destinationClusterId`,`sm`.`volumeId` AS `destinationVolumeId`,`sm`.`nodeId` AS `destinationNodeId`,`sm`.`vserverId` AS `destinationVserverId`,`sm`.`destinationLocation` AS `destinationLocation`,`sm`.`sourceClusterId` AS `sourceClusterId`,`sm`.`sourceVolumeId` AS `sourceVolumeId`,`sm`.`sourceVserverId` AS `sourceVserverId`,`sm`.`sourceCluster` AS `sourceCluster`,`sm`.`sourceVolume` AS `sourceVolume`,`sm`.`sourceVserver` AS `sourceVserver`,`sm`.`sourceLocation` AS `sourceLocation`,`sm`.`mirrorState` AS `mirrorState`,`sm`.`mirrorStateRaw` AS `mirrorStateRaw`,`sm`.`exportedSnapshotId` AS `exportedSnapshotId`,`sm`.`newestSnapshotId` AS `newestSnapshotId`,`sm`.`networkCompressionRatio` AS `networkCompressionRatio`,`sm`.`operationId` AS `operationId`,`sm`.`transferSnapshot` AS `transferSnapshot`,`sm`.`snapMirrorPolicyId` AS `snapMirrorPolicyId`,`sm`.`isConstituent` AS `isConstituent`,`sm`.`isHealthy` AS `isHealthy`,`sm`.`maxTransferRate` AS `maxTransferRate`,`sm`.`relationshipProgress` AS `relationshipProgress`,`sm`.`relationshipStatus` AS `relationshipStatus`,`sm`.`relationshipStatusRaw` AS `relationshipStatusRaw`,`sm`.`relationshipType` AS `relationshipType`,`sm`.`relationshipTypeRaw` AS `relationshipTypeRaw`,`sm`.`derivedRelationshipType` AS `derivedRelationshipType`,`sm`.`policyType` AS `policyType`,`sm`.`policyTypeRaw` AS `policyTypeRaw`,`sm`.`tries` AS `tries`,`sm`.`unhealthyReason` AS `unhealthyReason`,`sm`.`snapshotCheckpoint` AS `snapshotCheckpoint`,`sm`.`snapshotProgress` AS `snapshotProgress`,`sm`.`currentMaxTransferRate` AS `currentMaxTransferRate`,`sm`.`currentTransferError` AS `currentTransferError`,`sm`.`currentTransferPriority` AS `currentTransferPriority`,`sm`.`currentTransferPriorityRaw` AS `currentTransferPriorityRaw`,`sm`.`currentTransferType` AS `currentTransferType`,`sm`.`currentTransferTypeRaw` AS `currentTransferTypeRaw`,`sm`.`lagTime` AS `lagTime`,`sm`.`lastTransferDuration` AS `lastTransferDuration`,`sm`.`lastTransferEndTimestamp` AS `lastTransferEndTimestamp`,`sm`.`lastTransferError` AS `lastTransferError`,`sm`.`lastTransferErrorCodes` AS `lastTransferErrorCodes`,`sm`.`lastTransferNetworkCompressionRatio` AS `lastTransferNetworkCompressionRatio`,`sm`.`lastTransferType` AS `lastTransferType`,`sm`.`lastTransferTypeRaw` AS `lastTransferTypeRaw`,`sm`.`lastTransferSize` AS `lastTransferSize`,`sm`.`progressLastUpdated` AS `progressLastUpdated`,`sm`.`relationshipControlPlane` AS `relationshipControlPlane`,`sm`.`relationshipGroupType` AS `relationshipGroupType`,`sm`.`relationshipGroupTypeRaw` AS `relationshipGroupTypeRaw`,`sm`.`relationshipIdentifier` AS `relationshipIdentifier`,`sm`.`jobScheduleId` AS `jobScheduleId`,`sm`.`destVolDerivedStyle` AS `destVolDerivedStyle`,`sm`.`createtime` AS `createTime`,`sm`.`updatetime` AS `updateTime` from (`netapp_model`.`snap_mirror` `sm` left join `netapp_model`.`snap_mirror_self_relationship` `rel` on((`sm`.`objid` = `rel`.`objid`))) where ((`sm`.`objState` = 'LIVE') and (isnull(`rel`.`objState`) or (`rel`.`objState` = 'LIVE')))