Microsoft Endpoint Configuration Manager (fka SCCM)
Overview
Microsoft Endpoint Configuration Manager (ECM), formally known as System Center Configuration Manager (SCCM) is an integrated solution for managing all of your devices by bringing together Configuration Manager and Intune into a single solution.
Available Integrations
The following Microsoft ECM services can be integrated with the Sevco platform:
Please review the configuration instructions in the section below before setting up permissions for apps.
Configuration
- Configure the Access Schema:
| Field | Description | Example |
|---|---|---|
Host* | Hostname or IP of MSSQL Server | mssql.domain.org |
Port* | Port for MSSQL Server (Usually 1433) | 1433 |
Username* | Username for MSSQL user with appropriate permissions. Users using Windows Authentication should use <domain>\<username> as their username format.Users using Mixed or SQL Authentication should use <username> as their format. | domain\username |
Password* | password for MSSQL user | ********************* |
-
Select a Runner
-
Add new integration Select which integration(s) you wish to add. See links for details on additional configuration required.
-
Configure General Information: OPTIONAL: You can set the following fields to give platform configuration
| Field | Description | Example |
|---|---|---|
Name (optional) | Uniquely identifiable attribute of the configuration to delineate other similar configurations with the existing organization | DMZ network |
Contact Person (optional) | A placeholder to input a name or email address of a contact associated with the integration | Jane Doe |
Link to Console (optional) | A placeholder to input a link to the console of the product Sevco is integrating with for quick reference and access when configuring or editing the integration. | www.product.com/devices |
- Activate Config: To enable this configuration and begin pulling data select "Activate".
External Documentation
Creating credentials
You'll be asked to provide source credentials that Sevco will use to connect to Microsoft ECM. The following link will step you through creating a database user.
SQL Authentication
Mixed Authentication mode is required. It is recommended to create a new user on the Microsoft ECM SQL server with the required permissions.
Required Permissions
See integration specific documentation for details
| Integration | DB Permission(s) | Table Select Privileges |
|---|---|---|
| Collect devices | db_datareader | v_R_System v_RA_System_IPAddresses v_RA_System_MACAddresses v_GS_OPERATING_SYSTEM v_GS_WORKSTATION_STATUS |
| Collect software | db_datareader | v_R_System v_GS_ADD_REMOVE_PROGRAMS_64 v_GS_INSTALLED_SOFTWARE v_GS_OPERATING_SYSTEM |
API Documentation
n/a
Contact Us
If you're having problems integrating a source, or if you've found something wrong in this document, please email us at [email protected].
Tags: on-prem, patch & configuratiom
Updated 7 months ago