cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
isol
Engaged Sweeper

I upgraded LanSweeper to a new ver 4. Yesterday I had 300 computers nicely scanned. Opened LanSweeper today and it shows 200 scanned and 100 unscanned. Could you please tell me why?
Thanks
14 REPLIES 14
Hemoco
Lansweeper Alumni
From the database scripts page run "delete from tblntlogevent"
isol
Engaged Sweeper
How do i clear table tblntlogevent?
Hemoco
Lansweeper Alumni
I would suggest to clear table tblntlogevent and set eventlog scanning waittime to -1
isol
Engaged Sweeper
see attached please.
isol
Engaged Sweeper
I just did and it is sitll at 4 Gig
Hemoco
Lansweeper Alumni
isol wrote:
I just did and it is sitll at 4 Gig

Could you please use this script (or a similar script) to find out the size of your tables please.

http://www.sqlteam.com/article/finding-the-biggest-tables-in-a-database

400 computers should be around 1GB Maximum.

Hemoco
Lansweeper Alumni
Could you check how big the database files are?

I suggest:
Make sure your disk is not full
Stopping the service
Set the database recovery mode to "simple"
Shrink the database
Shrink the files
Start the service.
isol
Engaged Sweeper
how could it be full i have only 400 or so computers in it. How can i clean it up?
Hemoco
Lansweeper Alumni
Could not allocate space for object 'dbo.tblUsersInGrouphist'.'PK_tblUsersInGrouphist' in database 'lansweeperdb' because the 'PRIMARY' filegroup is full


Looks like your database if full.