Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Archive > 2017October31 - LEM Deletes > Configuring report preferences

Configuring report preferences

Created by Caroline Juszczak, last modified by Kevin.Swinson on Oct 31, 2017

Views: 38 Votes: 0 Revisions: 7

Use the Configure drop-down menu in the Preferences group to link the Reports console to a data source (such as a manager) to generate your reports. You can select a primary data source, syslog server, or data warehouse.

The following table briefly describes each option in the Preferences group.

Preference / Option Description

Configure

Primary Data Source

Provides the default data source to run reports when you open the Reports console. This option becomes the default setting the Data Source drop-down menu.

Syslog Server

Enables your selected manager to send report log information to a syslog server. This 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.

Managers - Credentials and Certificates

Enables the Reports console to communicate with the LEM database server. You can use the Reports credentials to provide secure reporting, audit users accessing the server running on the LEM appliance, enable third-party authentication servers (such as Active Directory) for LEM reporting, and set up roles for user access to prevent unauthorized users from accessing the Reports server.

Your selected manager name or IP address appears in and above the Reports Data Sources drop-down menu.

Data Source

Data Source

Selects the targeted data source to run reports. When you select a data source in the drop-down menu, the data source temporarily overrides the Primary Data Source (default) you selected as the primary data source in the Configure drop-down menu.

Select a default primary data source

You can select your primary data source connection for running reports whenever you open the Reports console. The connection settings displays as the default setting in the Data Source drop-down menu.

You can select a different data source when you open the console. When you close and then reopen the console, the setting defaults to the primary data source.

  1. Open the Reports console.
  2. In the Settings tab, click Configure and select Primary Data Source.

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

    File:Success_Center/Reusable_content_-_InfoDev/LEMUserGuide_MT/0C0/040/PrimaryDataSource.png

  4. Click Test Connection to verify your connection to the data source.

    If the test succeeds, Ping Test success displays in the dialog box. If the test fails, an error message displays. See Troubleshoot database connections.

  5. Click OK.

    The default primary data source is configured.

Configure a syslog server

You can enable a 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 so it can communicate with the manager.

  1. Open the Reports console.
  2. In the Settings tab, click Configure and select Syslog Server. The Set Syslog Server form appears.

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

    File:Success_Center/Reusable_content_-_InfoDev/LEMUserGuide_MT/0C0/040/Prefs-SyslogServer.png

  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 if the host is a syslog server.

    If the ping test succeeds, The Ping Test succeeded displays in the dialog box with the host IP address.

    If the ping test fails, an error message displays. Verify that you entered a host name that matches a valid DNS entry and click Test.

  5. Click OK.

    The syslog server is configured.

Configure Managers - Credentials and Certificates

You can enable the Reports console to communicate with the LEM database server. Use the Reports credentials to provide secure reporting, audit users accessing the server running on the LEM appliance, enable third-party authentication servers (such as Active Directory) for LEM reporting, and set up roles for user access to prevent unauthorized users from accessing the Reports server.

  1. Open Reports.
  2. In the Settings tab, click Configure and select Manager - Credentials and Certificates.
  3. Complete the fields as required.

    File:Success_Center/Reusable_content_-_InfoDev/LEMUserGuide_MT/0C0/040/lem-ug-manager-configuration_339x228.png

  4. Click Test Connection to verify the connection.
  5. Click OK.

    The Reports console is connected to the LEM database server.

Troubleshoot Database Connections

Use the following table to troubleshoot error messages that may occur with the ping test used to test the connection between Reports and the data warehouse or the primary data source.

Error message Description Correction

Manager ping
timed out.

Reports was unable to connect to the manager host name or IP address. Confirm the host name (or IP address) you entered is correct.

Confirm that you entered the warehouse host name properly and it matches a valid DNS entry. Try entering the warehouse IP address in the Host Name field.

Sending the authentication packet failed. Could not flush socket buffer.

Reports could resolve and connect to the IP address, but could not authenticate to the database server at that location.

Confirm that the host name (or IP address) is correct and allows connections from the location where you are running the Reports console.

This error may also require you to modify the report restrictions.

Server ping test successful, but database connection test failed.

Login incorrect.

Login failed for user [user name].

Reports could resolve, connect to the IP address, and connect to SQL Server, but could not log in using the reports user credentials.

Confirm that the host name (or IP address) you specified contains the SolarWinds database.

The warehouse may require a password for reporting purposes. In this case, click Security and enter the warehouse reporting password.

Last modified

Tags

Classifications

Public