Skip to main content
Skip table of contents

Microsoft System Center Configuration Manager

What is Microsoft SCCM?

Microsoft System Center Configuration Manager (SCCM) is a systems management software product for managing large groups of computers running Windows NT, Windows Embedded, macOS (OS X), Linux or UNIX, as well as Windows Phone, Symbian, iOS, and Android mobile operating systems.

Why Should You Use the Microsoft SCCM Connector?

The Microsoft SCCM connector provides visibility into the assets and users managed by SCCM. You can use this visibility to:

  • ensure assets are managed per your security policies

  • monitor each endpoint and its status 

How Does This Connector Work?

Lucidum executes read-only requests to the Microsoft SCCM REST API and ingests only meta-data about SCCM users and asset. Lucidum does not retrieve any data stored on your assets.

Configuring the Connector in Lucidum

Field

Description

Example

Host

The hostname or IP address of the SQL Server for the SCCM instance.

To specify a named instance of SQL Server, use the format <server host>/<instance name>

If no instances is specified, Lucidum uses the default instance.

VM-SCCM.lucidum.io

or

VM-SCCM/instance11

Port

Optional field.

Port on the SQL Server for communication from Luciudum.

If no port is specified, Lucidum uses default port 1433.

1434

Domain

The name of the SQL Server domain.

If the Lucidum connector uses a local SQL Server login, leave this field blank.

lucidum

User Name

User Name that has read access to the SQL Server for SCCM.

The user must have db_datareader permissions.

Lucidum recommends you create a local SQL User account to use with the Lucidum connector. Note that to use SQL Server Authentication, the Database Engine must use mixed mode authentication.

If you choose to use domain authentication instead, specify the user name and supply a value in the Domain field.

justynmutts

Password

The password for the SQL Server account.

 ************

Database

Name of the database for Microsoft SCCM. You can find this name in the Registry Editor, under HKLM:\SOFTWARE\Microsoft\SMS\Identification

Usually starts with “CM_”

CM_acme

Source Documentation

Creating Credentials

For details on creating an account that is authenticated on the SQL Server, see:

https://www.ibm.com/docs/en/capmp/8.1.4?topic=monitoring-creating-user-granting-permissions#task_min_permission

Required Permissions

  1. Log in to SQL Server Management Studio (SSMS).

  2. In the Object Explorer pane, go to Security > Logins.

  3. Right click the SCCM database. Select Properties.

  4. Select Permissions.

  5. Select the account that the Lucidum connector uses.

  6. In Permissions for, select:

    • public

    • db_datareader

  7. Click OK

API Documentation

https://learn.microsoft.com/en-us/mem/configmgr/develop/reference/configuration-manager-reference

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.