cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kat
Engaged Sweeper II
I have some computers which seem to be stuck in the scanning queue. They actuaully appear in the queue multiple times. Apparently, they have either never been scanned or are not able to be scanned at the moment. Is there a way to get them out of the queue?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
FYI for everyone: the customer contacted us via email. Screenshots of Configuration/Scanning Setup/Database Scripts and the customer's error log indicated that the event log database tables were huge and locking up the Compact database. Clearing event log data resolved the issue.

If you have over 1,000 assets, it is recommended that you use SQL Server as your database server, not SQL Compact. Performance will be severely impacted if you try to host thousands of assets in a Compact database. Instructions for moving from SQL Compact to SQL Server can be found here.

View solution in original post

7 REPLIES 7
Susan_A
Lansweeper Alumni
FYI for everyone: the customer contacted us via email. Screenshots of Configuration/Scanning Setup/Database Scripts and the customer's error log indicated that the event log database tables were huge and locking up the Compact database. Clearing event log data resolved the issue.

If you have over 1,000 assets, it is recommended that you use SQL Server as your database server, not SQL Compact. Performance will be severely impacted if you try to host thousands of assets in a Compact database. Instructions for moving from SQL Compact to SQL Server can be found here.
kat
Engaged Sweeper II
I tried that on one of them and still have the issue with that computer. Yesterday, I upgraded again to the newest version and still have the same problem.

Hemoco
Lansweeper Alumni
Did you try repairing WMI on the affected computers?
kat
Engaged Sweeper II