Configure the Microsoft SMS/SCCM settings

Any user with Administrator or Local Administrator account permissions can perform SCCM updates.

When you use SCCM to run WHD asset recovery, use an SQL-authenticated account to connect to the SCCM database. The minimum account requirement is Read and Write privileges. If you use a domain-authenticated account, you may receive an error because WHD does not support a mixed mode/domain account to log in to the SQL database server.

1. Set up your Microsoft Systems Management Server (SMS) or System Center Configuration Manager (SCCM) server to allow Web Help Desk to collect asset data from the server.

   See the Microsoft Docs website for details about setting up SMS and SCCM.

2. Log in to WHD as an administrator.
3. Click Setup > Assets > Discovery Connections.
4. In the Discovery Connections screen, click New.

5. In the Connection Name field, enter a name for this connection.

6. From the Discovery Tool drop-down menu, select Microsoft SMS/SCCM.

   The screen expands to include new field options.

7. Enter the target database information.

   1. In the SCCM SQL Server Database Host field, enter the host name or IP address of the database server hosting the targeted database instance.

   2. In the Database Name field, enter the name of the database containing the asset table or view.

   3. In the Username field, enter the user name of the database account used to access the asset information table(s).

   4. In the Password field, enter the password of the database account used to access the asset information tables.

   5. In the Auto-Sync Schedule area, select a synchronization schedule that determines how often Web Help Desk collects properties from the discovered endpoints. To disable automatic synchronization, select Every but do not select a day of the week.

8. If you want to ignore blank values encountered, select the Ignore Blank Discovered Values checkbox.

9. Select the Sync with Existing Assets Only checkbox if:

   • Assets found in the discovery connection will be synchronized with existing assets in the Web Help Desk database
     or
   • Assets not in the Web Help Desk database will be added.

   The default selection is enabled.

10. On the Client Relationships line, select an action when the discovery tool locates a new client association that is different from what is stored in the Web Help Desk database.

    • Select Add Clients to add new client associations.

    • Select Replace Clients to replace all existing client associations for the Web Help Desk asset.

    • Select Ignore Clients to do nothing.

11. In the When Assets Are Removed section, select an action to take if an asset currently in the Web Help Desk database is not found by the discovery tool.

    • Select Delete Asset to delete the asset from the database.

    • Select No Action to leave the asset in the database.

    • Select Set Status To if you want to leave the asset in the database but set its status to another value.

12. Click Save.
13. Click Assets > Search Assets.

14. In the Search Assets window, create a basic or advanced search query to view your imported assets.

15. Click Search to view your imported assets.