→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

View solution in original post

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