Query Server Type and virtual / physical

[jonnyni]

Hi All 🙂

Was wondering if anyone has a query to give the following information:

Server type - Make Model IP Address
Physical / Virtual - If virtual specify host server by name

Would be very much appreciated


Many thanks

Jonny

[Hemoco · Accepted solution]

Basic report that shows vendor, model and IP address for server-type machines:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputers.LastknownIP
From tblComputers Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Domainrole > 1
Order By tblComputers.ComputerUnique

Your best bet to distinguish physical from virtual machines is to look at tblComputerSystemProduct.Vendor and filter this field.