View ocum.nfsexportreportview 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
clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterName varchar 255 Textual name
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumeName varchar 255 Textual name
junctionPath varchar 511  √  null
isJunctionPathActive bit 0  √  null If mounted volume is accessible
isVserverRoot bit 0  √  null Is the volume the root of a vserver
volumeState varchar 255  √  null
qtreeId bigint 19  √  null
qtreeName varchar 255  √  null
nfsStatus varchar 6
securityStyle varchar 255  √  null
securityPermission varchar 256  √  null
exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
exportPolicyName varchar 255  √  null Name of the policy
ruleIndex int 10  √  null Export rule index
ruleAccessProtocol varchar 255 Client access protocol. Default value is 'any'. May be comma separated
ruleClientMatch varchar 255 Client match specification for Export rule. The clients specified are enforced with this Export rule. The rule with the higher rule index value takes precedence
ruleRoRule varchar 255  √  null Rule for read-only access. Ordered, comma separated list of the array values in ONTAP.
ruleRwRule varchar 255  √  null Rule for read-write access. Ordered, comma separated list of the array values in ONTAP.
clusterFqdn varchar 255  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

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` <> ' '))
 
Possibly Referenced Tables/Views: