Number of hosts per cluster in Report?

alang  wrote: I am trying to include the number of hosts in each VMware cluster in my VMAN Orion reports, but cannot seem to find it in the available data. VMAN definitely knows the number of hosts per cluster, because if you hover over a cluster it will show #Hosts. What am I missing? Thanks.

Are you looking just for the pure count or a report of the related hosts?

If you add a custom table, specifying a swql query such as:
"SELECT C.DisplayName as clusterName, H.DisplayName as hostName FROM Orion.VIM.Clusters C Inner Join Orion.VIM.Hosts H on C.ClusterId = H.ClusterId"

Then you can gorup the results to create a report by cluster name that would give you all the associated hosts with the cluster.

you can modify the SWQL query to include only the count of hosts for instance like the following:

SELECT C.DisplayName as clusterName, COUNT(H.DisplayName) as hostcount FROM Orion.VIM.Clusters C Inner Join Orion.VIM.Hosts H on C.ClusterId = H.ClusterId GROUP BY C.DisplayName

Would give results such as the following:

I am still trying to re-create reports that were readily available from the old VMAN appliance. Something like this would be great. Can the host count be integrated into the original table?

What I'm also still waiting for is the predictive capacity capability that the old appliance provided, like below:

Hello.

I spent half an hour testing around with a custom table and its fields. The best I came up with in regards of showing the amount of hosts that belong to a cluster is the "computed polling source". In my example I have (unmonitored Bastogne) St. Petersburg with 2 ESXi hosts and I have Sydney datacenter that has 1 host and 1 cluster managing 2 ESXi hosts.

Best regards,

Steffen

Thanks Steffen. I tried your suggestion, but it seems the Computer Polling Source is always 2 for every cluster, regardless of the number of hosts. Would have been nice...

Thanks Steffen. I tried your suggestion, but it seems the Computer Polling Source is always 2 for every cluster, regardless of the number of hosts. Would have been nice...

oh bummer, looks like a feature request then for serena​