View ocum.nfsexportlivelistdtoview 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
id bigint 19  √  null
name text 65535  √  null
healthStatus int 10
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
vserverHealthStatus int 10
volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumeName varchar 255 Textual name
volumeHealthStatus int 10
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
qtreeHealthStatus binary 0  √  null
nfsExportStatus varchar 7
isNfsEnabled int 10  √  null
derivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
securityStyle varchar 255  √  null
securityPermission varchar 255  √  null Unix permission bits in octal string format
exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
exportPolicyName varchar 255  √  null Name of the policy
exportPolicyHealthStatus int 10
unAvailableParentVolumeId bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select (case when (isnull(`inventoryqtree`.`name`) or (`inventoryqtree`.`name` = '')) then `inventoryvolume`.`objid` else `inventoryqtree`.`objid` end) AS `id`,(case when (`inventoryvolume`.`derivedStyle` = 'INFINIVOL') then convert(`inventoryvserver`.`name` using utf8mb4) when (isnull(`inventoryqtree`.`name`) or (`inventoryqtree`.`name` = '')) then convert(`inventoryvolume`.`name` using utf8mb4) else (concat(`inventoryqtree`.`name`,' on ',convert(`inventoryvolume`.`name` using utf8mb4)) collate utf8mb4_unicode_ci) end) AS `name`,`ocum`.`volume`.`healthStatus` AS `healthStatus`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`ocum`.`volume`.`healthStatus` AS `volumeHealthStatus`,(case when (isnull(`inventoryqtree`.`name`) or (`inventoryqtree`.`name` = '')) then `inventoryvolume`.`junctionPath` else (concat(`inventoryvolume`.`junctionPath`,'/',`inventoryqtree`.`name`) collate utf8mb4_unicode_ci) 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`,NULL AS `qtreeHealthStatus`,(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 'offline' else 'online' end) AS `nfsExportStatus`,coalesce(`inventoryvserver`.`nfsEnabled`,FALSE) AS `isNfsEnabled`,`inventoryvolume`.`derivedStyle` AS `derivedStyle`,`inventoryvolume`.`securityStyleRaw` AS `securityStyle`,`inventoryvolume`.`securityPermissions` AS `securityPermission`,`inventoryexportpolicy`.`objid` AS `exportPolicyId`,`inventoryexportpolicy`.`name` AS `exportPolicyName`,`ocum`.`exportpolicy`.`healthStatus` AS `exportPolicyHealthStatus`,`ocum`.`volume`.`unAvailableParentVolumeId` AS `unAvailableParentVolumeId` 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 `ocum`.`exportpolicy` on((`ocum`.`exportpolicy`.`id` = `inventoryexportpolicy`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventoryexportpolicy`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`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` <> ' '))
 
Possibly Referenced Tables/Views: