Microsoft Endpoint Configuration Management
Configuration Management- Overview
- Setup
- Data & mappings
- Operations & API
- Changelog
The Microsoft Endpoint Configuration Manager (MECM, formerly SCCM) connector integrates directly with the MECM site database on Microsoft SQL Server to synchronize managed-device inventory and software data into the Brinqa platform. It runs read-only SQL queries against the standard MECM reporting views (v_R_System, v_GS_OPERATING_SYSTEM, v_Add_Remove_Programs, etc.) and maps the results to hosts, software packages, and software installations.
The connector synchronizes the following categories of data:
- Devices — Managed computers/devices from the MECM inventory, mapped to hosts
- Packages — Distinct software products discovered across devices
- Installed Packages — Software installations linking a package to the device it is installed on
Category: Configuration Management
Data retrieved from Microsoft Endpoint Configuration Manager
| Connector Object | Required | Maps to Data Model |
|---|---|---|
| Device | Yes | Host |
| Package | Yes | Package |
| Installed Package | Yes | Installed Package |
Model relationships
For detailed steps on how to view the data retrieved from Microsoft Endpoint Configuration Manager in the Brinqa Platform, see How to view your data.
Connection settings
When setting up a data integration, select Microsoft Endpoint Configuration Manager from the Connector dropdown and provide the following:
| Setting | Required | Default | Description |
|---|---|---|---|
| Server name | Yes | — | MECM SQL Server name. |
| Port | No | 1433 | TCP/IP port for SQL Server, defaults to 1433. |
| Database name | No | CM_{Site} | MECM database name, generally follows ''CM_SiteName'' format. |
| Authentication | No | — | Use Windows Authentication mode. |
| Domain | No | — | Windows domain to authenticate in, required when using Windows Authentication mode. |
| User name | No | — | Login for SQL Server |
| Password | No | — | Password for SQL Server |
| JDBC URI | No | — | Use URI for advance/direct usage. |
Authentication
The connector connects to the MECM SQL Server site database over JDBC. It supports two authentication modes:
- SQL Server login — a SQL Server
usernameandpassword. - Windows Authentication — integrated Windows authentication (enabled with the
win_authoption), which additionally requires the Windowsdomain.
An advanced JDBC connection URI (advance) may be supplied to override the connection string directly.
Connection
| Setting | Value |
|---|---|
| Server | {server}:{port} (default port 1433) |
| Database | MECM site database, typically CM_{SiteCode} |
| Protocol | JDBC (Microsoft SQL Server) |
Sync Behavior
The connector performs an incremental (delta) sync. When a sync token from a prior run is available, records are filtered by that timestamp; on the first run, or when no token is present, a full sync is performed.
How to obtain Microsoft Endpoint Configuration Manager credentials
Obtain the required credentials (server) from your Microsoft Endpoint Configuration Manager administrator or the Microsoft Endpoint Configuration Manager admin console, then enter them in the connection settings above.
Attribute mappings
Expand the sections below to view the mappings between the source and the Brinqa data model attributes:
Device
| Source Field Name | SDM Attribute |
|---|---|
Active0 (normalized; forced inactive when obsolete or decommissioned) | STATUS |
| Active0-derived status | SOURCE_STATUS |
| AD_Site_Name0 | ACTIVE_DIRECTORY_SITE |
| Build01 | OS_VERSION |
| Client_Type0 | CLIENT_TYPE |
| Client_Version0 | CLIENT_VERSION |
| constant ASSET_CATEGORY_HOST | CATEGORIES |
| CPUType0 | CPU_TYPE |
| Creation_Date0 | SOURCE_CREATED_DATE |
| Decommissioned0 | DECOMMISSIONED |
| Distinguished_Name0 | DISTINGUISHED_NAME |
| Hardware_ID0 | HARDWARE_ID |
| InternetEnabled0 | INTERNET_ENABLED |
IP_Addresses0 (non-public subset) | PRIVATE_IP_ADDRESSES |
IP_Addresses0 (public subset) | PUBLIC_IP_ADDRESSES |
| Is_Portable_Operating_System0 | PORTABLE_OPERATING_SYSTEM |
| Is_Virtual_Machine0 | VIRTUAL_MACHINE |
| Last_Logon_Timestamp0 | LAST_LOGIN |
| Name0 | NAME |
Name0 + Virtual_Machine_Host_Name0 (lowercased) | HOSTNAMES |
| Netbios_Name0 | NETBIOS_NAME |
| Obsolete0 | OBSOLETE |
| Resource_Domain_OR_Workgr0 | DOMAIN_NAME |
| SerialNumber | SERIAL_NUMBER |
v_GS_LastSoftwareScan.LASTSCANDATE | SOFTWARE_SCAN |
v_GS_OPERATING_SYSTEM.Caption0 | OPERATING_SYSTEM |
v_GS_OPERATING_SYSTEM.LastBootUpTime0 | LAST_REBOOT |
v_GS_WORKSTATION_STATUS.LastHWScan | HARDWARE_SCAN |
v_R_System.ResourceID | UID |
v_RA_System_IPAddresses.IP_Addresses0 (comma-split, distinct) | IP_ADDRESSES |
v_RA_System_MACAddresses.MAC_Addresses0 (normalized) | MAC_ADDRESSES |
| Virtual_Machine_Host_Name0 | VM_HOST_NAME |
Package
| Source Field Name | SDM Attribute |
|---|---|
| constant ASSET_CATEGORY_PACKAGE | CATEGORIES |
MAX(TIMESTAMP) | LAST_SEEN |
MD5 of (Name, Publisher, Version) | UID |
| Publisher0 | PUBLISHER |
v_Add_Remove_Programs.DisplayName0 | NAME |
| Version0 | CURRENT_VERSION |
Installed Package
| Source Field Name | SDM Attribute |
|---|---|
| constant ASSET_CATEGORY_INSTALLED_PACKAGE | CATEGORIES |
generated Package UID — MD5 of (Name, Publisher, Version) | TYPE |
| generated product id | PRODUCT_ID |
InstallDate0 (parsed yyyymmdd) | INSTALL_DATE |
MD5 of (Asset ID, generated product id) | UID |
| TIMESTAMP | LAST_SEEN |
v_Add_Remove_Programs.DisplayName0 | NAME |
v_R_System.ResourceID (Asset ID) | TARGETS |
Operations & API
Expand each connector object to see its operation options, delta-sync behavior, and the API it uses. See connector operation options for how to apply operation options (keys and values are case-sensitive).
Device
Operation options
This object does not support any operation options.
Delta sync
Supported. The connector performs an incremental (delta) sync via the since sync token, filtering on v_R_System.Creation_Date0.
API
- Type: SQL query (Microsoft SQL Server / JDBC) against the MECM site database — no HTTP API.
Package
Operation options
This object does not support any operation options.
Delta sync
Supported. The connector performs an incremental (delta) sync via the since sync token, filtering on v_Add_Remove_Programs.TIMESTAMP.
API
- Type: SQL query (Microsoft SQL Server / JDBC) against the MECM site database.
Installed Package
Operation options
This object does not support any operation options.
Delta sync
Supported. The connector performs an incremental (delta) sync via the since sync token, filtering on v_Add_Remove_Programs.TIMESTAMP.
API
- Type: SQL query (Microsoft SQL Server / JDBC) against the MECM site database.
Changelog
The Microsoft Endpoint Configuration Manager connector has undergone the following changes:
| Version | Description | Migration Steps |
|---|---|---|
| 3.5.9 | No changes in this release. | N/A |
| 3.5.8 | No changes in this release. | N/A |
| 3.5.7 | No changes in this release. | N/A |
| 3.5.6 | No changes in this release. | N/A |
| 3.5.5 | Bug Fixes - Corrected the Installed Package "Install date" attribute to be stored as a proper timestamp (was stored as a number). | • Installed Package: the "Install date" attribute changed from a number to a timestamp. Re-sync the MECM connector to repopulate these records with the corrected type. |
| 3.5.4 | No changes in this release. | N/A |
| 3.5.3 | No changes in this release. | N/A |
| 3.5.2 | No changes in this release. | N/A |
| 3.5.1 | No changes in this release. | N/A |
| 3.5.0 | No changes in this release. | N/A |
| 3.4.32 | No changes in this release. | N/A |
| 3.4.31 | No changes in this release. | N/A |
| 3.4.30 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.4.29 | No changes in this release. | N/A |
| 3.4.28 | No changes in this release. | N/A |
| 3.4.27 | No changes in this release. | N/A |
| 3.4.26 | No changes in this release. | N/A |
| 3.4.25 | No changes in this release. | N/A |
| 3.4.24 | No changes in this release. | N/A |
| 3.4.23 | No changes in this release. | N/A |
| 3.4.22 | No changes in this release. | N/A |
| 3.4.21 | No changes in this release. | N/A |
| 3.4.20 | No changes in this release. | N/A |
| 3.4.19 | No changes in this release. | N/A |
| 3.4.18 | No changes in this release. | N/A |
| 3.4.17 | No changes in this release. | N/A |
| 3.4.16 | No changes in this release. | N/A |
| 3.4.15 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.4.14 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.4.13 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.4.12 | No changes in this release. | N/A |
| 3.4.11 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.4.10 | No changes in this release. | N/A |
| 3.4.9 | No changes in this release. | N/A |
| 3.4.8 | No changes in this release. | N/A |
| 3.4.7 | No changes in this release. | N/A |
| 3.4.6 | No changes in this release. | N/A |
| 3.4.5 | No changes in this release. | N/A |
| 3.4.4 | No changes in this release. | N/A |
| 3.4.3 | No changes in this release. | N/A |
| 3.4.2 | No changes in this release. | N/A |
| 3.4.1 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.4.0 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.3.10 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.3.9 | No changes in this release. | N/A |
| 3.3.8 | No changes in this release. | N/A |
| 3.3.7 | Bug Fixes - Device records now skip blank or non-text database values instead of writing them as empty or malformed attributes, improving the accuracy of identifiers such as IP addresses, MAC addresses, hostnames, and operating system details. Dependency Upgrades - Updated shared connector framework libraries. | N/A |
| 3.3.6 | No changes in this release. | N/A |
| 3.3.5 | No changes in this release. | N/A |
| 3.3.4 | No changes in this release. | N/A |
| 3.3.3 | No changes in this release. | N/A |
| 3.3.2 | No changes in this release. | N/A |
| 3.3.1 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.3.0 | No changes in this release. | N/A |
| 3.2.2 | No changes in this release. | N/A |
| 3.2.1 | Dependency Upgrades - Updated shared connector framework libraries. No functional change to synchronized data. | N/A |
| 3.2.0 | Overview The Microsoft Endpoint Configuration Manager (MECM) connector integrates with a MECM SQL Server database to synchronize managed devices and their installed and deployed software. Category: Configuration Management Models | N/A |