description report

[dennisatsub]

can I get some assistance on creating a report that is based on the computer description field? I see the "description field empty" report but I want to have a report based on the description field.

many thanks!

Dennis

[dennisatsub]

outstanding! thank you very much!

[Hemoco]

Please use the report below for the information you are after.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername,
tblComputers.Computer, tblComputers.Domain, tblComputers.Lastseen,
tblComputers.Description As [Local Description], tblADComputers.Description As
[AD Description]
From tblComputers Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblADComputers On tblComputers.Computername = tblADComputers.Computername
Order By tblComputers.ComputerUnique

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.