SCCM Connector

Modified on Thu, 29 Jan at 12:31 PM

SCCM Connector Guide

Overview

The Microsoft System Center Configuration Manager (SCCM) connector enables ManagementStudio to synchronise data from an SCCM database. The connector provides multiple configuration panels, each responsible for a specific aspect of the import and mapping process:

SCCM Discovery Status
Mapping Rules
Import Applications
Import Users
Import Devices
Database Settings
Troubleshooting

Administrators can enable or disable the SCCM connector and adjust the configuration within these panels as required.

SCCM Discovery Status

This panel manages the execution and scheduling of SCCM data synchronisation.

UI Element	Description
`Run SCCM Discovery Now`	Launches an immediate synchronisation with the SCCM database.
`Schedule SCCM Discovery #1`	Specifies a schedule for recurring synchronisation.
`Schedule SCCM Discovery #2`	Allows a second scheduled synchronisation.
`Last Discovery Date`	Displays the date and time of the last successful synchronisation.
`Sync SCCM From Date`	Sets the import start date for new User-App links. Blank defaults to the past three months.
`Email Logs To`	Comma-separated list of email addresses to receive synchronisation logs. Use `;` to separate multiple addresses (e.g. `t@blogg.com;Accounts@blogg.com`).
`Overall Progress`	Shows the overall progress of the current SCCM import.
`Current Task Progress`	Displays progress for the current synchronisation task.
`Import Log`	Displays detailed synchronisation logs.

Mapping Rules

This panel manages the relationship mappings between Users, Applications, and Devices imported from SCCM.

UI Element	Description
`Mapping Links`	Determines which link types are imported: 1. Users-Apps-Devices 2. User-Apps 3. Users-Devices 4. Apps-Devices
`Mapping Rules`	Additional rules to control mapping: 1. Restrict imported Apps and Devices to those linked to existing Users 2. Create mapping even if Deployment Unit is locked 3. Create mapping even if User, App, or Device is locked 4. Create mapping even if User, App, or Device is archived

Import Applications

This panel controls which applications are imported and how they are mapped.

UI Element	Description
`Alt SCCM Name Exes`	Specifies executables to rename during import. For example, if `WINWORD.EXE`is listed here, the application entry will be named "Microsoft Word" instead of "Microsoft Office".
`Exe White List`	List of executable names to always include in the import, even if filtered by default. Make sure the application has not already been detected by SCCM to prevent duplicates.
`Exe Exclusion List`	List of executable names to exclude from import. Supports wildcard `%` (e.g. `%install%.exe`, `%setup%.exe`).
`Folder Exclusion List`	Folders to exclude from application import (e.g. `C:\Users\%`, `C:\Documents And Settings\%`).
`Add to Blueprint`	Path (e.g. `Discovery\SCCM\App`) to which newly discovered applications will be added in ManagementStudio.

Import Users

This panel manages the import of user accounts from SCCM.

UI Element	Description
`Domain Filter`	Comma-delimited list of domains to import users from (e.g. `Global,HOP,UK,FR`).
`User Name is NOT`	List of user patterns to exclude from import. Supports wildcard `%` (e.g. `srv_%`, `Print%`).
`Add to Blueprint`	Path (e.g. `Discovery\SCCM\Users`) to which newly discovered users are added.

Import Devices

Controls which devices are imported and how they are mapped.

UI Element	Description
`Device Field Mappings`	Map SCCM fields to ManagementStudio device records.
`Hostname is NOT`	Prevents devices with specified hostnames from being imported. Comma-delimited list with `%` for wildcards (e.g. `GFR0001,PRT12537%,%KIOSK%`).
`MAC Software Filter`	MAC software to exclude from import.
`MAC Service Filter`	MAC services to exclude from import.
`OS Version IS`	Operating system versions to include. Comma-delimited, `%` wildcard allowed (e.g. `%6.1%`, `%6.1.7%`).
`OS Version IS NOT`	Operating system versions to exclude. Comma-delimited, `%` wildcard allowed (e.g. `%8.1%`, `%6.1.7%`).
`OS Name IS`	OS names to include. Comma-delimited, `%` wildcard allowed (e.g. `%Windows 7%`, `%Windows 8%`).
`OS Name IS NOT`	OS names to exclude. Comma-delimited, `%` wildcard allowed (e.g. `%Windows 7%`, `%Windows 8%`).
`Domain Filter`	Restricts import to specified domains. Leave blank for no filtering.
`Domain Override`	Set a domain override value and exceptions, comma-delimited.
`Add to Blueprint`	Path (e.g. `Discovery\SCCM\Devices`) where new devices will be added.

Database Settings

Configure SCCM database connection details in this panel.

UI Element	Description
`DB Server`	Hostname of the SCCM database server.
`DB Name`	Name of the SCCM database.
`DB User Name`	Username for SCCM database authentication.
`DB Password`	Password for the database user.
`Integrated Security`	Enable to use service account for SCCM connection; otherwise specify user credentials.
`Explicit Sql Collation`	Specify if the database uses a non-standard collation (e.g. `SQL_Latin1_General_CP1_CI_AS`).
`Paging`	Set to `Off` when the SCCM database is hosted on SQL Server version earlier than 2012.

Troubleshooting

Use this panel to aid in diagnosing connector or import issues.

UI Element	Description
`Notes`	Field to record environment or project notes.
`Installed Version`	Currently installed version of the connector.
`Installed Date`	Date when current connector version was installed.
`Verbose Logging`	Generates detailed logs; enable only for troubleshooting as files may be large.
`Save Sql Query to file`	Saves the SQL query to file for review.
`Save Sql Results to file`	Exports the SQL results to file for investigation.

Adding an SCCM Connector

Overview

Follow these steps to add and configure a new SCCM connector in ManagementStudio.

Creating a SCCM Connector

Navigate to Administration in the left-hand menu. Fig.1.1
Select Extensions from the automation panel. Fig.1.2
Click Connectors. Fig.1.3
Click Add New Connector. Fig.2.1
Select + SCCM - [Server]. Fig.2.2
Enter a name for the SCCM Server. Fig.3.1
Click OK to create the connector. Fig.3.2
The SCCM connector will now be visible in the left menu.

Initial Configuration

Ensure the toggle next to SCCM Discovery Status is set to ON.
Scroll to the Database Settings panel Fig.4 and enter:
- DB Server
- DB Name
- DB Username (Required for account-based authentication)
- DB Password (Required for account-based authentication)
- Integrated Security (Enable to use the service account)
Click Save Changes.
Click Run SCCM Discovery Now.
Confirm the action when prompted.
After synchronisation completes, a notification will appear.
Review the Import Log for results and errors.
The Last Discovery Date field will show the timestamp of the latest successful sync.
Once the connector is established, adjust import and mapping settings for Users, Devices, and Applications using the available panels as required.

Figure 1

Figure 2

Figure 3

Figure 4

Further Support

If you require further assistance, visit the ManagementStudio Service Desk to search the knowledge base or to create a support ticket.