Rescan all previously unscanned Windows Devices

Owned by Conor McCann
Last updated: May 15, 2018
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 in (135,3389)
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 in (135,3389)
where fd.deviceid is null)