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.
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:
- Managing Incident IQ Apps - A guide designed to provide a brief overview of Incident IQ apps and how to access app management.
- Installing the Microsoft SCCM Integration - A guide that provides step-by-step instructions on how to integrate SCCM with Incident IQ.
You can use the following links below to quickly navigate to a specific section in this document. To quickly return to this index simply use the "Return to Index" link located at the end of any section.
- App Management Introduction
- Frequently Asked Questions
- What location should I use for my default location?
- Can I pull room information from Microsoft SCCM into Incident IQ?
- Can I map certain fields coming from Microsoft SCCM to default asset fields in Incident IQ?
- Why are assets not getting created during syncs?
- Why are asset tags not updating during syncs?
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 Manage to access the SCCM app management.
The Overview Tab gives you the ability to quickly review the status of the most recent sync between Incident IQ and Microsoft SCCM. While syncs will automatically run overnight, you have the option to Re-Run Last Sync.
Additionally, you can use the View Details button to take you directly to the Sync History tab where you can review the count of assets updated, added, or skipped over during the most recent sync.
General Settings Tab
The General Settings tab has the settings that control when information is brought in or updated automatically, as well as field mappings between the Microsoft SCCM and Incident IQ. As such, you can find the following settings here:
- Options that control if assets are automatically created, updated, and deleted during system syncs.
- The ability to turn on automatic room assignment for assets if you are storing this data in Microsoft SCCM.
- Custom field asset mapping options to pull in additional data for use in asset filters and custom view columns.
The Mapping section manages what data is created and updated in Incident IQ based on data coming from Microsoft SCCM. This includes:
- Create Asset: Selecting this will automatically create assets in IIQ to match any new device discovered in Microsoft 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 Microsoft SCCM during a sync.
- Update Custom Fields: Selecting this option will only allow new information being pulled into custom fields to update during a sync.
- Delete Asset: Selecting this will automatically delete assets in IIQ to match any assets deletions that have occurred in Microsoft SCCM during a sync.
Next, under the Import Options section you can enable the Create Rooms option. This will automatically create rooms associated with assets in Microsoft SCCM if these rooms do not already exist in Incident IQ. Additionally, the Update Asset Owner option will automatically update owner in Incident IQ based on the primary user in Microsoft SCCM.
The Map custom values section allows you to select additional values you want imported and map them to default or custom fields in iiQ. This gives you the ability to pull in custom data fields and custom view column options. Click on the Add button.
Next, fill out the following field mapping options:
Please note, there may be pre-configured mapping and they can not be changed.
- Select the custom value
- Select the iiQ field the custom value should map too. You can map to a default field or map to a custom field.
- If you map to a Custom Field, you will need to set a field name, select a field type (text, number, or date), and set whether the field information needs to be searchable through filters.
Location Mappings Tab
This tab allows you to select or modify your current location mappings between IIQ and Microsoft SCCM. You can choose to automatically assign a device to a default location in Incident IQ if it does not match any location mappings set. This is especially important if you are using the Microsoft SCCM integration to automatically create assets because assets must have a location set to be created.
Location is required for an asset to be created in iiQ. The way this works during a sync is as follows:
- If an asset matches the location mapping, then the asset will get created and assigned to the corresponding location the mapping is set to.
- If an asset does not match a location mapping, or no location mappings are present, and a default location is selected, then the asset will get created and assigned to the default location.
- If an asset does not match a custom mapping, or no custom mappings are present, and there is no default location set, then the asset will not be created during a sync.
The Custom Mapping Options allows you to choose how you would like devices to map in IIQ. 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 Microsoft 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 current model mappings between IIQ and the Microsoft SCCM School. Unmapped models will not be imported into iiQ. 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.
The verifications tab allows you to utilize Microsoft SCCM login activity to verify assets outside of the normal verification process. This is beneficial with Audit Manager.
From this page, you can kick off a single manual verification by clicking on the Start Verification button.
Alternatively, you can set up a 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 Edit, Delete, 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 Microsoft SCCM. 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 basic information on any device currently located in your Microsoft 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 Microsoft SCCM information:
- External ID
- Owner Email
- Organizational Unit
- Serial Number
- Location Name
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.