Documentation forPatch Manager

Set up the Patch Manager Web Console

If you installed Patch Manager in an Orion Platform deployment, enable and set up the Patch Manager Console in the Orion Web Console.

The Patch Manager Web Console allows you to view your Patch Manager data from within the Orion Web Console. You can access the console at My Dashboards > Patches > Patch Manager Summary.

The Patch Manager Web Console is included with your SolarWinds Installer. After you configure the Patch Manager settings in the Orion Platform Web Console, you can view your Patch Manager data and generate reports.

Using the SolarWinds Installer, you can install or upgrade multiple SolarWinds platform products on the Orion server. You can also install or upgrade scalability engines, including Additional Polling Engines, Additional Web Servers, and High Availability servers. See the Orion Platform Installation and Upgrade Guide for details about installing or upgrading Orion Platform products in a new or existing Orion Platform environment.

To configure the Patch Manager Web Console, perform the following procedures:

  1. Verify that the Orion server is running SolarWinds platform 2022.2.

    See the Orion Platform Installation and Upgrade Guide for details.

  2. Locate the server name or IP address and port of your Primary Application Server.

  3. Create or select a dedicated local administrator account in the Patch Manager Administrator Console.

  4. Configure the SQL Server settings for Web Reports.

  5. Restart the EminentWare Service.

  6. Log in to the Orion Web Console and access the Patch Manager settings.

  7. Set up the Web API settings so the Patch Manager Web Console can communicate with the Patch Manager Primary Application Server.

  8. Verify that you can access the Patch Manager Web Console.

  9. Configure the database settings for the Patch Manager reports. When you are finished, you can access the Patch Manager reports in the Orion Web Console. These reports provide details about your managed computers.

Create a dedicated local administrator account

This account will only be used to create a communications link between the Patch Manager application and the Patch Manager Web Console on the Orion server using the Web API.

  1. Create a local administrator user account with Windows credentials and a unique name.

    For example: 

    SPMWebAPIUser

    You can also select an unused local administrator account.
  2. Record the user name and password for a future procedure.

  3. Log in to the Patch Manager Console as an administrator.

  4. Add the user account to the EminentWare Users security role.

  5. In the navigation pane, expand Patch Manager System Configuration and select Security and User Management.

  6. Select the Security Roles tab.

  7. Select EminentWare Users.

  8. Verify that the dedicated local administrator account displays in the bottom center window pane.

Configure the SQL Server settings for Web Reports

Ensure that all Named Pipes and TCP/IP protocols are enabled in the Patch Manager SQL server configuration. Web Reports require these protocols enabled on the SQL Server instance where the EminentWare database is located.

See the SQL Server Configuration Manager documentation on the Microsoft technical documentation website for instructions on how to use the Configuration Manager.
  1. Open the SQL Server Configuration Manager.

  2. In the navigation menu, maximize SQL Server Network Configuration and select Protocols for SolarWinds Orion.

  3. Enable the following protocols:

    • Named Pipes - Allows multiple connections to the SQL database from different machines

    • TCP/IP - Allows a remote connection to the SQL database from a different machine

  4. Double-click TCP/IP.

  5. Click the IP Addresses tab.

  6. Under IPAII, verity that the TCP Port is set to 1433, and then click OK.

  7. In the navigation menu, select SQL Server Service.

  8. In the window pane, right-click SQL Server and select Restart.

Restart the EminentWare Service

  1. Log in to the Patch Manager server as an administrator.

  2. Open the Services application.

  3. Right-click EminentWare Data Grid Server and select Restart.

Access the Patch Manager settings in the Orion Web Console

  1. Log in to the Orion Web Console as an administrator.

  2. Click Settings > All Settings.

  3. Locate Product Specific Settings and click Patch Manager Settings.

Set up the Web API

Link the Patch Manager Web Console to the Patch Manager Primary Application Server Web API. This process establishes a communications link between the Patch Manager Web Console installed on the Orion server and the Patch Manager Primary Application Server.

  1. In the Patch Manager Settings window, click Web API Setup.

  2. Enter the server name or IP address of the Patch Manager Primary Application Server.

  3. Verify that the selected Primary Application Server port is open, configured, and listening.

    Open a command prompt and execute:

    netstat -aon | find "54092"

    where 54092 is the port for an unsecure HTTP connection to the Primary Application Server. If you plan to use a secure HTTPS port, enter 54093 for the port number.

  4. Create a connection from the Orion Platform Web Module to the Patch Manager Service.

    Enter 54092 to create an unencrypted HTTP connection.

    To create an encrypted connection using port 54093, select the Use HTTPS checkbox.

  5. Set up the Windows credentials for the Patch Manager server. This account will link the Patch Manager Web Console to the Patch Manager application on the Primary Application Server.

    1. Enter the name of the dedicated local administrator account you created in a previous section.

    2. Enter the account password.

    3. Click Test to verify the credentials.

      If the credentials are correct, Test succeeded displays.

  6. Click Submit.

Access the Patch Manager Web Console

After you set up the Web API, you can access the Patch Manager Web Console in the Orion Web Console at My Dashboards > Patches > Patch Summary.

This dashboard view may vary depending on your configuration.

Configure the database settings for the Patch Manager Web Reports

After you configure the database settings, you can generate reports in the Orion Web Console. These reports provide details about your managed computers.

  1. Click Settings > All Settings.

  2. Locate Product Specific Settings and click Patch Manager Settings.

  3. Click Web Console Database Setup.

  4. Enter the IP address of your Patch Manager SQL Server database.

  5. Enter the Windows or SQL server login credentials of a user in your organization with administrator access to the Patch Manager database. These credentials will be used to create a read-only user account to query the Patch Manager database and populate the reports.

    For example:

    SPMWebReportsDBUser

    To prevent unauthorized access to your Patch Manager database, avoid using sa or .\Administrator for your login credentials.
  6. (Optional) Select the Encrypt connections with SSL checkbox to encrypt the network traffic between the Orion server and the Patch Manager SQL database server using the SSL certificate on the SQL server.

    This option requires a provisioned SSL certificate on the SQL server. Forcing the SQL server to require encryption is not required.
  7. Click Connect to test the connection.

    If the credentials are valid, Connection succeeded displays in the window.

  8. Select the SQL Server account used by the Patch Manager database.

  9. Select or create a user account to access the Patch Manager database and populate the reports. This account will be read-access only.

    To use an existing Windows or Active Directory account, select Use an existing account and enter the account name and password. Record and save your account credentials in a safe place.

    To create a new SQL Server account, select Create a new account and enter a new account name and password. Record and save your account credentials in a safe place.

    To use the existing SQL Server account you entered in step 5, leave the current option selected.

  10. Click Submit.

Access the Patch Manager reports

After you configure the database settings, you can access the Patch Manager reports in the Orion Web Console.

  1. In the Orion Web Console toolbar, click Reports > All Reports.

  2. Click the Group By drop-down menu and select Product.

  3. Under Group By, select SPM Reports.

  4. Click a report in the window.