Rescan all previously unscanned Unix/Linux Devices

Owned by Conor McCann
Last updated: Nov 03, 2017
1 min read

Step-by-step guide

  1. Open iQsonar Database from using SQLSERVER
  2. Open new query
  3. Run the following SQL command

 

 

update FoundDeviceScanHistory set AttemptCount=0,nextscandate=getdate() where founddeviceid in(

select fd.FoundDeviceID from founddevice fd

join founddeviceport fdp on fdp.FoundDeviceID = fd.FoundDeviceID

and fdp.Port = 22

where fd.deviceid is null)

 

delete FoundDevicecredentialHistory where founddeviceid in(

select fd.FoundDeviceID from founddevice fd

join founddeviceport fdp on fdp.FoundDeviceID = fd.FoundDeviceID

and fdp.Port = 22

where fd.deviceid is null)