Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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)

 

...



 

 
Info



Filter by label (Content by label)
showLabelsfalse
max5
spacesCSKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("sql","v3","database","windows") and type = "page" and space = "CSKB"
labelsWindows V3 SQL Database

Page Properties
hiddentrue


Related issues