Skip to main content

Microsoft Configuration Manager (SCCM)

Visualize Microsoft Configuration Manager devices, device collections, and local users in the JupiterOne graph. Use this integration to also monitor changes to Microsoft Configuration Manager entities using JupiterOne alerts.



JupiterOne uses a connection to the Microsoft SQL server that hosts data for Microsoft Configuration Manager to pull data. If you have the ability to log into the database, it is strongly recommended that a user create an account specifically for JupiterOne to use. At a minimum, login credentials for an account that includes public and db_datareader permissions will be needed.

Configuration in Microsoft Configuration Manager

  1. In the object explorer, open the "Security" folder.
  2. Right-click on "Logins" and select "New Login..."
  3. Create a user using the following steps:
    • Enter the login name j1int.
    • Select "SQL Server Authentication".
    • Create a password.
    • Set the default database to your Microsoft Configuration Manager database
    • Navigate to the "User Mapping" page.
    • Check the "Map" box for the Microsoft Configuration Manager database row.
    • Ensure that both public and db_datareader are checked under "Database role membership for: " the Microsoft Configuration Manager database.
    • Click "OK".

Configuration in JupiterOne

  1. From the top-bar menu, select Integrations.
  2. Scroll to, or search for, the Microsoft Configuration Manager (SCCM) integration tile and click it.
  3. Click the New Instance button and configure the settings:
    • Enter the Host for the Microsoft Configuration Manager database.
    • Enter the Database name.
    • Enter the login name for the account to be used for SQL data retrieval. (the suggested name is j1int).
    • Enter the password for the account to be used for SQL data retrieval.
    • Enter in a name and description for the integration instance.
  4. Click the Create button to complete the integration.

Next steps

Now that your integration instance has been configured, it will begin running on the polling interval you provided, populating data within JupiterOne. Continue on to our Instance management guide to learn more about working with and editing integration instances.