Modern Dashboards on Virtualization

WinterSoldier

Hi,

Has anyone created a Modern Dashboards on Virtualization (VMAN) which gives summary of everything?

Find more posts tagged with

2023.1

Virtualization

vman

solarwinds

Modern Dashboards

Accepted answers

All comments

pavel.hardak

This question seems to be related to HCO (Hybrid Cloud Observability) product. Would you mind posting it on the right forum, which is monitored by the relevant PMs and Eng folks?

ecklerwr1

This is a good point though since those of us with HCO have all the modules. I'm not there yet but this will be first time I have all the tools in one place.

Bill

WinterSoldier

I believe this is for VMAN module. Apologies for the delayed response. Please help me with the correct path to report this.

Also, I was working on below query to get the devices count of hosts, clusters and VMs monitored through VMAN.

Select DC.Name
, VCC.DisplayName AS VCenter
, VCC.Name AS IP
, Count(VM.VirtualMachineID) AS VMs
, Count(VH.HostID) as Hosts
, Count(VC.ClusterID) AS Clusters

FROM  Orion.VIM.VCenters VCC
Left JOIN Orion.VIM.DataCenters DC ON DC.VCenterID = VCC.VCenterID
Left JOIN Orion.VIM.Clusters VC ON VC.DataCenterID = DC.DataCenterID
Left JOIN Orion.VIM.Hosts VH ON VH.ClusterID = VC.ClusterID
Left JOIN Orion.VIM.VirtualMachines VM ON VM.HostID = VH.HostID


Group BY VCenter, DC.Name, IP

However, this is not showing the correct count. May be there's something wrong in SQL joins. Can you help if possible please?

Thanks in advance.