Security Compliance

Reinstalling the SEM Reports Console

This article describes how to reinstall the SEM Reports Console and Crystal Reports Runtime.

First published date

10/16/2018 6:32 PM

Last published date

10/16/2018 6:32 PM

Overview

This article describes how to reinstall the Security Event Manager (formerly Log & Event Manager) Reports Console and Crystal Reports Runtime.

Product section

Security Event Manager

Resolution

  1. Save any Custom Reports you have in C:\Program Files (x86)\SolarWinds Security Event Manager Reports\CustomReports

  2. Save any Scheduled Reports you have in C:\Program Files (x86)\SolarWinds Security Event Manager Reports\schedINI
    Note: You will be able to re-import the custom reports you have only if you import them into the same SEM Reports version.  You may need to re-create the scheduled tasks after a re-install of the Reports Console.

  3. Uninstall SEM Reports and Crystal Reports from the client.

    Note: If you installed Crystal Reports for use with the SEM Reports Console, also delete any of the following folders:
    • PROGRAMFILES\Common Files\Business Objects
    • PROGRAMFILES32\Common Files\Business Objects
    • PROGRAMFILES64\Common Files\Business Objects
    • PROGRAMFILES\Common Files\SAP BusinessObjects
    • PROGRAMFILES32\Common Files\SAP BusinessObjects
    • PROGRAMFILES64\Common Files\SAP BusinessObjects

  4. Right-click the icon and select Run as administrator to reinstall the Reports Console and Crystal Reports Runtime.
    Note: Install the same version of SEM Reports as the version of your SEM Appliance.
    Appliance Reports.

    NOTE: SEM Reports version 6.4 is the latest version and also works with SEM 6.5 through 2019.4.

  5. Copy and paste your saved Custom Reports in C:\Program Files (x86)\SolarWinds Security Event Manager Reports\CustomReports

  6. Configure SEM Reports to be launched as an administrator:
    a. Right-click the Reports icon and select Properties.
    b. Go to the Compatibility tab.
    c. Select the Run this program as an administrator box and click OK.

  7.  Create a service account user for the Reports software by going into the SEM Web Console -> Go to Build -> Users -> Click on the + in the upper right and select SEM user  

  8. Call the user reports, then change the Role to Reports (have to scroll to very bottom under Roles), this allows this user only authentication to the reports console software.  It also resolves password changes, its like a Windows Service Account.

  9. Then just give it password like = Password1 or whatever your companies password compliance is.

  10. Then go back to the Report Console Software click on the Configure gear at the Top and go to Managers - Credentials and Certificates.

  11. Make sure the Manager Name is the IP Address for the SEM and not the hostname.

  12. Then for the username and password which should be just reports for the username and password = Password1

  13. Then click on the Green (+) sign to save the configuration and then click Close.

  14. Try Running the Agent Status report for like 5 minutes just to see if it works, if not please proceed to step#14

  15. Unrestrict the access to SEM Reports if necessary.
    a. Connect to your SolarWinds appliance(s) using an SSH client of VMware console connection. If using SSH, connect on port 32022. Log in with your cmc account.
    b. Type service and press Enter to enter the Manager sub-menu.
    c. Type unrestrictreports and press Enter.

  16. Verify that you have port 9001 open between the client where you just installed SEM Reports and your SEM appliance.