PC Model Report

[mattgbarnes]

We are drawing up a PC Replacement plan for our company and I need a report that will show the following.

PC name, manufacturer, model, IP, and last seen.

Thanks!

[Hemoco · Accepted solution]

Please try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputers.LastknownIP, tblComputers.Lastseen
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Order By tblComputers.Computername