View ocum.nfsexportreportview | Generated by SchemaSpy |
View Definition:
select `inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,(case when (isnull(`inventoryqtree`.`name`) or (`inventoryqtree`.`name` = '')) then `inventoryvolume`.`junctionPath` else concat(`inventoryvolume`.`junctionPath`,'/',`inventoryqtree`.`name`) end) AS `junctionPath`,`inventoryvolume`.`isJunctionActive` AS `isJunctionPathActive`,`inventoryvolume`.`isVserverRoot` AS `isVserverRoot`,`inventoryvolume`.`stateRaw` AS `volumeState`,(case when (isnull(`inventoryqtree`.`name`) or (`inventoryqtree`.`name` = '')) then NULL else `inventoryqtree`.`objid` end) AS `qtreeId`,(case when (isnull(`inventoryqtree`.`name`) or (`inventoryqtree`.`name` = '')) then NULL else `inventoryqtree`.`name` end) AS `qtreeName`,(case when (((`inventoryvolume`.`stateRaw` = 'offline') or (`inventoryvolume`.`stateRaw` = 'restricted') or (`inventoryvolume`.`stateRaw` = 'mixed') or (not(coalesce(`inventoryvolume`.`isJunctionActive`,FALSE))) or (not(coalesce(`inventoryvserver`.`nfsEnabled`,FALSE))) or (`ocum`.`volume`.`unAvailableParentVolumeId` is not null)) and (not(coalesce(`inventoryvolume`.`isVserverRoot`,FALSE)))) then 'error' else 'normal' end) AS `nfsStatus`,`inventoryvolume`.`securityStyleRaw` AS `securityStyle`,`ocum`.`na_unixPermissionRWX`(`inventoryvolume`.`securityPermissions`) AS `securityPermission`,`inventoryexportpolicy`.`objid` AS `exportPolicyId`,`inventoryexportpolicy`.`name` AS `exportPolicyName`,`inventoryexportrule`.`ruleIndex` AS `ruleIndex`,`inventoryexportrule`.`accessProtocol` AS `ruleAccessProtocol`,`inventoryexportrule`.`clientMatch` AS `ruleClientMatch`,`inventoryexportrule`.`roRule` AS `ruleRoRule`,`inventoryexportrule`.`rwRule` AS `ruleRwRule`,`ocumschemacluster`.`fqdn` AS `clusterFqdn` from (((((((`netapp_model_view`.`volume` `inventoryvolume` straight_join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`qtree` `inventoryqtree` on((`inventoryqtree`.`volumeId` = `inventoryvolume`.`objid`))) straight_join `netapp_model_view`.`export_policy` `inventoryexportpolicy` on((`inventoryexportpolicy`.`objid` = (case when isnull(`inventoryqtree`.`objid`) then `inventoryvolume`.`exportPolicyId` else `inventoryqtree`.`exportPolicyId` end)))) straight_join `netapp_model_view`.`export_rule` `inventoryexportrule` on((`inventoryexportrule`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryexportpolicy`.`vserverId`))) straight_join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryexportpolicy`.`clusterId`))) join `ocum`.`cluster` `ocumschemacluster` on((`inventorycluster`.`objid` = `ocumschemacluster`.`cluster_id`))) where (((`inventoryexportrule`.`accessProtocol` like '%nfs%') or (`inventoryexportrule`.`accessProtocol` like '%any%')) and (`inventoryvolume`.`derivedStyle` in ('FLEXVOL','INFINIVOL','FLEXGROUP')) and ((`inventoryvserver`.`isRepository` <> 1) or (`inventoryvolume`.`objid` <> `inventoryvserver`.`rootVolumeId`)) and (`inventoryvolume`.`junctionPath` <> ' '))