→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
King19501
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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:
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.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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:
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.