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

We have about 10000 items in lansweeper and we are using dedicated sql server (not express) for lansweeper, but license report takes about 10min to load (Select Licenses tab -> Click License report button). In license report there is 73 items.

Is there anything I can do to make license report query quicker?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
In order to solve performance issues we generally recommend following the steps in this KB article. This will clear old event logs and shrink the database. It should also have an influence on the license compliance report.

If this doesn't solve the issue, could you write a mail to support@lansweeper.com and we will follow up via mail. Could you attach screenshots of the Configuration\Database scripts page, section Database Table Size, so we can have a look at your database size.

View solution in original post

2 REPLIES 2
toomasy
Engaged Sweeper II
Thank you, that KB article helped. 🙂
Daniel_B
Lansweeper Alumni
In order to solve performance issues we generally recommend following the steps in this KB article. This will clear old event logs and shrink the database. It should also have an influence on the license compliance report.

If this doesn't solve the issue, could you write a mail to support@lansweeper.com and we will follow up via mail. Could you attach screenshots of the Configuration\Database scripts page, section Database Table Size, so we can have a look at your database size.