Integrations

Microsoft SCCM/MECM integration

Introduced in 2022.2

Updated in 2023.1

Integration with Microsoft SCCM/MECM is a pre-built workflow package that keeps your CMDB in sync with computers you manage in Microsoft System Center Configuration Manager (SCCM), recently known as Endpoint Configuration Manager (MECM). It regularly imports data about your organization's computers, laptops, and mobile phones from Microsoft SCCM/MECM and creates or updates Computer and Hardware records in Alloy Navigator. This article describes how to configure the integration and how to use it.

What does Microsoft SCCM/MECM integration include?

Integration with Microsoft SCCM/MECM includes these workflow items:

  • Integration > Microsoft SCCM: A set of workflow parameters for quick customization

  • Microsoft SCCM Integration #2912 : A workflow scheduled task that regularly imports computers and mobile phones from Microsoft SCCM/MECM to Alloy Navigator

  • Supporting workflow items and components required for the scheduled task to function

To enable the Microsoft Microsoft SCCM/MECM integration, you must first configure it as described below. Make sure that the prerequisites are met.

Prerequisites

To enable the Microsoft SCCM/MECM integration, the Automation Server computer must have one of the following PowerShell modules installed:

  • SqlServer module (recommended): This is an actively maintained module that supports the newest SQL Server features (SQL Server 2014 and later).

    You can install the SqlServer module from the PowerShell Gallery using this command:

    Install-Module SqlServer
  • SQLPS module (legacy): This is a deprecated module included with SQL Server 2012 and later, but it is no longer updated.

For best performance and compatibility, we recommend using the SqlServer module.

TIP: If you prefer to run the integration scheduled task without the Automation Server, from the command line, as described here, ensure that the computer where you run the task has one of these modules installed.

Configure Microsoft SCCM/MECM integration

To start using the integration, you must specify its workflow configuration. You will need to provide the credentials to access the SQL Server database that your Microsoft SCCM/MMECM uses to store the data.

To configure integration with Microsoft SCCM/MECM:

  1. In Alloy Navigator's web Admin Center or desktop Settings App , go to Workflow and Business Logic > Workflow Configuration > Integrations > Microsoft SCCM.

  2. Provide your credentials for access to your Microsoft SCCM/MECM database: SQL Server IP address, SQL Database Name, SQL Server Username, and SQL Server Password.

  3. Specify other details, including the types of devices you want to import, the policy on matching device owners to existing persons, and others.

    To learn about every configuration parameter, see its description.

  4. Click Save to apply your changes.

Test your Microsoft SCCM/MECM integration

We recommend that you first turn the Safe Mode on and test the integration in the safe mode, without creating any records. You will need your Admin Center or Settings App for this.

NOTE: In an on-prem environment, ensure that the Automation Server is running. You can verify its status in the Settings App by checking the Automation Server icon in the app's status bar. In a cloud environment, this step is not required.

  1. Under Workflow and Business Logic > Workflow Configuration > Integrations > Microsoft SCCM, turn the Safe Mode on.

    TIP: You may want to use the Safe Mode in conjunction with the Debug Logging Status when issues arise. Logs are available under Services > Scheduled Tasks > Logs in the Admin Center or Settings. The task name is Microsoft SCCM Integration.

  2. Go to Services > Scheduled Tasks > Tasks, select the Microsoft SCCM Integration task, and click Run on the Module menu.

    If the Run command is unavailable, make sure that the integration is enabled, SQL Sever database credentials are provided, and the Automation Server is set-up and running. You may need click Refresh to refresh the information.

  3. To verify whether the task would run as expected, double-click the task, go to the Sessions tab, and review the entry at the top. You can also view the log under Services > Scheduled Tasks > Logs.

Automate your Microsoft SCCM/MECM integration

If everything works as expected, you can automate and schedule your Microsoft SCCM/MECM integration by enabling the scheduled task. Before doing so, you may want to customize the default schedule.

To enable Microsoft SCCM/MECM integration:

  1. In your Admin Center or Settings, go to Services > Scheduled Tasks > Tasks.

  2. Open the Microsoft SCCM Integration task

  3. Review the default schedule and make any necessary changes.

  4. When ready, select the Enabled checkbox.