Report

[samcarew]

Hi there,
is it possible to create a report that details the last 20 added devices?

I'm trying to find the newest laptops on our LAN.

Thanks

[Hemoco · Accepted solution]

Please try the report below.

Select Top 20 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen
From tblComputers
Order By tblComputers.Firstseen Desc

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.