Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Merbecks
Engaged Sweeper II
Hello,
we use the lansweeper32 freeware version.
The report "WMI access denied" shows 356 items, but on the left you see "All systems: 227, not scanned 156".(Screenshot attached)

We deleted a lot of computers in the managment console - is it possible, that this wrong counts are the consequence of deleting?

Kind Regards,
Daniel Merbecks
2 REPLIES 2
Merbecks
Engaged Sweeper II
Hello,
thanks for the answer. I've tried it - and sorry, this seems not to work. I've found the error, why the count of never scanned os was rising the last 2 days - the user running lansweeper server had changed the password...

So would it be a good idea to wait until thuesday or so and than run the code

delete from tblerrors where computername in ('Name1', 'Name2', 'Name3', ...)
go


So i could delete them manual. Not the nice way but I think after that it would work, ...

Other idea: What if i use a statement like

delete from tlberrors where ErrorText Like 'Zugriff verweigert (Ausnahme von HRESULT:%'


If all computers would be scanned again, the "normal" errors would return again... by the way: What's the column-name for errortext?

Kind Regards,
Daniel Merbecks
Hemoco
Lansweeper Alumni
Could you try the following from the sql script console

delete from tblerrors where computername not in (select computername from tblcomputers)

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now