# 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 Aurora ASM platform: | Service | Supported Asset Type(s) | Integration Type | | :------ | :--------------------------------------------------------------------------- | :--------------- | | ECM | Devices, Software | Source | Please review the configuration instructions in the section below before setting up permissions for apps. # Configuration 2. **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 Authenticationshould use `\` as their username format. Users using Mixed or SQL Authentication should use `` as their format.	`domain\username`
`Password`*	password for MSSQL user	`*********************`

3. **Select a Runner** 4. **Add new integration** Select which integration(s) you wish to add. See links for details on additional configuration required. * Collect devices * Collect software 5. **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 Aurora ASM is integrating with for quick reference and access when configuring or editing the integration. | `www.product.com/devices` | 5. **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 Aurora ASM 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 v_GS_PC_BIOS v_AgentDiscoveries
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 configuring an Integration, or if you've found something wrong in this document, please email us at support@arcticwolf.com.