Skip to main content

Configure the Microsoft SCCM connector

The Snow Integration Connector for Microsoft SCCM is configured in Snow Integration Manager (SIM). For more information on SIM, refer to Snow Integration Manager.

The Microsoft SCCM connector uses a database connection.

In Snow Integration Manager, add the Microsoft SCCM connector and configure the settings.


To retrieve inventory data from SCCM database, a user or service account with SQL Server authentication or Windows authentication is required, according to Configure authentication.

Data connection

  1. Select the Data connection tab.

  2. In the Server box, enter the host name of the server that is hosting the SCCM database.

  3. Perform one of the following:

    • Enter user credentials for the SCCM database in the User id and Password boxes.

    • Select the Use integrated security checkbox when a user account with Windows authentication or a Windows Service account is to be used.

  4. In the Database list, select database.

  5. To verify the connection, select Test connection.

  6. In the Initial aggregation length field, select the number of months for initial aggregation of inventory data.

  7. Use the Batch Size selector to reduce the number of devices to fetch from the server. Reducing batch size this may help in very large environments, but should not be changed unless needed.

  8. Use the Accept LastScanDate from the future checkbox if there is a mismatch between time zones or if some other issue prevents the connector from retrieving all devices.

  9. To reset an ongoing incremental aggregation, select Clear Last Aggregation Date.

  10. Select Identifier.

  11. Optionally, enter a site name for this connector in the Id box.

  12. Select OK.

Data source options

The SCCM data source options gives a better overview of the SCCM setup and what views and fields the Snow Integration Manager is able to aggregate from. It is also possible to apply filters to collections and clients.

  1. Select the Data source options tab.

  2. Collection filter

    In the Collection filter (Site ID) box, enter the Site ID’s that clients will be aggregated from.

    Use semi colon as separator.

  3. Client filter

    In the Client filter box, enter the names of the clients that will be aggregated.

    Use semi colon as separator.

    A wildcard character (* or %) can be used to match several clients.

    Example 30.

    Type STO-* for all clients with a name beginning with “STO-“.

  4. Enable Apply software exclusion filters to metering data by selecting the checkbox.

  5. Select Types of devices to include.

    The retrieved information for Computers and Mobile devices will be stored in different tables, see Retrieved information.

  6. Under SCCM Software recognition, chose whether to treat registry applications from SCCM as pre-recognized or not. Option Treat all as unrecognized can be used if pre-recognized software is causing duplicates.

  7. The Advanced data source options contains options that can improve performance in large environments:

    • If the user has view creation permissions, the connector can create and use views to gather software usage information.

    • There is also an option to create an .sql script to generate the views on the server.

  8. To test the filters, select Preview.

    • Select the Use config value checkbox to use the last aggregation date.

      Note that this will either be the last aggregation date if such a value exists, or todays date subtracted with the number of months specified for initial aggregation.

    • Clear the Use config value checkbox to select a manual date for the preview.

  9. Select OK to save the settings, or Cancel.