Report selecting by computer description

[mlesniak]

I should like to create a report that lists the computername and the description for all the computers in a domain that has a given string in the description. Is such a report possible? If so, how do I create it?
I have not created any new reports before so I'm somewhat unskilled.
Any help would be appreciated.

[mlesniak]

Thanks for that. However, I don't think that I have access to the configuration console. I think my manager may not have given me permission to use it. I will have to wait until he returns to the office to find out.

[Hemoco · Accepted solution]

- Open the Report Builder in the Lansweeper configuration console under Reports & Alerts.
- Hit the "New" button to create a new report.
- Paste the following code in the bottom left corner, replacing "YourString" with your requirement for the computer description:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Description
From tblComputers
Where tblComputers.Description Like '%YourString%'
Order By tblComputers.ComputerUnique

- Click Result to see the computers listed. You may also give the report a "View Name" and a "Report Name" and hit "Save" to save the report. You can then double-click on the report to see its results and export options, single-click and hit "Edit" to change the report code.