sevco.io

Microsoft ECM - Software

EARLY ACCESS

About

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.

Why You Should Integrate

Integrating with Microsoft ECM will provide visibility into the software packages installed on your devices.

How Does the Integration Work

This integration pulls all installed software from Microsoft ECM by connecting directly to the ECM SQL Server.

This data is only used internally; we do not share it with any parties outside of Sevco. Refer to our privacy policy for details.

⚠️

If you haven't already, please review our instructions for configuring the integration before proceeding with the instructions below.

Configuration Options

FieldDescriptionExample
Database*Name of SCCM database. SCCM database names are usually of format CM_ABC, where ABC is the SCCM site code.CM_ABC

External Documentation

Creating credentials

See platform documentation for details on Microsoft ECM - Creating credentials

Required Permissions

The following user permissions are required on the Microsoft ECM database

  • db_datareader
  • SELECT privileges to the following tables:
    • v_R_System
    • v_GS_ADD_REMOVE_PROGRAMS_64
    • v_GS_INSTALLED_SOFTWARE
    • v_GS_OPERATING_SYSTEM

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 & configuration