This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Virtual+Servers+not+Monitored.xml

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

    pastedImage_2.png

  • 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