SCCM Connector

Modified on Thu, 4 May, 2023 at 3:50 PM

TABLE OF CONTENTS



Introduction

The Microsoft System Center Configuration Manager (SCCM) connector is used to pull in data from the SCCM database. The SCCM connector consist of the following panels:

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



An Administrator has the ability to toggle between OFF/ON within the following panels described below.


SCCM Discovery Status  

The table below provides information on the elements within this panel.


UI ElementDescription
Run SCCM Discovery NowA button to allow an Admin to run the SCCM Discovery sync now.
Schedule SCCM Discovery #1Specify the times to run the SCCM Discovery.
Schedule SCCM Discovery #2Specify the times to run the SCCM Discovery.
Last Discovery DateDisplays the last time the SCCM Discovery ran successfully. 
Sync SCCM From DateDefine the date to import new User-App links from. If left blank, it will import the last 3 months.
Email Logs ToList of email addresses to email a copy of the import log at the end of the sync. Use ; for multiple list for example t@blogg.com;Accounts@blogg.com.
Overall ProgressDisplays the overall progress of the SCCM import.
Current Task ProgressDisplays the current task progress.
Import LogText box used to display the SCCM import logs.



Mapping Rules

The table below provides information on the elements within this panel.


UI ElementDescription
Mapping Links 
  1. Users-Apps-Devices.
  2. User-Apps.
  3. Users-Devices.
  4. Apps-Devices.
Mapping Rules 
  1. Restrict imported Apps and Devices to those with links 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

The table below provides information on the elements within this panel.


UI ElementDescription
Alt SCCM Name ExesThe SCCM connector typically utilises the Product Name file attribute of an application's EXE file to identify the corresponding entry in ManagementStudio. However, if WINWORD.EXE (the executable for Microsoft Word) is specified in the Alt SCCM Name Exes setting in the connector, the application entry will be named Microsoft Word instead of Microsoft Office.
Exe White ListSpecify a list of Exe names to import even if they are filtered out by the default filters (ExplorerFileName0). Ensure the application has not been detected by SCCM otherwise duplicate applications will be created.
Exe Exclusion ListSpecify a list of Exe Names to exclude from the import (ExploererFileName0) (Wildcard: %). Example %install%.exe, %setup%.exe, 
Folder Exclusion ListProvide folders to exclude from the import (For example _:\Users\%, _:\Documents And Settings\%,
Add to BlueprintAll new Applications discovered will be added to the Blueprint path specified. For example Discovery\SCCM\App



Import Users

The table below provides information on the elements within this panel.


UI ElementDescription
Domain FilterOnly import Users from the specified domains. A comma delimited list of Domains. For example Global, HOP, UK, FR.
User Name is NOTProvide a list of User accounts to be excluded from the import. For example srv_%, Print%. Wildcard: %
Add to BlueprintAll new Users discovered will be added to the Blueprint path specified. For example Discovery\SCCM\Users




Import Devices

The table below provides information on the elements within this panel.


UI ElementsDescriptions
Device Field MappingsIn this section, an admin has the ability to define and map the list of SCCM fields to be written back to the Device record in ManagementStudio.
Hostname is NOTPrevent Devices with specific hostnames from being created. A comma delimited list with % as a wild character. For example GFR0001, PRT12537%, %KIOSK%
MAC Software FilterSpecify the MAC Software to be filtered out from the import.
MAC Service FilterSpecify the MAC services to be filtered out from the import.
OS Version ISSpecify the operating systems version of the devices which should be imported. A comma delimited list with % as a wild character. For example %6.1%, %6.1.7%
OS Version IS NOTSpecify the operating systems version of the devices which should not be imported. A comma delimited list with % as a wild character. For example %8.1%, %6.1.7%
OS Name ISSpecify the operating system name of the devices which should be imported. A Comma delimited list with % as a wild character. For example %Windows 7%, %Windows 8%
OS Name IS NOTSpecify the operating system name of the devices which should not be imported. A Comma delimited list with % as a wild character. For example %Windows 7%, %Windows 8%
Domain FilterSpecify the Domain(s) to only import Devices from. Leave blank for no filters.
Domain OverrideSpecify the Domain Override value followed by exemptions in a comma delimited list.
Add to BlueprintAll new Devices discovered will be added to the Blueprint path specified. For example Discovery\SCCM\Users




Database Settings

The table below provides information on the elements within this panel.


UI ElementDescription
DB ServerDetails of the SCCM database host.
DB NameThe SCCM database name.
DB User NameDatabase Username
DB PasswordDatabase Password
Integrated SecurityTick to use the service account to connect to SCCM, otherwise specify an account.
Explicit Sql CollationIf Database has non standard config. For example SQL_Latin1_General_CP1_CI_AS.
PagingTurn Off where the SCCM is hosted on a version of SQL server earlier than 2012.





Troubleshooting

The table below provides information on the elements within this panel.


UI ElementDescription
NotesText field used to enter more information about the project environment.
Installed VersionDisplays the current version installed.
Installed DateDisplays the date the current version was installed.
Verbose LoggingThis options generates large files and should only be enabled for troubleshooting.
Save Sql Query to fileEnable this option to have the ability save the Sql query to a file.
Save Sql Results to fileEnable this option to have the ability to save the Sql results to a file.




Adding a SCCM Connector

Overview

This walkthrough shows an Admin how to add a SCCM connector.


Creating a SCCM Connector

  • Switch to Administration (1) from the left vertical menu.
  • Click on Extensions (2) from the automation panel.
  • Click Connectors (3).



  • Click Add New Connector (1).
  • Select + SCCM - [Server](2).



  • Enter the name of the SCCM Server (1).
  • Click OK (2) to create the SCCM Connector.



  • The new SCCM connector should now be visible within the left tabbed menu.
  • Ensure the toggle next to SCCM Discovery Status is turned ON.
  • Scroll down to the Database Settings panel and populate the details accordingly:
  • DB Server 
  • DB Name 
  • DB Username - Required if using a dedicated account to connect to SCCM
  • DB Password - Required if using a dedicated account to connect to SCCM
  • Integrated Security - Enable to use the service account to connect to SCCM


  • Click Save Changes.
  • Click Run SCCM Discovery Now.
  • Click Continue when asked to confirm to run the SCCM Discovery.
  • When it finishes establishing the connection to SCCM, there will be a prompt displayed notifying that it has finished.
  • The Import Log  text field will display the logs of the import.
  • The Last Discovery Date will display its last successful run.
  • This completes configuring and establishing a connection to a SCCM connector.
  • An Administrator can now switch back and configure the import based on their requirements in relation to Users, Devices and Applications using the various panels available.



Further Support

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