View ocum.exportrulelivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventoryexportrule`.`objid` AS `id`,`inventoryexportpolicy`.`objid` AS `exportPolicyId`,`inventoryexportpolicy`.`name` AS `exportPolicyName`,`ocum`.`exportpolicy`.`healthStatus` AS `exportPolicyHealthStatus`,`inventoryexportrule`.`ruleIndex` AS `ruleIndex`,`inventoryexportrule`.`accessProtocol` AS `accessProtocol`,`inventoryexportrule`.`clientMatch` AS `clientMatch`,`inventoryexportrule`.`roRule` AS `roRule`,`inventoryexportrule`.`rwRule` AS `rwRule`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus` from ((((`netapp_model_view`.`export_rule` `inventoryexportrule` straight_join `netapp_model_view`.`export_policy` `inventoryexportpolicy` on((`inventoryexportrule`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) straight_join `ocum`.`exportpolicy` on((`ocum`.`exportpolicy`.`id` = `inventoryexportpolicy`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryexportrule`.`vserverId` = `inventoryvserver`.`objid`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`)))
Possibly Referenced Tables/Views: