Hello All,
I need to fecth the data for the VMs that are not managed by the Solarwinds but arfe being managed by the VMAN or vcenter in the solarwinds.
There is a prebuilt report for that: All VMs Not in Solarwinds
As as been highlighted there is an out of box report which will list these, but to take this to the next stage, it is possible to utilise the Orion API and create a scripted function, which will automatically add missing VM servers to Orion for monitoring.
Reference links for assistance - Thwack Forum on API, Github repository for the API
If you would like to get the list of VMs that are not managed as nodes, you may use this SQL query:
SELECT Name, GuestName FROM [dbo].[VIM_VirtualMachines]where NodeID is NULL
