Microsoft Endpoint Configuration Manager Spoke
The Microsoft Endpoint Configuration Manager (MECM) spoke automates actions to manage user collections, device collections, devices, and application deployments.
Request apps on the Store
Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.
Integration Hub subscription
This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.
Spoke version
Microsoft Endpoint Configuration Manager spoke v1.9 is the latest version.
Supported versions
This spoke was built for Configuration Manager 2006, but may be compatible with later versions.
Spoke dependencies
- Complex Object (com.glide.cobject)
- ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
- ServiceNow IntegrationHub Action Step – PowerShell (com.glide.hub.action_step.powershell)
- ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream)
- ServiceNow IntegrationHub Action Step – JDBC (com.glide.hub.action_step.jdbc)
- ServiceNow IntegrationHub Action Step – REST (com.glide.hub.action_step.rest)
- ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
Spoke subflows
The Microsoft Endpoint Configuration Manager spoke provides sample subflows to demonstrate automating tasks. To customize a sample subflow, copy it to the required application scope. Available sample subflows include:
| Subflow | Description |
|---|---|
| Create Collection | Creates a collection in Microsoft Endpoint Configuration Manager and creates corresponding records for the new collection in the MECM Collections table. Note: This subflow is executed by AI agents. |
| Delete Collection | Deletes the specified collection from Microsoft Endpoint Configuration Manager server and removes the corresponding records from the MECM Collections table. Note: This subflow is executed by AI agents. |
| Add Target Collection to Application | Adds a target collection to the specified application in Microsoft Endpoint Configuration Manager and creates a corresponding record in the MECM Deployments table accordingly. Note: This subflow is executed by AI agents. |
| Remove Target Collection from Application | Removes a target group from the specified application on Microsoft Endpoint Configuration Manager server and removes the corresponding records from the MECM Deployments table accordingly. Note: This subflow is executed by AI agents. |
| Configure Collection | Creates a collection and configure it with specified Application ID in the Microsoft Endpoint Configuration Manager Portal. |
| Create Software Configuration | Creates the software configuration record of the specified Microsoft Endpoint Configuration Manager application. |
| Look Up Collections | Returns the list of all instal or uninstall Collections associated with the given Microsoft Endpoint Configuration Manager Application ID. |
| Revoke Application | Adds a user or device to an uninstalled collection and then removes it from the installed collection in the MECM server. |
| Look up Configuration Data | Retrieves the configuration data for the requested item. |
| Deploy Application | Adds a user or a device to an installed collection and then removes it from the uninstalled collection in the MECM server. |
| Discover and Store Data | Finds the data from the server and then updates the records in the Application, Collection, and Deployment tables. |
Spoke actions
The Microsoft Endpoint Configuration Manager spoke provides actions to automate tasks when events happen on your ServiceNow instance. Available actions include:
| Category | Action | Description |
|---|---|---|
| Advanced Actions | Look up Device Collections Stream (Database) | Retrieves the device collection data from the MECM server using the Java Database Connectivity (JDBC) connection. |
| Look up User Collections Stream (Database) | Retrieves the user collection data from the MECM server using the JDBC connection. | |
| Applications | Look up Applications | Retrieves the application data from the MECM server. |
| Device Management | Look up CMPivot Response by Operation ID | Retrieves CMPivot response from the MECM server. |
| Look up Device by ID | Retrieves the device data from the MECM server. | |
| Run CMPivot Query | Runs the CMPivot query and retrieves the operation IDs from the MECM server. | |
| Run MECM Script | Runs the MECM script and returns the operation ID from the MECM server. | |
| Look up MECM Script by Name | Retrieves the Globally Unique Identifier (GUID) of the MECM script from the MECM server. | |
| Look up MECM Script Response by Operation ID | Retrieves the MECM script response from the MECM server. | |
| Look up MECM Script Execution Response | Retrieves the MECM Script Execution Response from the MECM server. | |
| Data Management Note: These actions are available only when the Client Software Distribution 2.0 application is installed. |
Look up Configuration Data | Retrieves the configuration data from the requested item or software configuration. |
| Prepare Deployment Data | Prepares the deployment data for the requested item. | |
| Prepare Revocation Data | Prepares the revocation data for the requested item. | |
| Store Discovered Data | Stores the applications and deployment data in the corresponding tables. | |
| Deployments | Add device collection to application | Adds a Device Collection to a targeted application in Microsoft Endpoint Configuration Manager. Note: The application must have at least one deployment type and content distributed to a distribution point before deployment. |
| Look up Deployments | Retrieves the deployment data from the MECM server. | |
| Remove User Collection from Application | Removes a user collection from an application in the MECM. | |
| Add User Collection to Application | Adds a user collection to a targeted application in MECM. Note:
The application must have at least one deployment type and content distributed to a distribution point before deployment. |
|
| Remove Device Collection from Application | Removes a device collection from an application in MECM. | |
| Device Collections | Add to Device Collection | Adds the named device to the collection specified. |
| Is Device in Collection | Checks if a device exists in the device collection in the MECM server. | |
| Look up Device Collections | Retrieves the device collection data from the MECM server. | |
| Remove from Device Collection | Removes the specified device from the collection in the MECM server. | |
| Create Device Collection | Creates a new device collection in MECM with a unique collection name. Note: Provide values for the following input fields:
|
|
| Delete Device Collection | Deletes a device collection from Microsoft Endpoint Configuration Manager (MECM) by Collection ID, avoiding ambiguity from duplicate collection names. | |
| User Collections | Add to User Collection | Adds a user to a collection. |
| Is User in Collection | Checks if a user exists in a user collection in the MECM server. | |
| Look up User Collections | Retrieves the user collection data from the MECM server. | |
| Remove from User Collection | Removes a user from a collection in the MECM server. | |
| Create User Collection | Creates a new user collection in MECM with a unique collection name. Note: Provide values for the following input fields:
|
|
| Delete User Collection | Deletes a user collection from MECM by Collection ID, avoiding ambiguity from duplicate collection names. | |
| Software Management | Create Catalog Item | Creates a catalog item of the specified MECM Application. |
Spoke module
| Module | Description | Table |
|---|---|---|
| Applications | Displays the list of applications from the Microsoft Endpoint Configuration Manager server. | Application [sn_ms_epcfgmgr_spk_application] |
| Configurations | Stores the software configuration details for the applications. | Configuration [sn_ms_epcfgmgr_spk_sf_config] |
| Server Instances | Stores the details of the servers provided. | Server Instance [sn_ms_epcfgmgr_spk_server] |
| Deployments | Displays the list of deployments from the Microsoft Endpoint Configuration Manager server. | Deployment [sn_ms_epcfgmgr_spk_deployment] |
| Collections | Displays the list of collections from the Microsoft Endpoint Configuration Manager server. | Collection [sn_ms_epcfgmgr_spk_collection] |
Connection and credential alias requirements
Integration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection.
For information about setting up the spoke, see Configure Microsoft Endpoint Configuration Manager and set up the spoke.
MID Server requirements
To use these actions, your instance must have a MID Server set up and configured to use PowerShell. For more information about running actions on the MID Server, see Integration steps. For information, see MID Server.
To set up the MID Server for this spoke, see Set up MID Server for a spoke.