script to clear database

[Fred_Tran]

Hi,

I am running 3.5.2 (upgraded from previous version over the last couple of years). Something is wrong with the database because i have xp computers showing up as servers. I tried deleting all the computers in lsmanage and let it re-populate but eventually it will be corrupted again. I am looking for a script to clear EVERYTHING out without reinstalling.

It's probably better to wipe everything and start from scratch but this script will come handy.

Thanks

[Fred_Tran]

Domain DNS Name Domain NetbiosName
==================================
domain_b.local domain_b
domain_c.local domain_c
domain_d.local domain_d

Like I said, it's working since I took the initial domain domain_a.local out where lansweeper was installed on.

[Hemoco]

COuld you post the setup of your active scanning please.

[Fred_Tran]

None. Just the usual startup and stopping service in the log file.

[Hemoco]

Do you have any errors in the errorlog.txt file?

[Fred_Tran]

Hi,

I ended up re-installing from scratch.

I ran into a problem. It won't scan my main domain where the lansweeper computer is in. It does scan the other 3 domains correctly. Tried lstrigger a computer in that domain and got the same result.

The fix is NOT to put your initial installed domain in the scheduled scan and it will work. 😃

[Hemoco]

To delete all computers you can use "delete from tblcomputers"