Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Virtual machines

contracer

Hi,

I'm looking for a sql query to show me all virtual machines in my environment.

Thanks.

Find more posts tagged with

Accepted answers

netlogix

@KCWayner - You might want to use PowerState not GuestState

If VMtools aren't running, GuestState show that the server is off, but PowerState is just that.

SELECT     VirtualMachines.DisplayName, VirtualMachines.OperatingSystem, VirtualMachines.PowerState, Nodes.Caption
FROM         VirtualMachines INNER JOIN
                      Nodes ON VirtualMachines.HostNodeID = Nodes.NodeID
Order by PowerState

All comments

KCWayner

Here is the report that we have working. It tells us every virtual on each server.

SELECT     VirtualMachines.DisplayName, VirtualMachines.OperatingSystem, VirtualMachines.GuestState, Nodes.Caption
FROM         VirtualMachines INNER JOIN
                      Nodes ON VirtualMachines.HostNodeID = Nodes.NodeID

byrona

To just display virtual systems I think the following would work; however I think the approach that Wayne took is probably a bit more elegant.

SELECT *
FROM Nodes
WHERE EntityType = 'Orion.VirtualMachine'

byrona

Er, sorry, I had that wrong, I meant to type this...

SELECT Caption
FROM Nodes
WHERE EntityType = 'Orion.VirtualMachine'

netlogix

@KCWayner - You might want to use PowerState not GuestState

If VMtools aren't running, GuestState show that the server is off, but PowerState is just that.

KCWayner

Thanks for that. I have it changed on mine now.

contracer

Thanks a lot for the help.