Setting up the SEM reports application

Complete the steps in this section after you install the reports application.

See Install the SEM reports application in the SEM Installation Guide if you have not yet installed the reports application.

Configure the SEM reports application to communicate with the SEM database

SolarWinds recommends that you create a special service account for use with the SEM reports application. See Create a local SEM user account for instructions and specify Reports in the SEM Role field. The Administrator and Auditor roles can also use the SEM reports application.

  1. Open the SEM reports application. See Open the SEM reports application for steps.

    • Launch Reports as an administrator the first time you run the application. Depending on your Windows security set up, you may always need to run reports using the Run as administrator option. See Setting up the SEM reports application for help.
    • The first time you open Reports, a pop-up window displays the message A manager list was not found. Please create a list containing at least one manager. This is not an error. Click OK to close the pop-up window.

  2. On the Settings tab, click the Configure button (the button with a gear icon).

  3. Choose Managers - Credentials and Certificates.

  4. Complete the fields as required.

    1. Manager name – Enter the IP address of the SEM Manager.

    2. User name – Enter the service account user you created to log in to the SEM reports application.

    3. Enter the password for the service account user.

    4. Select the green + button to save the credentials.

    5. Close the window.

  5. Click Test Connection to verify the connection.

    See Troubleshoot the SEM reports application database connection if the connection failed.

  6. Click OK.

    The reports application is connected to the SEM database server.

Secure the SEM reports application

To secure the SEM reports application, see the following topics in the "Securing SEM" section of the SEM Administrator Guide:

Select a default primary data source

Select the primary data source connection for running reports when you open the SEM reports application. The connection settings display as the default setting in the Data Source drop-down menu.

You can select a different data source when you open the SEM reports application. The next time you open the application, the setting defaults to the primary data source.

  1. Open the SEM reports application. See Open the SEM reports application for steps.

  2. On the Settings tab, click Configure, and then select Primary Data Source.

  3. In the Primary Data Source list, select the default data source.

  4. To verify your connection to the data source, click Test Connection.

    If the test succeeds, Ping Test success appears in the dialog box. If the test fails, an error message appears. See Troubleshoot the SEM reports application database connection.

  5. Click OK.

    The default primary data source is configured.

Configure a syslog server (optional)

You can enable a SEM Manager to send report log information to a syslog server to record all report-related events and application messages. The server logs basic report activity, such as the user name, report type, targeted database, report time, and any error messages that occur while generating the report.

The syslog server is set to the Primary Manager by default, but can be set to any server running a standard syslog service. The server must have an Agent installed to communicate with the SEM Manager.

  1. Open the SEM reports application. See Open the SEM reports application for steps.

  2. On the Settings tab, click Configure, and then select Syslog Server.

    The Set Syslog Server form appears.

  3. In the Syslog Server (Host Name) box, enter the server host name.

  4. Click Test.

    The system tests the connection.

    You must test the connection before the server can be accepted. A successful test does not confirm that the host is a syslog server.

    • If the ping test succeeds, The Ping Test succeeded notification appears in the dialog box with the host IP address.
    • If the ping test fails, an error message appears. Verify that you entered a host name that matches a valid DNS entry, and then click Test.
  5. Click OK.

    The syslog server is configured.