Asset inventory with serial numbers for physical servers. Anyone have a report for this?

rblakely

I'm wanting an asset report for physical servers only and wanting teh following information;

Make

Model

Serial #

Node name

Node IP

Location

Thx in advance

Seashore

Proved to be harder than anticipated to filter out just the physical server but hope this will do.

SELECT
    N.MachineType AS [OS]
    ,N.Caption as [Node Name]
    ,N.IP_Address as [Node IP]
    ,N.Location
    ,N.AssetInventory.ServerInformation.HardwareSerialNumber
    ,N.AssetInventory.ServerInformation.Manufacturer
    ,N.AssetInventory.ServerInformation.Model

FROM Orion.Nodes as N
LEFT OUTER JOIN Orion.VIM.Virtualmachines AS VM ON N.NodeID=VM.NodeID
WHERE 
    N.Category=2 -- 2=Server
    AND VM.NodeID IS NULL
    AND N.AssetInventory.ServerInformation.Manufacturer !='VMware, Inc.'
    AND N.AssetInventory.ServerInformation.Model NOT LIKE '%Virtual%'

Some explanation for the filters:

First, just include all 'servers'
Then,  remove all virtual machines we know of
Then, still had some virtual objects, so remove all vmware stuff
Finally, remove some virtual Azure servers

That worked in my installation. Hope it's ok in yours too.