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...

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

alang  wrote: 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?          Virtual Datacenter Cluster Name Host Count CPU Cores CPU Load Memory Total Memory Used System Management MGMNT 2 56 20% 1,024 GB 20% Test cluster USETST-BL 3 84 14% 1,536 GB 56% What I'm also still waiting for is the predictive capacity capability that the old appliance provided, like below:            Virtual Datacenter Cluster Name Host Count CPU Cores CPU Load Memory Total Memory Used # VMs Addtl' VM Capacity VM Constraint System Management MGMNT 2 56 20% 1,024 GB 20% 11 9 Disk Test cluster USETST-BL 3 84 14% 1,536 GB 56% 108 48 Disk

So, using the SWQL query that I provided you can absolutely add those fields to the report. I'm curious as well, have you been utilizing our capacity planning reports? Do they not include all the fields that you are looking for?

Serena, I was able to use your SWQL query to add a second table with the number of cluster nodes, but I am not sure how to get this information into the same table with the other information? I'm sorry, I have never used custom queries like that and am probably missing something.

Yes, I tried that Capacity Reports and we actually talked about them on the phone earlier this year. Yes, the information is there, but since these reports are not reusable and only work one cluster at a time, they aren't really usable for a large global environment.

Serena, I was able to use your SWQL query to add a second table with the number of cluster nodes, but I am not sure how to get this information into the same table with the other information? I'm sorry, I have never used custom queries like that and am probably missing something.

Yes, I tried that Capacity Reports and we actually talked about them on the phone earlier this year. Yes, the information is there, but since these reports are not reusable and only work one cluster at a time, they aren't really usable for a large global environment.

alang  wrote: Serena, I was able to use your SWQL query to add a second table with the number of cluster nodes, but I am not sure how to get this information into the same table with the other information? I'm sorry, I have never used custom queries like that and am probably missing something. Yes, I tried that Capacity Reports and we actually talked about them on the phone earlier this year. Yes, the information is there, but since these reports are not reusable and only work one cluster at a time, they aren't really usable for a large global environment.

Andreas, I remember our conversation and I'm curious whether you've taken a look at our VMAN beta documents? VMAN Beta Now Available! 

regarding the "multiple cluster" reports we added a nice improvement that I would love your feedback on.

So here's an example of how you can use that SWQL query to modify existing reports. The challenge here is when you're modifying OOTB reports, these have been simplified for the more common use cases, so you'll want to modify the datasource to use the queries rather than the default selector.

so for example I've chosen to edit my Disconnected Host report

I will click the edit next to the datasource to change what data is being provided in a singular table

Right now it's using just a basic selector that searches for all hosts with connection state = unknown

Switch from dynamic query builder over to Advanced Database Query

And start building your query. For instance if I wanted to put

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

Then when I preview the results I would get all of the clusters and their associated hosts.

A nice way to quickly sanity check your SWQL query without installing the SDK tools is to use the web swis page

<ipaddress>/Orion/Admin/swis.aspx

So if I wanted to change the query I gave you to show only the count of hosts that are disconnected in my cluster then the query would look 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 where H.ConnectionState = 'disconnected' GROUP BY C.DisplayName

Does that help? I hope that you get a chance to take a look at the capacity planning updates we've got in beta