Determining if a node is virtual or not

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

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