Re-queuing a devices

Owned by Glen Epperson (Unlicensed)
May 11, 2016

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

Filter by label

There are no items with the selected labels at this time.