Skip Navigation

View the
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
  • 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
  1. With
    SQL Server
    administrator permissions, in a browser, open
    Microsoft SQL Server Reporting Services
    . By default, the web address is
    SQL Server hostname
  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_
    • 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
      • Row groups
        column: select
        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.