Step-by-step guide

Add the steps involved:

  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)

 

 

 

 

 

You may also want to use visual panels to communicate related information, tips or things users need to be aware of.

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.


Related issues