
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-11-2015 04:00 PM
Im looking for e report that can list all software and its computer assets in a specified domain and after that I want the report to remove any specified software like adobe, Microsoft office etc
does any one now how to build such report
does any one now how to build such report
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 04:28 PM
To list software installed on computers in a specific domain, open the built-in "Software: List of software by computer" report in the Reports tab and filter the Domain column within the report results. If you want to exclude certain software packages, you will need to hit the Edit Report button to the left of the report results and add a list of software names to the Criteria column of the tblSoftwareUni.softwareName expression, like so:
If you are interested in building or modifying reports, we would recommend:
Not In ('software name 1','software name 2', 'software name 3')
If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
- Updating to Lansweeper 5.3, if you haven't already. Lansweeper 5.3 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2015 04:28 PM
To list software installed on computers in a specific domain, open the built-in "Software: List of software by computer" report in the Reports tab and filter the Domain column within the report results. If you want to exclude certain software packages, you will need to hit the Edit Report button to the left of the report results and add a list of software names to the Criteria column of the tblSoftwareUni.softwareName expression, like so:
If you are interested in building or modifying reports, we would recommend:
Not In ('software name 1','software name 2', 'software name 3')
If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
- Updating to Lansweeper 5.3, if you haven't already. Lansweeper 5.3 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.
