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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now