Versions Compared

Version Old Version 15 New Version 16
Changes made by

Former user

Former user

Saved on

Key

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

...

You will need to have access to the Microsoft SQL Server Management Studio software. The current version (at time of writing version 17) is a free-of-charge download from Microsoft.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

You need to understand how to edit the SQL queries. Most of them contain placeholder values for ProjectID, Date(s) and/or IP Addresses which will need to be updated to work in your specific environment. If you do not update these values, the queries will not run, or will return meaningless results.

Troubleshooting Queries

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. Database Credential Issues
  11. All credential issues
  12. List all discovered databases (scanned and unscanned)

...