View ocum_report.volumeprotectionview | Generated by SchemaSpy |
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`)))