Auditor Help: Selecting for MS-SQL

  1. Use the > button to select the database instance(s) you would like to document.
    Helpful Hint Tip: The Discover button prompts the software to attempt to auto-discover database instances in the environment.
    To specify a server, click New... (or click Edit... to modify credentials).
    Select items to collect
  2. Click OK.
  3. If prompted, click Yes to proceed with prompts for authentication (or click No to return to specify SQL authentication).
  4. Click on a plus sign to expand any area of the tree and click in a box to select an item for collection.

  5. Select database options to collect
  6. Enable or disable the checkbox to prevent collecting and reporting on the default databases installed with MS-SQL. Since these are generally sample databases, there may be no value to reporting them.
  7. Click to enable or disable collection of User and System objects.
  8. In Gather Databases drop-down, choose whether you want to select specific databases for collection or just to collect all databases.
  9. Click OK. If you've previously chosen to select specific databases, this will bring you to database selection screen.
  10. Click on a plus sign to expand any domain to see available databases for collection.
  11. Select any database you wish to collect in the left pane and click to select objects within that database in the right pane.
    Select database(s) to collect and report
  12. Click OK.
  13. Proceed with reporting.