Microsoft SCCM/MECM
On this page
The Microsoft SCCM/MECM integration creates and updates Computer and Hardware Inventory Item records. It is the one supplied integration that reads a third-party database rather than an API: it queries your SCCM/MECM SQL Server database directly. For the Inventory Item records themselves, see Configuration Items.
The integration is supplied configuration, not product code. A new 2026.1 database created with the Default Workflow contains it as the scheduled task Microsoft SCCM Integration, with the parameters described on this page. An upgraded database need not contain them, and an administrator may have changed them. See Default Workflow Configuration.
The integration is not limited to on-premises installations. In Alloy Navigator Cloud, whether the task can reach your SCCM/MECM SQL Server is a question of network connectivity. See Administering Alloy Navigator Cloud.
Prerequisites
- On the Automation Server host, a PowerShell module that provides the
Invoke-Sqlcmdcommand:SqlServer,SQLPS, ordbatools. The task looks for them in that order, and stops with a message naming all three when none is found. The module is needed on the Automation Server host, not on the database server.
Integration settings
The integration has four connection parameters:
| Parameter | What it sets |
|---|---|
| SQL Server IP Address | The SQL Server that hosts your SCCM/MECM database. |
| SQL Database Name | The SCCM/MECM database. |
| SQL Server Username, SQL Server Password | The SQL Server login the task connects with. |
In the supplied configuration, SQL Server Password is an encrypted parameter and SQL Server Username is stored as plain text. Treat an exported workflow file as sensitive: the username is readable in it, and the product can decrypt the password.
The other six parameters mirror those of the Microsoft Intune integration: device-type handling, the three owner-matching parameters, Debug Logging, and Safe Mode.
- Handling Device Types offers Import Computer Items Only, Import Hardware Items Only, and Import Computer and Hardware Items. It is set to Import Computer and Hardware Items in the supplied configuration.
- The three owner-matching parameters are the same as those of the Microsoft Intune integration: Matching Owners to Existing Persons, Create Owner when no matches exist, and Replace Owner when Conditions Exist. They are set to the same values as Intune's in the supplied configuration: Matching Owners to Existing Persons to Use Display Name/Primary E-mail, then Primary E-mail, Create Owner when no matches exist to Create Owners, and Replace Owner when Conditions Exist to Existing Owner is different.
- Debug Logging is the integration's debug switch.
- With Safe Mode on, the job runs and produces a session log, but no data is added or modified. Safe Mode is set to Safe Mode Off in the supplied configuration, so the first run after the task is enabled writes data.
You set these parameters on the integration's page in the Workflow Configuration tree, the category Integrations > Microsoft SCCM. Workflow Configuration, where parameter values are set, is part of the product; the Microsoft SCCM category and its parameters come from the supplied configuration. The page exists in both the Settings App and the Admin Center.
In the Settings App
Before you begin: you need the administrative right that allows managing Workflow Configuration. See Permissions Reference.
- Under Workflow and Business Logic, open Workflow Configuration.
- In the category tree on the left, select Integrations > Microsoft SCCM. The right pane shows one input control for each parameter, with its description.
- Enter the parameter values.
- Save your changes. Only the changed values of the selected category are saved.
In the Admin Center
Before you begin: you need the Workflow Configuration permission. See Permissions Reference.
- Under Workflow and Business Logic, open Workflow Configuration.
- In the category tree, open Integrations > Microsoft SCCM. The page shows one control for each parameter.
- Enter the parameter values. Save and Cancel appear once you change a value.
- Click Save.
The Admin Center page does not validate the values you enter. If you leave the page with unsaved changes, the Admin Center asks: "You should save you changes before leaving this page. Do you want to leave this page?"
Run the task
The Microsoft SCCM Integration task is disabled in the supplied configuration. Until an administrator enters the connection parameters and enables the task, it does not query your SCCM/MECM database.
You enable and run the Microsoft SCCM Integration task, and read its sessions, on the Scheduled Tasks pages. See Scheduled Tasks.