Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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)

 

 

 

 

 

  • No labels