Database connection and report defaults

Use the Investigative Reports > Options page to connect to the desired Log Database, and to control defaults for investigative reports detail view.

Changes made to this page affect your reports. Other administrators, or even users logging on for self-reporting, can change these values for their own reporting activities.

Steps

  1. Choose the Log Database to use for investigative reports.
    • Mark View the catalog database to connect to the Log Database to which Log Server is currently logging. Proceed to step 2.
    • To access a different Log Database, deselect View the catalog database, then enter the following information:
      Field Description
      Server

      Enter the machine name or IP address where the Log Database is located.

      If your environment uses SQL Server clustering, enter the virtual IP address for the cluster
      Database Enter the name of the Log Database.
      User ID

      Enter the user ID for an account that has permission to access the database.

      Leave this blank if Log Server is configured to use a trusted connection to access the Log Database.
      Password Enter the password for the specified account. Leave this blank for a trusted connection.
  2. Select the following defaults for detail reports.
    Field Description
    Select default Investigative Reports date range Choose the date range for the initial summary report display.
    Select the default detail report format

    Choose Smart columns selection to display detail reports with the default columns set for the information being reported.

    Choose Custom columns selection to specify the exact columns for initial display on all detail reports. Use the Available Columns list to make your selections.

    Users can modify the columns displayed after generating the report.
    Select report type

    Choose whether to open detail reports initially showing:

    • Detail: each record appears on a separate row; time can be displayed.
    • Summary: combines into a single entry all records that share a common element. The specific element varies, according to the information reported. Typically, the right-most column before the measure shows the summarized element. Time cannot be displayed.
    Available Columns / Current Report

    Select a column name in the Available Columns list and click the appropriate arrow to move it to the Current Report list. Up to 7 columns can be on the Current Report list.

    After the Current Report list contains all the columns for initial detail reports, set the order of the columns. Select an entry in the list, and use the up and down arrow buttons to change its position.
  3. Click Save Options to immediately save all changes.