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.
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.
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.