View ocum.cifssharelivelistdtoview | Generated by SchemaSpy |
View Definition:
select `cifs`.`objid` AS `id`,`cifs`.`name` AS `name`,`cifs`.`path` AS `path`,`inventoryvolume`.`junctionPath` AS `junctionPath`,(case when (strcmp(`na_cifsStatus`(`inventoryvolume`.`stateRaw`,`inventoryvolume`.`isJunctionActive`,`inventoryvolume`.`isVserverRoot`,`ocum`.`volume`.`unAvailableParentVolumeId`),'offline') = 0) then 3 else 0 end) AS `cifsStatus`,(case when (`ocum`.`exportpolicy`.`accessProtocols` regexp 'nfs|any') then TRUE else FALSE end) AS `nfsEquivalent`,`inventoryvolume`.`isJunctionActive` AS `isJunctionPathActive`,`inventoryvolume`.`isVserverRoot` AS `isVserverRoot`,`inventoryvolume`.`stateRaw` AS `volumeState`,`inventoryvolume`.`derivedStyle` AS `derivedStyle`,(case when ((`inventoryqtree`.`name` is not null) and (strcmp(`inventoryqtree`.`name`,'') <> 0)) then `inventoryqtree`.`securityStyleRaw` else `inventoryvolume`.`securityStyleRaw` end) AS `securityStyle`,`cifs`.`vserverId` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus`,`inventoryvolume`.`objid` AS `volumeId`,`inventoryvolume`.`name` AS `volumeName`,`ocum`.`volume`.`healthStatus` AS `volumeHealthStatus`,`inventoryqtree`.`objid` AS `qtreeId`,`inventoryqtree`.`name` AS `qtreeName`,`ocum`.`qtree`.`healthStatus` AS `qtreeHealthStatus`,`inventoryexportpolicy`.`objid` AS `exportPolicyId`,(case when coalesce(`inventoryvserver`.`exportPolicyEnabled`,TRUE) then `inventoryexportpolicy`.`name` else 'Not Enabled' end) AS `exportPolicyName`,`ocum`.`exportpolicy`.`healthStatus` AS `exportPolicyHealthStatus`,`na_cifsContainingObject`(`inventoryqtree`.`name`,`inventoryvolume`.`name`) AS `containingObject`,`na_cifsContainingObjectType`(`inventoryqtree`.`name`,`inventoryvolume`.`name`) AS `containingObjectType`,`ocum`.`volume`.`unAvailableParentVolumeId` AS `unAvailableParentVolumeId` from (((((((((`netapp_model_view`.`cifs_share` `cifs` straight_join `ocum`.`cifsshare` on((`cifs`.`objid` = `ocum`.`cifsshare`.`id`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `cifs`.`vserverId`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) straight_join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `ocum`.`cifsshare`.`lastKnownVolumeId`))) straight_join `ocum`.`volume` on((`ocum`.`volume`.`id` = `inventoryvolume`.`objid`))) left join `netapp_model_view`.`qtree` `inventoryqtree` on((`inventoryqtree`.`objid` = `ocum`.`cifsshare`.`lastKnownQtreeId`))) left join `ocum`.`qtree` on((`ocum`.`qtree`.`id` = `inventoryqtree`.`objid`))) straight_join `netapp_model_view`.`export_policy` `inventoryexportpolicy` on((`inventoryvolume`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) straight_join `ocum`.`exportpolicy` on((`ocum`.`exportpolicy`.`id` = `inventoryexportpolicy`.`objid`)))
Possibly Referenced Tables/Views: