View ocum.cifssharelivelistdtoview 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 Locally unique object identifier. ZAPIs: cifs-share-get-iter.cifs-share
name varchar 255  √  null
path varchar 255  √  null
junctionPath varchar 255  √  null
cifsStatus int 10 0
nfsEquivalent int 10 0
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
derivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
securityStyle varchar 256  √  null
vserverId bigint 19
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
qtreeId bigint 19  √  null Locally unique object identifier. ZAPIs: qtree-list-iter.qtree-info
qtreeName varchar 255  √  null
qtreeHealthStatus int 10  √  null
exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
exportPolicyName varchar 255  √  null
exportPolicyHealthStatus int 10
containingObject varchar 256  √  null
containingObjectType varchar 256  √  null
unAvailableParentVolumeId bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

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: