View ocum_report.volumeprotectionview 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
sourceVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
destinationVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
destinationVolumeName varchar 255  √  null Textual name
destinationVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
destinationVserverName varchar 255  √  null Textual name
destinationClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
destinationClusterName varchar 255  √  null Textual name
protectionRole varchar 13
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
relationshipTypeRaw varchar 255  √  null Raw relationship status enum value
lastTransferSize bigint 19  √  null The total number of bytes transferred as part of the last transfer. ZAPI: snapmirror-info.last-transfer-size

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `inventoryvolume`.`objid` AS `sourceVolumeId`,`inventorydestvolume`.`objid` AS `destinationVolumeId`,`inventorydestvolume`.`name` AS `destinationVolumeName`,`inventorydestvserver`.`objid` AS `destinationVserverId`,`inventorydestvserver`.`name` AS `destinationVserverName`,`inventorydestcluster`.`objid` AS `destinationClusterId`,`inventorydestcluster`.`name` AS `destinationClusterName`,(case when ((`inventoryvolume`.`volTypeRaw` = 'rw') and isnull(`incominginventorysnapmirror`.`objid`) and isnull(`outgoinginventorysnapmirror`.`sourceVolumeId`)) then 'unprotected' when ((`inventoryvolume`.`volTypeRaw` = 'rw') and (`outgoinginventorysnapmirror`.`sourceVolumeId` is not null)) then 'protected' when ((`inventoryvolume`.`volTypeRaw` = 'dp') or ((`inventoryvolume`.`volTypeRaw` = 'rw') and (`incominginventorysnapmirror`.`objid` is not null) and ((`incominginventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'vault')))) then 'destination' else 'notApplicable' end) AS `protectionRole`,`inventorysnapmirrorpolicy`.`objid` AS `snapMirrorPolicyId`,`inventorysnapmirrorpolicy`.`name` AS `snapMirrorPolicyName`,`inventoryjobschedule`.`objid` AS `scheduleId`,`inventoryjobschedule`.`name` AS `scheduleName`,`incominginventorysnapmirror`.`relationshipTypeRaw` AS `relationshipTypeRaw`,`incominginventorysnapmirror`.`lastTransferSize` AS `lastTransferSize` from (((((((((`netapp_model_view`.`volume` `inventoryvolume` left join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryvolume`.`vserverId`))) left join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryvolume`.`clusterId`))) left join `netapp_model_view`.`snap_mirror` `incominginventorysnapmirror` on(((`incominginventorysnapmirror`.`destinationVolumeId` = `inventoryvolume`.`objid`) and ((`incominginventorysnapmirror`.`relationshipTypeRaw` = 'data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'extended_data_protection') or (`incominginventorysnapmirror`.`relationshipTypeRaw` = 'vault'))))) left join `ocum`.`volumeoutgoingrelationshipview` `outgoinginventorysnapmirror` on((`outgoinginventorysnapmirror`.`sourceVolumeId` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`volume` `inventorydestvolume` on((`inventorydestvolume`.`objid` = `incominginventorysnapmirror`.`sourceVolumeId`))) left join `netapp_model_view`.`vserver` `inventorydestvserver` on((`inventorydestvserver`.`objid` = `incominginventorysnapmirror`.`sourceVserverId`))) left join `netapp_model_view`.`cluster` `inventorydestcluster` on((`inventorydestcluster`.`objid` = `incominginventorysnapmirror`.`sourceClusterId`))) left join `netapp_model_view`.`snap_mirror_policy` `inventorysnapmirrorpolicy` on((`inventorysnapmirrorpolicy`.`objid` = `incominginventorysnapmirror`.`snapMirrorPolicyId`))) left join `netapp_model_view`.`job_schedule` `inventoryjobschedule` on((`inventoryjobschedule`.`objid` = `incominginventorysnapmirror`.`jobScheduleId`)))