Microsoft SCCM Integration Management

Important Note: In order to automatically create assets in Incident IQ from Microsoft SCCM you will need to enable the Create Asset option, as well as have location and models mapped in their respective tabs. Failure to do so can prevent some or all of your assets from importing/updating during scheduled syncs.

Guide Overview

The following guide is designed to give district administrators an overview of the following topics:

  • Managing what device data is created, updated, and deleted during Microsoft SCCM app system syncs
  • Setting up model and location mappings
  • Reviewing historical system syncs
  • Looking up a device’s asset data in the Microsoft SCCM app

Not what you were looking for? Perhaps one of these other guides will help:

App Management Introduction

The SCCM app is designed to give school districts the ability to create, manage, and automatically assign assets to students in Incident IQ by utilizing the data stored in SCCM. In addition, integrating Chrome devices into Incident IQ allows you to view an asset’s metadata in one convenient location. This includes basic device information, OS and firmware versions, the installed apps on a device, and other data agents found useful during the course of working a ticket.

When installed, you can access the SCCM app by selecting Incident IQ Apps > Apps Management. This will take you to your Installed Apps page where you can select the Options button to access the SCCM app management.

Overview Tab

The Overview Tab provides you the ability to quickly review the authentication status between Incident IQ and SCCM as well as details concerning the last system sync.

The Sync section allows you to quickly review what occurred during the last scheduled system sync. Clicking on the View Details link will automatically open the details of the last sync. Additionally, you can also manually start a sync from here using the Start Sync button.


General Settings Tab

The General Settings Tab allows you to control which devices and device data the SCCM app will create, update, and delete during system syncs.

The Mapping section manages what data is created and updated in Incident IQ based on data coming from SCCM. This includes:

  • Only Update Custom Fields: Selecting this will automatically update only custom field information in IIQ during syncs to match the information stored in SCCM.
  • Create Asset: Selecting this will automatically create assets in IIQ to match any new device discovered in SCCM during a sync.
  • Update Asset: Selecting this will automatically update assets in IIQ to match any updates to a device’s data discovered in SCCM during a sync.
  • Delete Asset: Selecting this will automatically delete assets in IIQ to match any assets deletions that have occurred in SCCM during a sync.
  • Create Rooms: Selecting this will automatically create a room at the corresponding location if a room does not already exist prior to a sync.
  • Update Asset Owner: Selecting this will automatically update owner information in IIQ during syncs to match the asset owner information stored in SCCM.

You can also map any number of values stored in SCCM to data fields within IIQ. This allows you to easily build custom views and export reports based off of the data pulled from your console. When you want to map a custom field, begin by clicking on Add.

This will bring up your field mapping options. From here, you can select the SCCM data field you want to pull into IIQ, as well as if it will map to a default field already in IIQ or create a new custom field instead.

Location Mappings Tab

This tab allows you to select or modify your location mappings between IIQ and the SCCM app.

You can choose to automatically assign a device to a default location in Incident IQ if it does not match any location mappings set. Please note that a default location must be selected when creating devices through the SCCM integration.

The Custom Mapping Options allows you to choose how you would like devices to map in IIQ. You can choose to match Location Names between the two systems or match locations to specific OUs in SCCM.

When either is selected, you will be presented with a list of locations currently in the system. From here, you can select Auto-Map Location Names to match location names between IIQ and SCCM. Alternatively, you can also manually search for and select your location assignments if needed.

Model Mappings Tab

This tab allows you to select or modify your model mappings between IIQ and the SCCM app.

You can use the Auto-Map Models button to automatically attempt to match models in your list of devices with models that already exist in IIQ.

Alternatively, you can also manually select what model your device should map to using the drop-down menus to the right of each listed device.

If your device will not auto-map and is not available from the drop-down options, then it most likely does not currently exist in IIQ. In this case, simply select the Create New Model button on the right of the device mapping in question to automatically create and activate this model during your data sync.

Verification Tab

The verifications tab allows you to utilize SCCM activity to verify assets outside of the normal verification process.

From this page, you can kick off a single manual verification by clicking on the Start Verification button.

Alternatively, you can set up Profile to automate your app verifications. Profiles allow you to automate your asset verifications, removing the need to start verifications manually.

