Skip to main content

Microsoft Configuration Manager (SCCM)

Visualize Microsoft Configuration Manager (SCCM) 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.

Installation​

info

JupiterOne uses a connection to the Microsoft SQL Server that hosts data for Microsoft Configuration Manager (SCCM) to pull data. If you have the ability to log into the database, it is strongly recommended that you create an account specifically for JupiterOne to use. At a minimum, this account needs the public and db_datareader fixed database roles on the SCCM database, which grant read (SELECT) access to the views the integration queries.

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:
    • Host: the host for the Microsoft Configuration Manager database.
    • Database: the name of the Microsoft Configuration Manager database.
    • Username: the SQL login name for the account used to retrieve data (the suggested name is j1int).
    • Password: the password for that account.
    • Enter 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.