A little report that shows a list of virtual machines on all monitored esx-hosts which are not yet monitored. For us it was very helpfull, maybe also for others.
You should look to the WSQL statement and exclude for example templates form the list.
If you like only to see the running VM's which are not monitored you can add in the where-clause an
AND vn.PowerState = 'poweredOn'
What would the code be to have a column for power status. This way you can see which servers are on or off with one report.
Thanks
Never mind I figured it out (BOLD). Here is the code for anyone else looking to do this as well.
select
vn.name AS VirtualServer, vn.GuestName AS OperatingSystem,vh.HostName AS ESXHost, vn.PowerState AS PowerState
from
Orion.VIM.VirtualMachines vn
join Orion.VIM.Hosts vh on vn.HostID=vh.HostID
where
vn.GuestName not like 'Microsoft Windows 7%'
and
vn.Nodestatus=0
Result
Sorry I didn't see your comment before. Thanks for the suggestion but be aware taht the report only shows the Virtual Severs which are not yet monitored. You see with this report not the powerstate of the servers which are monitored (vn.Nodestatus=0).
Kind regards,
Ralf
Right I just wanted to know the power state as they may be templates or VM's my group is building as new servers. This way if they are on i can find out who may own/working on and figure out why it hasn't been added to solarwinds.
thanks for the heads up tho
