View the Docs service audit report

These steps require that you have Microsoft SQL Server and permissions to access it, and the Microsoft SQL Server Reporting Services are available. For more information, see your SQL Server documentation or contact your SQL Server administrator.
  • Make sure that the audit properties are enabled. For instructions, see Configure audit properties.
  • Your environment has a Microsoft SQL Server and you have permissions to access it.
  • The Microsoft SQL Server has the Microsoft SQL Server Reporting Services available.
  1. With SQL Server administrator permissions, in a browser, open Microsoft SQL Server Reporting Services. By default, the web address is http://<SQL Server hostname>/reports
  2. Start the Report Builder.
  3. Create a new report.
  4. Create a data source connection. Specify the following fields:
    • Name field: Enter a descriptive name for the report (for example, docs_audit_report_date)
    • Select Connection type drop-down: Select Microsoft SQL Server.
    • Connection string field: If required, enter a string that points to the Docs DB FSBAudit table.
  5. Design the query. Specify the following settings:
    • Database view column: under Tables, select FSBAudit and AuditActionType.
    • Select fields section: make a relationship between the two tables. Click ActionName > AutoDetect.
    • Arrange fields screen: arrange the fields to group the data and values to how you want them to display. For example, if you create a report that is based on the username, you would specify the following:
      • Available fields column: select ActionPath.
      • Row groups column: select Username to display the username that completes the action in the report.
      • Values column: specify the values to display in the table (for example, action time, action type, and action path).
        • ActionTime provides information for when the action occurred.
        • ActionType details the action (for example, accessing or downloading a file).
        • ActionPath provides the path to the file for which the action was completed.
  6. Save the settings and run the report. The report is saved to the Microsoft SQL Server Reporting Services.
  7. Double-click the report that you want to view.