When setting up a Profile you will be asked to provide it a name as well as fill out the following information:

  • Number of days of usage to review:  The number of days a user must log in to the system to successfully count as verified. 
  • Allow Shared Devices:  This option allows devices used by multiple users to be verified as long as the assigned owner logs in a number of times equal to what is set in the “Number of days of usage to review” field.
  • Schedule:  This option allows you to set up a schedule for when a verification should occur (once, daily, weekly, monthly, yearly). Additionally, you can also set a sunset date for the Profile here as well.
  • Select Assets:  This option allows you to set up filters for the types of devices this Profile will verify.

Once added, you can EditDelete, or review the status of any current Profile at the bottom of the Verifications page. Please note that you can set up multiple Profiles at once, as well as run them concurrently if needed.

Sync History Tab

This tab allows you to view your sync history between IIQ and the SCCM app.

Every sync, whether it completed successfully or not, is logged for reference purposes and available for review in the View details of a sync list.

Clicking on any sync, in particular, will open that sync’s details. From here, you can review the full list of what devices were updated, created, deleted, or skipped during the sync. Additionally, you can narrow down your view by using the filter options at the top of the list.

Asset History Tab

The Asset History tab allows you to search for any device’s information currently located in SCCM.

Simply enter in a valid serial number in the Search for asset field to begin your search.

Once you’ve selected a device, you’ll be able to see the following information:

  • Asset Tag
  • External ID
  • Model
  • Owner Email
  • Serial Number
  • Room

Additionally, you’ll also see a list of actions applied to this device during recent system syncs.

Sync Executable Tab

The sync executable tab is where you will set up all the information to connect to your SCCM database as well as where you will go to download the executable program needed to run the SCCM integration.

If needed, you can update the SQL command script in your SCCM install by selecting from the Predefined Templates drop-down menu. Please note that you will only ever need to update this field if you update to Microsoft SCCM 2012 or later from a version of SCCM prior to 2012.

Additionally, if you need to update your database connection settings you may also do so at the bottom of the page.

Frequently Asked Questions

The following section consists of common questions that users have when installing and setting up the Microsoft SCCM integration. Please note, if you do not find an issue you are experiencing in this section please contact the Incident IQ Customer Support team for further assistance.

What location should I use for my default location?

If you are unsure of what location you should utilize, we recommend setting the district/central office as your default location. Alternatively, you may also setup an entirely separate location (such as “Unassigned”) to utilize this purpose as well.

Can I pull room information from Microsoft SCCM into Incident IQ?

If you are storing room information in Microsoft SCCM, you can tie this information to assets stored in Incident IQ. This includes the ability to create rooms for any given location if they do not already exist in the system. To do so, you will want to go to the General Settings tab and enable the room number option.

Can I map certain fields in Microsoft SCCM to default or custom asset fields in Incident IQ?

You can pull in data from Microsoft SCCM for use in asset filtering and custom view columns in the General Setting tab of the integration app. To set one of these fields up, you will need to begin by clicking on the Add button at the bottom of the Map custom values from microsoftSccm section. From here, you will now need to set the following:

  • Select the specific data field in Microsoft SCCM you want to pull in as a custom field
  • Set whether the data only pulls from SCCM to Incident IQ, sends from Incident IQ to SCCM, or flows in both directions (if both, data will push from Incident IQ to SCCM first.)
  • Specify if the data should map to a custom field
  • And finally, set a field name, select a field type (text, number, or date), and set whether the field information needs to be searchable through filters.

Why are assets not getting created during syncs?

For a sync to create assets automatically, the following options need to be turned on or mapped in app management as detailed in this section of this article:

  • The Create asset option must be turned on in the General Settings tab.
  • Location mappings, or a default location, must be set in the Location Mappings tab.
  • The model of the device must be mapped in the Model Mappings tab.

Please note, if your asset does not have a model associated with it in Microsoft SCCM, then the asset cannot be added automatically. However, you can manually create or import the asset into the system to circumvent this issue. During the next system sync, if Incident IQ detects a matching serial number inside of Microsoft SCCM, the system will then automatically associate the SCCM data with this asset.

Why are asset tags not updating during syncs?

By default, Incident IQ does not have the option to update asset tags automatically enabled for asset integrations. To turn on asset tag updates during syncs, select Incident IQ Apps > Manage from the left navigation bar, and then click on the Data Mapping tab. From here, check the Asset Tag option underneath the Asset Field Mappings section and then save.

Please note, even though this option is not enabled by default, the asset tag field is required for asset creation. Because of this, when an asset is created during a sync without this option enable the following will occur:

  • If asset tag information is available, then the asset will be created with the asset tag stored in the Microsoft SCCM.
  • If asset tag information is not available, then the asset will be created with the serial number filled in for the asset tag.
Scroll to Top