Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry Enterprise Mobility Server 3.7
  3. Monitoring and reporting
  4. Using BEMS log files
  5. BlackBerry Docs log files
  6. View the Docs service audit report

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.