Re-queuing a devices
Problem
To target individual or subsets of devices / applications for rescanning, the “outofscope” flag can be set. Every founddevice, device, foundapplication and application has an outofscope flag. By default this value is set to null or 0 which flags that this founddevice, device, foundapplication or application can Scanned / rescanned. Setting this value to 1 will remove this founddevice, device, foundapplication or application from being active and no scanning services will attempt to connect to it. This flag is extremely useful when troubleshooting as it allows for a target or targets to be focused on.
Solution
To set a founddevice, device, foundapplication or application outofscope use the SQL below, the where clause will allow for narrowing down the target list:
| UPDATE [FoundDevice] SET OutOfScope=1 WHERE... |
| UPDATE [Device] SET OutOfScope=1 WHERE ... |
| UPDATE [FoundApplication] SET OutOfScope=1 WHERE ... |
| UPDATE [Application] SET OutOfScope=1 WHERE ... |
Targets can be rescanned by setting the next scan date in the scan history tables use the where clause to narrow down the target list:
| UPDATE DeviceScanHistory SET NextScanDate='2011-06-20 10:00:00' WHERE ... |
| UPDATE FoundDeviceScanHistory SET NextScanDate='2011-06-20 10:00:00' WHERE ... |
| UPDATE ApplicationScanHistory SET NextScanDate='2011-06-20 10:00:00' WHERE ... |
| UPDATE FoundApplicationScanHistory SET NextScanDate='2011-06-20 10:00:00' WHERE ... |
The stored procedures can also be used to rescan all devices or applications:
| EXEC RescanAll |
| EXEC RescanAllDevice |
| EXEC RescanAllApplication |
Related articles