Set up the LEM reports application

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

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

Configure the LEM reports application to communicate with the LEM database

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

  1. Open the LEM reports application. See Open the LEM 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 Set up the LEM 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 LEM Manager.

    2. User name – Enter the service account user you created to log in to the LEM 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 LEM reports application database connection if the connection failed.

  6. Click OK.

    The reports application is connected to the LEM database server.

Secure the LEM reports application

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

Select a default primary data source

Select the primary data source connection for running reports when you open the LEM 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 LEM reports application. The next time you open the application, the setting defaults to the primary data source.

  1. Open the LEM reports application. See Open the LEM 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 LEM reports application database connection.

  5. Click OK.

    The default primary data source is configured.

Configure a syslog server (optional)

You can enable a LEM 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 LEM Manager.

  1. Open the LEM reports application. See Open the LEM 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.