View ocum.volumedatatransferstatusview 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
relationshipId bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
sourceVolumeName varchar 255  √  null Textual name
sourceVserverName varchar 255  √  null Textual name
sourceClusterName varchar 255  √  null Textual name
destinationVolumeName varchar 255 Textual name
destinationVserverName varchar 255 Textual name
destinationClusterName varchar 255 Textual name
sourceClusterFqdn varchar 255  √  null
destinationClusterFqdn varchar 255  √  null
transferStartTime datetime 19  √  null
transferEndTime datetime 19  √  null
transferDuration decimal 24,3  √  null
transferSize decimal 23,3  √  null
operationType varchar 255
operationResult int 10 0
additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorysnapmirror`.`objid` AS `relationshipId`,`inventorysrcvolume`.`name` AS `sourceVolumeName`,`inventorysrcvserver`.`name` AS `sourceVserverName`,`inventorysrccluster`.`name` AS `sourceClusterName`,`inventorydestvolume`.`name` AS `destinationVolumeName`,`inventorydestvserver`.`name` AS `destinationVserverName`,`inventorydestcluster`.`name` AS `destinationClusterName`,`ocumschemasourcecluster`.`fqdn` AS `sourceClusterFqdn`,`ocumschemadestinationcluster`.`fqdn` AS `destinationClusterFqdn`,from_unixtime(if((`inventorysnapmirrorhistoryfull`.`startTime` = 0),NULL,`inventorysnapmirrorhistoryfull`.`startTime`)) AS `transferStartTime`,from_unixtime(if((`inventorysnapmirrorhistoryfull`.`endTime` = 0),NULL,`inventorysnapmirrorhistoryfull`.`endTime`)) AS `transferEndTime`,round(if(((`inventorysnapmirrorhistoryfull`.`endTime` = 0) or (`inventorysnapmirrorhistoryfull`.`startTime` = 0)),NULL,((`inventorysnapmirrorhistoryfull`.`endTime` - `inventorysnapmirrorhistoryfull`.`startTime`) / 60)),3) AS `transferDuration`,round((`inventorysnapmirrorhistoryfull`.`transferSize` / (1024 * 1024)),3) AS `transferSize`,ifnull(`inventorysnapmirrorhistoryfull`.`operationTypeRaw`,'NOT_MAPPED') AS `operationType`,if((`inventorysnapmirrorhistoryfull`.`resultRaw` = 'success'),TRUE,FALSE) AS `operationResult`,`inventorysnapmirrorhistoryfull`.`additionalInfo` AS `additionalInfo`,`inventorysrcvolume`.`objid` AS `sourceVolumeId`,`inventorysrcvserver`.`objid` AS `sourceVserverId`,`inventorysrccluster`.`objid` AS `sourceClusterId`,`inventorydestvolume`.`objid` AS `destinationVolumeId`,`inventorydestvserver`.`objid` AS `destinationVserverId`,`inventorydestcluster`.`objid` AS `destinationClusterId` from (((((((((((((((((((((`netapp_model_view`.`snap_mirror_history_full` `inventorysnapmirrorhistoryfull` join `netapp_model_view`.`snap_mirror` `inventorysnapmirror` on((`inventorysnapmirror`.`objid` = `inventorysnapmirrorhistoryfull`.`snapMirrorId`))) join `ocum`.`snapmirrorrelationship` `snapmirror` on((`snapmirror`.`id` = `inventorysnapmirror`.`objid`))) join `netapp_model_view`.`volume` `inventorydestvolume` on((`inventorydestvolume`.`objid` = `inventorysnapmirror`.`destinationVolumeId`))) 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`))) join `netapp_model_view`.`vserver` `inventorydestvserver` on((`inventorydestvserver`.`objid` = `inventorysnapmirror`.`destinationVserverId`))) join `ocum`.`vserver` `destvserver` on((`destvserver`.`id` = `inventorysnapmirror`.`destinationVserverId`))) join `netapp_model_view`.`cluster` `inventorydestcluster` on((`inventorydestcluster`.`objid` = `inventorysnapmirror`.`destinationClusterId`))) left join `netapp_model_view`.`node` `inventorydestclusternode` on((`inventorydestclusternode`.`objid` = `inventorysnapmirror`.`destinationNodeId`))) 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 `netapp_model_view`.`node` `inventorysrcclusternode` on((`inventorysrcclusternode`.`objid` = `inventorysrcvolume`.`nodeId`))) 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`.`derivedRelationshipType` <> 'sync_mirror_strict') and (`inventorysnapmirror`.`derivedRelationshipType` <> 'sync_mirror') and (`inventorysnapmirror`.`derivedRelationshipType` is not null) and (isnull(`inventorysrcvserver`.`isRepository`) or (`inventorysrcvserver`.`isRepository` = 0)) and ((`inventorydestvolume`.`derivedStyle` = 'FLEXVOL') or (`inventorydestvolume`.`derivedStyle` = 'FLEXGROUP')) and (`inventorysnapmirrorhistoryfull`.`startTime` > (select unix_timestamp(((select now()) - interval 1 month)))))
 
Possibly Referenced Tables/Views: