cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jonnyni
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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.