View ocum.vserverlivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventoryvserver`.`objid` AS `id`,`inventoryvserver`.`name` AS `name`,`ocum`.`vserver`.`healthStatus` AS `healthStatus`,`inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`inventoryrootvolume`.`objid` AS `rootVolumeId`,`inventoryrootvolume`.`name` AS `rootVolumeName`,`rootvolume`.`healthStatus` AS `rootVolumeHealthStatus`,`inventorysnapshotpolicy`.`objid` AS `snapshotPolicyId`,`inventorysnapshotpolicy`.`name` AS `snapshotPolicyName`,`ocum`.`snapshotpolicy`.`healthStatus` AS `snapshotPolicyHealthStatus`,`ocum`.`vserver`.`volumeBytesUsed` AS `bytesUsed`,`ocum`.`vserver`.`volumeBytesTotal` AS `bytesTotal`,`ocum`.`vserver`.`volumeBytesAvail` AS `bytesAvail`,`inventoryvserver`.`isRepository` AS `isRepository`,`inventoryvserver`.`nisEnabled` AS `nisEnabled`,`inventoryvserver`.`dnsEnabled` AS `dnsEnabled`,`inventoryvserver`.`cifsEnabled` AS `cifsEnabled`,`inventoryvserver`.`nfsEnabled` AS `nfsEnabled`,`inventoryvserver`.`iscsiEnabled` AS `iscsiEnabled`,`inventoryvserver`.`fcpEnabled` AS `fcpEnabled`,`inventoryvserver`.`nameServerSwitch` AS `nameServerSwitch`,`inventoryvserver`.`activeNisDomainName` AS `activeNisDomainName`,`inventoryvserver`.`activeNisServers` AS `activeNisServers`,`inventoryvserver`.`dnsServers` AS `dnsServers`,`inventoryvserver`.`dnsDomainNames` AS `dnsDomainNames`,`inventoryvserver`.`allowedProtocols` AS `allowedProtocols`,`inventoryvserver`.`stateRaw` AS `state`,`inventorycluster`.`versionGeneration` AS `versionGeneration`,`inventorycluster`.`versionMajor` AS `versionMajor`,`inventorycluster`.`versionMinor` AS `versionMinor`,`inventoryvserver`.`subtype` AS `subType`,`ocumschemacluster`.`fqdn` AS `clusterFqdn`,(select count(0) from `netapp_model_view`.`volume` where ((`volume`.`vserverId` = `inventoryvserver`.`objid`) and (`volume`.`styleExtended` in ('FLEXVOL','FLEXGROUP')))) AS `volumeCount`,`inventoryvserver`.`maximumVolumes` AS `maximumVolumes`,`inventoryvserver`.`ldapClientEnabled` AS `ldapEnabled`,(case when (`inventoryvserver`.`isRepository` = TRUE) then 'InfiniteVol' when (((`inventorycluster`.`versionGeneration` < 9) or ((`inventorycluster`.`versionGeneration` = 9) and (`inventorycluster`.`versionMajor` = 0))) and (`inventoryvserver`.`isRepository` = FALSE)) then 'FlexVol' else 'FlexVol / FlexGroup' end) AS `allowedVolumeType` from ((((((((`netapp_model_view`.`vserver` `inventoryvserver` straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) straight_join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryvserver`.`clusterId`))) join `ocum`.`cluster` `ocumschemacluster` on((`ocumschemacluster`.`cluster_id` = `inventoryvserver`.`clusterId`))) straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventoryvserver`.`clusterId`))) left join `netapp_model_view`.`snapshot_policy` `inventorysnapshotpolicy` on((`inventorysnapshotpolicy`.`objid` = `inventoryvserver`.`snapshotPolicyId`))) left join `ocum`.`snapshotpolicy` on((`ocum`.`snapshotpolicy`.`id` = `inventoryvserver`.`snapshotPolicyId`))) left join `netapp_model_view`.`volume` `inventoryrootvolume` on((`inventoryrootvolume`.`objid` = `inventoryvserver`.`rootVolumeId`))) left join `ocum`.`volume` `rootvolume` on((`rootvolume`.`id` = `inventoryvserver`.`rootVolumeId`)))
Possibly Referenced Tables/Views: