Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2011 12:51 PM
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.
I have not created any new reports before so I'm somewhat unskilled.
Any help would be appreciated.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2011 05:13 PM
- 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:
- 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.
- 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.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2011 06:13 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2011 05:13 PM
- 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:
- 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.
- 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.
