View ocum_report_birt.svminventoryreport 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
clusterName varchar 255  √  null
vserverName varchar 255 Textual name
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
state enum 12  √  null Data serving state of Vserver
volumeCount bigint 19  √  null
maximumVolumes int 10  √  null Maximum number of volumes that can be created on the Vserver
rootVolume varchar 255  √  null
allowedProtocols varchar 255  √  null Ordered list of allowed protocols. List of: cifs, nfs, iscsi, and fcp
dnsDomainNames varchar 255  √  null List of DNS domains. The first domain is the one that the Vserver belongs to
activeNisDomainName varchar 255  √  null DERIVED. Domain name of the active NIS server - NULL if none is active.
ldapClientEnabled bit 0  √  null If true, the corresponding Lightweight Directory Access Protocol (LDAP) configuration is enabled for this Vserver.
nameServerSwitch varchar 255  √  null Name Server switch configuration details for the Vserver.Multiple values will be ordered comma separated

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select (select `cluster`.`name` from `netapp_model_view`.`cluster` where (`cluster`.`objid` = `vserver`.`clusterId`)) AS `clusterName`,`vserver`.`name` AS `vserverName`,`vserver`.`objid` AS `vserverId`,`vserver`.`state` AS `state`,(select count(0) from `netapp_model_view`.`volume` where ((`volume`.`vserverId` = `vserver`.`objid`) and (`volume`.`styleExtended` in ('FLEXVOL','FLEXGROUP')))) AS `volumeCount`,`vserver`.`maximumVolumes` AS `maximumVolumes`,(select `volume`.`name` from `netapp_model_view`.`volume` where (`volume`.`objid` = `vserver`.`rootVolumeId`)) AS `rootVolume`,`vserver`.`allowedProtocols` AS `allowedProtocols`,`vserver`.`dnsDomainNames` AS `dnsDomainNames`,`vserver`.`activeNisDomainName` AS `activeNisDomainName`,`vserver`.`ldapClientEnabled` AS `ldapClientEnabled`,`vserver`.`nameServerSwitch` AS `nameServerSwitch` from `netapp_model_view`.`vserver` where (`vserver`.`type` = 'DATA')