View ocum.nfsexportlivelistdtoview | Generated by SchemaSpy |
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: