Create a custom SEM report

This section describes how to customize a SEM report.

Click the video icon to view a tutorial about filtering and exporting SEM Reports.

Create a custom report in the SEM 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 SEM 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.

  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 SEM report for more information.

  5. Click New.

    The Fields dialog box opens.

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

  7. From the Boolean drop-down list, select your comparison value.

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

  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.

  10. To print your report, click Print.

  11. To export your report to a PDF, Word Document, or other format, click Export.

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

  1. Create and run the custom report. See Create a custom report in the SEM 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 Security 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 Security 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 SEM reports application

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