Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Log & Event Manager (LEM) > LEM Administrator's Guide > Create a custom LEM report

Create a custom LEM report

Updated: September 15, 2017

This topic describes how to customize a LEM report.

Click the video File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1330-Troubleshoot_alerts_in_the_LEM_console/button_videocamera_18x12.png icon to view a tutorial about filtering and exporting LEM Reports.

Create a custom report in the LEM reports application

If you want to report about a specific event (such as a user logon failure), you can create a custom report that reports on a specific field. Using the left menu in the reports application to select the field for your report.

  1. Run a report. See Run an on-demand report in the LEM reports application for help.

    The report opens on the View tab.

  2. In the left column of the report, select the field you want to query.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1070-Create_a_custom_LEM_report/lem_qsg_run_schedule_reports12.png

  3. On the View tab, examine the report to identify the value you want to use in your filter.

    Hover over any value in the report to view a tooltip that contains its complete field name as it is used in Select Expert.

  4. Click Select Expert.

    The Select Expert dialog box opens.

    The Select Expert tool filters the report to show only the type of data that you want to see in your custom report. See Use the Select Expert tool to create a more focused LEM report for more information.

  5. Click New.

    The Fields dialog box opens.

  6. Select a field to report on, and then click OK.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1070-Create_a_custom_LEM_report/lem_qsg_run_schedule_reports13.png

  7. Click the Boolean drop-down menu and select your comparison value.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1070-Create_a_custom_LEM_report/lem_qsg_run_schedule_reports15_362x134.png

  8. Select or enter a second value. Click New to select or enter additional fields and expand your query.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1070-Create_a_custom_LEM_report/lem_qsg_run_schedule_reports16_365x135.png

  9. Click OK.

    Select Expert filters out only the information in your query.

    All fields are listed as column labels across the top. You can also mouse over data to display the reported field.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1070-Create_a_custom_LEM_report/lem_qsg_run_schedule_reports17_487x267.png

  10. Click Print to print your report.

    Click Export to export your report to a PDF, Word Document, or other format.

Export and save a copy of the filtered LEM report with a new name

  1. Create and run the custom report. See Create a custom report in the LEM reports application for help.

  2. On the View tab, click Export.

    The Export dialog box opens.

  3. Select Crystal Reports (RPT) from the Format menu.

    Leave Destination set to Disk file, and then click OK.

  4. In the Save File window, navigate to the following folder:

    C:\Program Files (x86)\SolarWinds Log and Event Manager Reports\CustomReports

    This is the default location for 64-bit operating systems. If you are using a 32-bit operating system, the default folder would be C:\Program Files\SolarWinds Log and Event Manager Reports\CustomReports.

  5. In the File name field, type a name for your filtered report to identify the report by the file name under Custom Reports

  6. Click Save.

Open a custom report in the LEM reports application

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

  2. In the Reports window, click the Settings tab.

  3. In the Category list, select Custom Reports.

  4. On the Quick Access toolbar, click the Refresh Report List icon or press F5.

    When the refresh completes, the new custom report appears in the list, and displays any changes made to its Properties.

  5. Launch your custom report for any time frame.

Last modified

Tags

Classifications

Public