[OCI DWH] Get Count of ESXi Hosts in a Cluster in a Datacenter in a vSphere vCenter

on

A very small MySQL query, but a nice one.

SELECT
count(*) AS 'ESXi Host Count',
clusterName,dataCenterName,virtualCenterIP
FROM dwh_inventory.hv_server
GROUP BY 2,3,4 ORDER BY 1 DESC




Comments

Post a Comment