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

Determining if a node is virtual or not

Hello,

Can someone please point me in the direction of where I could find the endpoint/query to determine if a node is a virtual server? We will be using the nodeID or the hostname and doing this via REST.

Thanks!
Dominic

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

You could probably look at the logic in VM's not monitored by SolarWinds as Nodes - Custom Queries - The Orion Platform - THWACK as a starting point.

Seashore

If you have asset inventory added on your server you can use something like below, or a combination with looking at "orion.VIM.virtualmachines".

SELECT
    N.Caption
    ,CASE
       WHEN HW.Model LIKE '%virtual%' THEN 'Virtual'
       WHEN HW.Model LIKE 'VMWare%' THEN 'Virtual'
       WHEN HW.Model IS NULL THEN 'Unknown'
       ELSE 'Physical'
    END AS HWType
    ,HW.Model
FROM Orion.Nodes AS N
LEFT OUTER JOIN
(
    SELECT 
        SI.NodeID
        ,SI.Manufacturer
        ,SI.Model
    FROM Orion.AssetInventory.ServerInformation AS SI
) AS HW ON N.nodeID=HW.nodeid
WHERE n.Category=2 -- 2=Server