View ocum_report.volumerelationships 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
id bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
controlPlane varchar 255  √  null The type of the control plane used for the relationship.
relationshipType varchar 255  √  null Raw relationship status enum value
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
lastTransferRate decimal 23,4  √  null
lastTransferStartTime bigint 19  √  null
lastTransferEndTime bigint 19  √  null
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
destinationPath text 65535  √  null
destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
destinationVolumeName varchar 255 Textual name
destinationVolumeState varchar 255  √  null
destinationVolumeType varchar 255  √  null
destinationVolumeSize bigint 19  √  null Size of volume in bytes. Includes WAFL reserve and snapshot reserve
destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
destinationVserverName varchar 255 Textual name
destinationAggregateId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
destinationAggregateName varchar 255 Textual name
destinationClusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
destinationClusterNodeName varchar 255  √  null Textual name
destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
destinationClusterName varchar 255 Textual name
destinationClusterVersion varchar 255  √  null Version of the cluster
destinationClusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
destinationClusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
destinationClusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
sourcePath text 65535  √  null
sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
sourceVolumeName varchar 255  √  null Textual name
sourceVolumeState varchar 255  √  null
sourceVolumeType varchar 255  √  null
sourceVolumeSize bigint 19  √  null Size of volume in bytes. Includes WAFL reserve and snapshot reserve
sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
sourceVserverName varchar 255  √  null Textual name
sourceAggregateId bigint 19  √  null Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
sourceAggregateName varchar 255  √  null Textual name
sourceClusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
sourceClusterNodeName varchar 255  √  null Textual name
sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
sourceClusterName varchar 255  √  null Textual name
sourceClusterVersion varchar 255  √  null Version of the cluster
sourceClusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
sourceClusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
sourceClusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
snapMirrorPolicyId bigint 19  √  null
snapMirrorPolicyName varchar 255  √  null The name of the policy.
transferPriority varchar 255  √  null
snapMirrorPolicyType enum 18  √  null The type of the Snapmirror policy - "vault" , "async_mirror" , "mirror_vault" ,"sync_mirror", "strict_sync_mirror"
scheduleId bigint 19  √  null
scheduleName varchar 255  √  null The name of the job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-name
storageServiceName varchar 255  √  null Storage Service Name. ZAPIs: volume-storage-service-get-iter.storage-service-info.storage-service
destinationVolumeGrowthRate double 22  √  0
versionFlexibleReplication enum 15 none
destinationVolumeHealthStatus int 10
destinationVserverHealthStatus int 10
destinationAggregateHealthStatus int 10
destinationClusterNodeHealthStatus int 10  √  null
destinationClusterHealthStatus int 10
sourceVolumeHealthStatus int 10  √  null
sourceVserverHealthStatus int 10  √  null
sourceAggregateHealthStatus int 10  √  null
sourceClusterNodeHealthStatus int 10  √  null
sourceClusterHealthStatus int 10  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `inventorysnapmirror`.`objid` AS `id`,`inventorysnapmirror`.`relationshipControlPlane` AS `controlPlane`,`inventorysnapmirror`.`relationshipTypeRaw` AS `relationshipType`,`inventorysnapmirror`.`mirrorStateRaw` AS `relationshipState`,`inventorysnapmirror`.`isHealthy` AS `isHealthy`,`inventorysnapmirror`.`lastTransferDuration` AS `lastTransferDuration`,`inventorysnapmirror`.`lastTransferSize` AS `lastTransferSize`,(`inventorysnapmirror`.`lastTransferSize` / `inventorysnapmirror`.`lastTransferDuration`) AS `lastTransferRate`,(unix_timestamp(`inventorysnapmirror`.`lastTransferEndTimestamp`) - `inventorysnapmirror`.`lastTransferDuration`) AS `lastTransferStartTime`,unix_timestamp(`inventorysnapmirror`.`lastTransferEndTimestamp`) AS `lastTransferEndTime`,`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`) AS `lastSuccessfulUpdateTime`,coalesce(concat(`inventorydestcluster`.`name`,'://',`inventorydestvserver`.`name`,'/',`inventorydestvolume`.`name`),'') AS `destinationPath`,`inventorydestvolume`.`objid` AS `destinationVolumeId`,`inventorydestvolume`.`name` AS `destinationVolumeName`,`inventorydestvolume`.`stateRaw` AS `destinationVolumeState`,`inventorydestvolume`.`volTypeRaw` AS `destinationVolumeType`,`inventorydestvolume`.`size` AS `destinationVolumeSize`,`inventorydestvserver`.`objid` AS `destinationVserverId`,`inventorydestvserver`.`name` AS `destinationVserverName`,`inventorydestaggregate`.`objid` AS `destinationAggregateId`,`inventorydestaggregate`.`name` AS `destinationAggregateName`,`inventorydestclusternode`.`objid` AS `destinationClusterNodeId`,`inventorydestclusternode`.`name` AS `destinationClusterNodeName`,`inventorydestcluster`.`objid` AS `destinationClusterId`,`inventorydestcluster`.`name` AS `destinationClusterName`,`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`,`inventorysrcvolume`.`stateRaw` AS `sourceVolumeState`,`inventorysrcvolume`.`volTypeRaw` AS `sourceVolumeType`,`inventorysrcvolume`.`size` AS `sourceVolumeSize`,`inventorysrcvserver`.`objid` AS `sourceVserverId`,`inventorysrcvserver`.`name` AS `sourceVserverName`,`inventorysrcaggregate`.`objid` AS `sourceAggregateId`,`inventorysrcaggregate`.`name` AS `sourceAggregateName`,`inventorysrcclusternode`.`objid` AS `sourceClusterNodeId`,`inventorysrcclusternode`.`name` AS `sourceClusterNodeName`,`inventorysrccluster`.`objid` AS `sourceClusterId`,`inventorysrccluster`.`name` AS `sourceClusterName`,`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`,`inventorystorageservice`.`storageServiceName` AS `storageServiceName`,`volumegrowthrate`.`meanGrowthRate` AS `destinationVolumeGrowthRate`,`snapmirror`.`isVersionFlexibleReplicationEnabled` AS `versionFlexibleReplication`,`destvolume`.`healthStatus` AS `destinationVolumeHealthStatus`,`destvserver`.`healthStatus` AS `destinationVserverHealthStatus`,`destaggregate`.`healthStatus` AS `destinationAggregateHealthStatus`,`destclusternode`.`healthStatus` AS `destinationClusterNodeHealthStatus`,`destcluster`.`healthStatus` AS `destinationClusterHealthStatus`,`srcvolume`.`healthStatus` AS `sourceVolumeHealthStatus`,`srcvserver`.`healthStatus` AS `sourceVserverHealthStatus`,`srcaggregate`.`healthStatus` AS `sourceAggregateHealthStatus`,`srcclusternode`.`healthStatus` AS `sourceClusterNodeHealthStatus`,`srccluster`.`healthStatus` AS `sourceClusterHealthStatus` 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`))) left join `ocum`.`volumegrowthrateinfo` `volumegrowthrate` on((`volumegrowthrate`.`volume_id` = `inventorysnapmirror`.`destinationVolumeId`))) 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)))