Step-by-step guide
- Open iQsonar Database from using SQLSERVER
- Open new query
- 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)
...
Related articles
Filter by label (Content by label) |
---|
showLabels | false |
---|
max | 5 |
---|
spaces | CSKB |
---|
showSpace | false |
---|
sort | modified |
---|
reverse | true |
---|
type | page |
---|
cql | label in ("sql","v3","database","windows") and type = "page" and space = "CSKB" |
---|
labels | Windows V3 SQL Database |
---|
|