→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
d_i_saunders
Engaged Sweeper III
Hi all,

we have a shared OU, and only want to scan workstations under our control. all Workstations we manage have a prefix..

At the moment we get access denied on the other workstations, and a query runs on the database to clean them up..

DELETE
FROM lansweeperdb.dbo.tblcomputers
WHERE (Computer NOT LIKE 'UK%')


When this runs does it remove it from the scanning queue?

Would it be better to filter at the Scanning queue? eg the workstations would never be scanned as they would be deleted out before they had time to be acctioned..

Aslo the AD query happenes evey 15mins.. Each query, does it only get the last 15mins? or is there a max number, eg 500 workstations that are returned at any time?

regards

2 REPLIES 2
d_i_saunders
Engaged Sweeper III
Thanks for the reply.
Dc in our Market still hold information on all pc that have logged on.
All ous are shared for us.

Seems in stuck with it.
Hemoco
Lansweeper Alumni
When this runs does it remove it from the scanning queue?

No

Would it be better to filter at the Scanning queue? eg the workstations would never be scanned as they would be deleted out before they had time to be actioned..

Yes, but you can only filter based on OU.

Aslo the AD query happenes evey 15mins.. Each query, does it only get the last 15mins? or is there a max number, eg 500 workstations that are returned at any time?

Only machines logged on in the last 15 minutes are returned, no limit. (maybe you can use site filtering to only query DC's in your site?