→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ElDab67
Engaged Sweeper III
Looking through the reports I don't see one that will list everything captured in Lansweeper. Is there a report that will display all assets with their installed software etc?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
To create a basic report that lists all (active) assets, open the report builder under Reports\Create New Report, give the default report that is generated a title and hit Save & Run. For software, there are some built-in reports in the Reports tab.

Lansweeper uses a SQL database and a standard SQL editor for its report building. It's not possible to list everything in the database in a single report. The database contains dozens of unrelated database tables. Including all of these tables in a single report would lead to endless rows of duplicates, due to the way SQL works.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
To create a basic report that lists all (active) assets, open the report builder under Reports\Create New Report, give the default report that is generated a title and hit Save & Run. For software, there are some built-in reports in the Reports tab.

Lansweeper uses a SQL database and a standard SQL editor for its report building. It's not possible to list everything in the database in a single report. The database contains dozens of unrelated database tables. Including all of these tables in a single report would lead to endless rows of duplicates, due to the way SQL works.