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.
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.
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.