View ocum.svmrelationshiplivelistdtoview 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: snapmirror-get-iter.snapmirror-info
id bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
relationshipState varchar 255  √  null Raw mirror state enum value
isHealthy bit 0  √  null False if the last manual or scheduled update failed or was aborted, or if the last scheduled update was delayed. Otherwise true
lastTransferDuration bigint 19  √  null
lastTransferSize bigint 19  √  null The total number of bytes transferred as part of the last transfer. ZAPI: snapmirror-info.last-transfer-size
lagDuration bigint 19  √  null
relationshipStatus varchar 255  √  null Raw relationship status enum value
name varchar 2048
healthStatus int 10
overallStatus enum 7  √  null
lagStatus enum 7  √  null
lastSuccessfulUpdateTime bigint 19  √  null
destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
destinationVserverName varchar 255 Textual name
destinationVserverHealthStatus int 10
destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
destinationClusterName varchar 255 Textual name
destinationClusterHealthStatus int 10
sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
sourceVserverName varchar 255  √  null Textual name
sourceVserverHealthStatus int 10  √  null
sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
sourceClusterName varchar 255  √  null Textual name
sourceClusterHealthStatus int 10  √  null
snapMirrorPolicyId bigint 19  √  null
snapMirrorPolicyName varchar 255  √  null The name of the policy.
scheduleId bigint 19  √  null
scheduleName varchar 255  √  null The name of the job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-name

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorysnapmirror`.`objid` AS `objectId`,`inventorysnapmirror`.`objid` AS `id`,`inventorysnapmirror`.`mirrorStateRaw` AS `relationshipState`,`inventorysnapmirror`.`isHealthy` AS `isHealthy`,`inventorysnapmirror`.`lastTransferDuration` AS `lastTransferDuration`,`inventorysnapmirror`.`lastTransferSize` AS `lastTransferSize`,`inventorysnapmirror`.`lagTime` AS `lagDuration`,`inventorysnapmirror`.`relationshipStatusRaw` AS `relationshipStatus`,`snapmirror`.`name` AS `name`,`snapmirror`.`healthStatus` AS `healthStatus`,`snapmirror`.`overallStatus` AS `overallStatus`,`snapmirror`.`lagStatus` AS `lagStatus`,(unix_timestamp(`snapmirror`.`lastSuccessfulTransferEndTimestamp`) * 1000) AS `lastSuccessfulUpdateTime`,`inventorydestvserver`.`objid` AS `destinationVserverId`,`inventorydestvserver`.`name` AS `destinationVserverName`,`destvserver`.`healthStatus` AS `destinationVserverHealthStatus`,`inventorydestcluster`.`objid` AS `destinationClusterId`,`inventorydestcluster`.`name` AS `destinationClusterName`,`destcluster`.`healthStatus` AS `destinationClusterHealthStatus`,`inventorysrcvserver`.`objid` AS `sourceVserverId`,`inventorysrcvserver`.`name` AS `sourceVserverName`,`srcvserver`.`healthStatus` AS `sourceVserverHealthStatus`,`inventorysrccluster`.`objid` AS `sourceClusterId`,`inventorysrccluster`.`name` AS `sourceClusterName`,`srccluster`.`healthStatus` AS `sourceClusterHealthStatus`,`inventorysnapmirrorpolicy`.`objid` AS `snapMirrorPolicyId`,`inventorysnapmirrorpolicy`.`name` AS `snapMirrorPolicyName`,`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`.`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`.`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`.`snap_mirror_policy` `inventorysnapmirrorpolicy` on((`inventorysnapmirrorpolicy`.`objid` = `inventorysnapmirror`.`snapMirrorPolicyId`))) left join `netapp_model_view`.`job_schedule` `inventoryjobschedule` on((`inventoryjobschedule`.`objid` = `inventorysnapmirror`.`jobScheduleId`))) where isnull(`inventorysnapmirror`.`destinationVolumeId`)
 
Possibly Referenced Tables/Views: