View ocum_report_birt.volumerelationshiphistoryyearview 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
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
startTime datetime 19  √  null
endTime datetime 19  √  null
transferDuration bigint 19  √  null
transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
operationType varchar 255  √  null The type of the operation happened on the relationship.
operationResult varchar 255  √  null The result of the SnapMirror operation.
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
unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
readableCreateTime datetime 19  √  null
readableUpdateTime datetime 19  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `inventorysrcvolume`.`name` AS `sourceVolumeName`,`inventorysrcvserver`.`name` AS `sourceVserverName`,`inventorysrccluster`.`name` AS `sourceClusterName`,`inventorydestvolume`.`name` AS `destinationVolumeName`,`inventorydestvserver`.`name` AS `destinationVserverName`,`inventorydestcluster`.`name` AS `destinationClusterName`,from_unixtime(`inventorysnapmirrorhistoryfull`.`startTime`) AS `startTime`,from_unixtime(`inventorysnapmirrorhistoryfull`.`endTime`) AS `endTime`,(`inventorysnapmirrorhistoryfull`.`endTime` - `inventorysnapmirrorhistoryfull`.`startTime`) AS `transferDuration`,`inventorysnapmirrorhistoryfull`.`transferSize` AS `transferSize`,`inventorysnapmirrorhistoryfull`.`operationTypeRaw` AS `operationType`,`inventorysnapmirrorhistoryfull`.`resultRaw` 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`,`inventorysnapmirrorhistoryfull`.`startTime` AS `unixformatStartTime`,`inventorysnapmirrorhistoryfull`.`endTime` AS `unixformatEndTime`,from_unixtime((`inventorysnapmirrorhistoryfull`.`createtime` / 1000)) AS `readableCreateTime`,from_unixtime((`inventorysnapmirrorhistoryfull`.`updatetime` / 1000)) AS `readableUpdateTime` from (((((((((((((((((((((((((((`netapp_model_view`.`snap_mirror_history_full` `inventorysnapmirrorhistoryfull` straight_join `netapp_model_view`.`snap_mirror` `inventorysnapmirror` on((`inventorysnapmirror`.`objid` = `inventorysnapmirrorhistoryfull`.`snapMirrorId`))) 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` = `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)) and (from_unixtime(`inventorysnapmirrorhistoryfull`.`startTime`) >= (now() - interval 1 year)))