View ocum_report_birt.svminventoryreport | Generated by SchemaSpy |
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')