View ocum_report_birt.nfsexport | Generated by SchemaSpy |
View Definition:
select `cluster`.`name` AS `clusterName`,(case when (`inventoryvolume`.`derivedStyle` in ('FLEXVOL','FLEXGROUP')) then `inventoryvolume`.`name` else `inventoryvserver`.`name` end) AS `volumeName`,`inventoryvolume`.`stateRaw` AS `volumeState`,`inventoryvserver`.`name` AS `vserverName`,`inventoryvolume`.`junctionPath` AS `junctionPath`,`ocum`.`na_boolToYesNo`(`inventoryvolume`.`isJunctionActive`) AS `isJunctionPathActive`,`inventoryexportpolicy`.`name` AS `exportPolicyName`,`inventoryexportrule`.`ruleIndex` AS `exportPolicyRuleIndex`,`inventoryexportrule`.`accessProtocol` AS `exportPolicyRuleAccessProtocol`,`inventoryexportrule`.`clientMatch` AS `exportPolicyRuleClientMatch`,`inventoryexportrule`.`roRule` AS `exportPolicyRuleRoRule`,`inventoryexportrule`.`rwRule` AS `exportPolicyRuleRwRule`,`inventoryvolume`.`securityStyleRaw` AS `securityStyle`,`ocum`.`na_unixPermissionRWX`(`inventoryvolume`.`securityPermissions`) AS `securityPermission`,NULL AS `qtreeName` from (((((`netapp_model_view`.`volume` `inventoryvolume` join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryvolume`.`vserverId`))) join `netapp_model_view`.`cluster` on((`cluster`.`objid` = `inventoryvolume`.`clusterId`))) join `netapp_model_view`.`export_policy` `inventoryexportpolicy` on((`inventoryvolume`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) join `netapp_model_view`.`export_rule` `inventoryexportrule` on((`inventoryexportrule`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) left join `ocum`.`exportpolicy` on((`ocum`.`exportpolicy`.`id` = `inventoryexportpolicy`.`objid`))) where (((`ocum`.`exportpolicy`.`accessProtocols` like '%nfs%') or (`ocum`.`exportpolicy`.`accessProtocols` like '%any%')) and (`inventoryvolume`.`derivedStyle` in ('FLEXVOL','INFINIVOL','FLEXGROUP')) and ((`inventoryvserver`.`isRepository` <> 1) or (`inventoryvolume`.`objid` <> `inventoryvserver`.`rootVolumeId`)) and (`inventoryvolume`.`junctionPath` <> ' ')) union select `cluster`.`name` AS `clusterName`,`inventoryvolume`.`name` AS `volumeName`,`inventoryvolume`.`stateRaw` AS `volumeState`,`inventoryvserver`.`name` AS `vserverName`,concat(`inventoryvolume`.`junctionPath`,'/',`inventoryqtree`.`name`) AS `junctionPath`,`ocum`.`na_boolToYesNo`(`inventoryvolume`.`isJunctionActive`) AS `isJunctionPathActive`,`inventoryexportpolicy`.`name` AS `exportPolicyName`,`inventoryexportrule`.`ruleIndex` AS `exportPolicyRuleIndex`,`inventoryexportrule`.`accessProtocol` AS `exportPolicyRuleAccessProtocol`,`inventoryexportrule`.`clientMatch` AS `exportPolicyRuleClientMatch`,`inventoryexportrule`.`roRule` AS `exportPolicyRuleRoRule`,`inventoryexportrule`.`rwRule` AS `exportPolicyRuleRwRule`,`inventoryvolume`.`securityStyleRaw` AS `securityStyle`,`ocum`.`na_unixPermissionRWX`(`inventoryvolume`.`securityPermissions`) AS `securityPermission`,`inventoryqtree`.`name` AS `qtreeName` from ((((((`netapp_model_view`.`qtree` `inventoryqtree` join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `inventoryqtree`.`volumeId`))) join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryqtree`.`vserverId`))) join `netapp_model_view`.`cluster` on((`cluster`.`objid` = `inventoryqtree`.`clusterId`))) join `netapp_model_view`.`export_policy` `inventoryexportpolicy` on((`inventoryqtree`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) join `netapp_model_view`.`export_rule` `inventoryexportrule` on((`inventoryexportrule`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) left join `ocum`.`exportpolicy` on((`ocum`.`exportpolicy`.`id` = `inventoryexportpolicy`.`objid`))) where (((`ocum`.`exportpolicy`.`accessProtocols` like '%nfs%') or (`ocum`.`exportpolicy`.`accessProtocols` like '%any%')) and (`inventoryvolume`.`derivedStyle` in ('FLEXVOL','FLEXGROUP')) and ((`inventoryvserver`.`isRepository` <> 1) or (`inventoryvolume`.`objid` <> `inventoryvserver`.`rootVolumeId`)) and (`inventoryvolume`.`junctionPath` <> ' ') and (`inventoryqtree`.`qtreeIdentifier` <> 0))