Windows Server Update Services connector

TeamViewer DEX Platform 26.3 Red x | 1E Platform 23.11 Green checkmark | 1E Platform on-premises 9.x Green checkmark

The Windows Server Update Services connector connects to a WSUS database and pulls patch data.

Prerequisites

Before adding this connector, you will need the following:

  • An SQL login for the WSUS database if not using Network Service (computer$).

This connector only supports WSUS that has been configured to use an external SQL database via TCP/IP protocol. Named Pipes protocol is not supported, as required by internal MSSQL$MICROSOFT##WID database instance.

Adding the connector

  1. Navigate to Settings > Configuration > Connectors.

  2. Click Add.

  1. In the Add Connector pop-up window, select Windows Server Update Services as the connector type.

  2. In Connector name, enter a logical name for this connector.

    Use a naming convention for connector names, for example, <connector type> <scope> <RCR>. Scope describes where data is coming from or what it's being used for, for example, Demo, Test, Lab, Q2 Audit. Include RCR in the name if the Run Consolidation Reports option is available and you have enabled it.

  3. In WSUS Database Server, enter the name of the SQL Server instance where the Configuration Manager database is hosted using one of the following formats:

    • <Server Name>

    • <Server Name>\<Instance> (For a named instance.)

    • <Server Name>\<Instance>,Port (For a custom port.)

  4. In WSUS Database, enter the name of the database you want to connect to.

  5. If you are authenticating with Windows, note the following:

    1. Ensure the Use Windows Authentication checkbox is selected.

    2. You do not need to populate the WSUS SQL Server User and WSUS SQL Server Password fields.

    If you are using an SQL account, note the following:

    1. Ensure the Use Windows Authentication checkbox is not selected.

    2. In WSUS SQL Server User, enter the name for the account you want to use to connect to the database.

    3. In WSUS SQL Server Password, enter the password associated with this account.

  6. Select the Run Consolidation Reports checkbox if you want consolidation actions to be processed each time the Sync Data action is executed for the connector.

    If you enable this on more than one connector, it can lead to unnecessary processing. The recommended method of processing consolidation actions is to schedule the action Generate Report - Basic Inventory Consolidation to execute after the Sync Data actions have run for all connectors. This will execute the remaining consolidation actions. Alternatively, select the Run Consolidation Reports checkbox on one of your connectors. You can view action processes in Settings > Process log.

  7. Click Add.

    For information on how to test or delete a connector, and how to sync data into a repository, refer to Connectors page.