cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DanielB
Engaged Sweeper
Hi,

I need a report like the "Software: All installed software" but only for a special domain.
Already searched the forum but only found a report for a ip-range.


hope you can help me

thx
Daniel
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
You can modify the "Software: All installed software" report:
  • Open the report in the Reports tab.
  • Hit Edit Report on the left.
  • Hit Save As to save a copy of the report under a different name.
  • In the visual representation of the report in the upper section of the report builder, tick the Domain field in the tblAssets database table. You will see an error at this point, which can be ignored.
  • Tick the Grouping checkbox for the tblAssets.Domain expression in the expression list.
  • Hit Save & Run.
  • Optionally, filter the domain name within the report results to only see a specific domain.

If you are interested in building or modifying reports, we do 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.
  • Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
You can modify the "Software: All installed software" report:
  • Open the report in the Reports tab.
  • Hit Edit Report on the left.
  • Hit Save As to save a copy of the report under a different name.
  • In the visual representation of the report in the upper section of the report builder, tick the Domain field in the tblAssets database table. You will see an error at this point, which can be ignored.
  • Tick the Grouping checkbox for the tblAssets.Domain expression in the expression list.
  • Hit Save & Run.
  • Optionally, filter the domain name within the report results to only see a specific domain.

If you are interested in building or modifying reports, we do 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.
  • Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.