Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-10-2015 05:10 PM
I'm wanting to write a report that Includes only Asset's that contain comments. I'm logging any Asset changes (ie... HDD replacement, DVD Drive Replacement, O/S refresh etc...) into the comments section of each asset I work on. Thanks for your help!
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
‎09-12-2015 12:17 AM
- Open the report builder under Reports\Create New Report. A default query will be generated.
- Double-click on tblAssetComments in the table list on the right to add the table to your report.
- In the visual representation of the report in the upper section of the report builder, tick the Comment field in tblAssetComments.
- Give the report a title and hit Save & Run.
I would recommend familiarizing yourself with SQL and using the database dictionary. The Lansweeper report builder is a standard SQL editor. If you know SQL, you can easily build and modify Lansweeper reports as well.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2015 12:17 AM
- Open the report builder under Reports\Create New Report. A default query will be generated.
- Double-click on tblAssetComments in the table list on the right to add the table to your report.
- In the visual representation of the report in the upper section of the report builder, tick the Comment field in tblAssetComments.
- Give the report a title and hit Save & Run.
I would recommend familiarizing yourself with SQL and using the database dictionary. The Lansweeper report builder is a standard SQL editor. If you know SQL, you can easily build and modify Lansweeper reports as well.
