View ocum_report_birt.nfsexport 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
clusterName varchar 255
volumeName varchar 255
volumeState varchar 255  √  null
vserverName varchar 255
junctionPath varchar 511  √  null
isJunctionPathActive text 65535  √  null
exportPolicyName varchar 255  √  null
exportPolicyRuleIndex int 10  √  null
exportPolicyRuleAccessProtocol varchar 255
exportPolicyRuleClientMatch varchar 255
exportPolicyRuleRoRule varchar 255  √  null
exportPolicyRuleRwRule varchar 255  √  null
securityStyle varchar 255  √  null
securityPermission varchar 256  √  null
qtreeName varchar 255  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

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))