Versions Compared

Key

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

...

Warning

These queries work with iQSonar releases up to and including Fu R3.Some of them do NOT work with iQSonar Gwynn R1 or later due to changes to the history.t_ConnectionHistory table

Changes were made to some underlying tables in Gwynn R1 and Gwynn R2 to reduce the amount of history saved as the diagnostic information can grow. In the Gwynn R3 release the option to preserve or delete this diagnostic can be selected in the user interface. Instructions on how to keep the history data can be found on this page.


Panel
bgColor#fff
  1. One Line troubleshooting scripts
  2. Get list of Project IDs (required for many queries)
  3. List all Found Devices
  4. Use SQL to send a target for a rescan
  5. Find unreachable targets
  6. Summary of connection attempt results
  7. Connection Results for specific target
  8. Find hosts with SSH Login failures
  9. Find hosts with Windows login failures
  10. Find ESX hosts that were not scanned
  11. Find hosts that could not be scanned for other reasons.
  12. Database Credential Issues
  13. All credential issues
  14. List all discovered databases (scanned and unscanned)
  15. List all commands performed during a scan
  16. Some targets seem stuck in "Waiting"

...