Configure Service Graph Connector for Microsoft SCCM using SGC Central

  • Release version: Washingtondc
  • Updated May 1, 2025
  • 4 minutes to read

    • Use the playbook available with the SGC Central application to set up the Service Graph Connector for Microsoft SCCM for pulling in Microsoft SCCM data into the CMDB.

    Before you begin

    Install Service Graph Connector for Microsoft SCCM version 3.5.0 or later from the ServiceNow Store. For ServiceNow Store installation steps, see Install a ServiceNow Store application.

    Role required: cmdb_inst_admin or admin

    About this task

    The playbook experience for onboarding connectors is activated with SGC Central in the CMDB Workspace. To configure the SGC Central application, see Configuring SGC Central and for more information on how to interact with a playbook, see Interact with Playbook.

    Procedure

    1. Navigate to Workspaces > CMDB Workspace.
    2. In the CMDB Workspace, select SGC Central.
    3. On the Overview page, select Create connection.
      Tip:
      Alternatively, you can select Create connection on the All connections page.
    4. On the Create connection window, select the Microsoft SCCM connector type, and then select Create connection.
    5. Complete the initial prerequisites when setting up a connection for the first time using a connector.
      Note:
      This step is required only during the first-time setup. See Perform initial setup tasks when creating a connection in SGC Central.
    6. Select a template that matches the credentials for establishing a Java Database Connectivity (JDBC) connection to the SCCM database.
      1. In the Setup stage of the playbook, select the Select alias template activity.
      2. Select a template.
        • SCCM JDBC Connection Credentials: Select to use a user name and password to establish a JDBC connection to the SCCM database.
        • SCCM JDBC Conn Cred (Integrated Auth): Select to use Windows JDBC-integrated authentication, which uses domain credentials, for authenticating a JDBC connection to the SCCM database.
      3. Select Continue.
    7. Enter connection details and test the API connection for importing Microsoft SCCM data.
      1. In the Setup stage of the playbook, select the Create and test connection activity.
      2. On the form, fill in the fields.
        Table 1. Create and test connection form
        Field Description
        Connection name Name to identify the Microsoft SCCM connection record.

        For example, SG-SCCM connection.
        Query timeout Number of seconds the JDBC driver waits for a query to complete.

        0 indicates no timeout. If the timeout is exceeded, the integration considers the JDBC result inaccessible and marks the result as an error.
        Connection timeout Number of seconds before the MID Server connection cache pool closes the connection and removes the connection.

        0 indicates no timeout.
        Host Network address of the server where the Microsoft SQL Server database is located.
        Database name Name of the Microsoft SQL Server database that SCCM uses.
        Override default port Custom port of the Microsoft SQL Server instance.

        The default port for Microsoft SQL Server is 1433
        Instance name Microsoft SQL Server instance.
        MID Server MID Server for the connection.
        Note:
        It’s required to select a MID Server for an Integrated Authentication connection.

        For the SCCM JDBC Connection Credentials option, this field appears only when you select the Use MID Server check box.
        Note:
        The following fields appear only when you select the SCCM JDBC Connection Credentials template in step 6.
        Format JDBC driver used for connecting to the SCCM database.

        SCCM uses Microsoft SQL Server as its database backend. This field is automatically set to com.microsoft.sqlserver.jdbc.SQLServerDriver. Leave the field value as is.
        Username User name for connecting to the JDBC server.
        Password Password for the JDBC server.
        Use MID Server Option to use the MID Server for accessing the JDBC server.
      3. Select Create and test connection.
      4. Once the connection test is complete, select Continue.
    8. Optional: Configure the connection and connector properties to map attributes and manage data imports.
      Note:
      To skip this step, select Continue for the Configure properties activity.
      1. In the Setup stage of the playbook, select the Configure properties activity.
      2. To map the asset tags from Microsoft SCCM to the asset tag attribute in the Computer [cmdb_ci_computer] class, in the Connection properties section of the Configure properties page, select the Map asset tags check box.
      3. To avoid creating duplicate records in the CMDB Disks [cmdb_ci_disk] table when the Discovery application is running, in the Connector properties section of the Configure properties page, select the Avoid creating duplicate records check box.
      4. To set the import disk name to the format starting with Disk #[disknumber], in the Connector properties section of the Configure properties page, select the Transform disk name to disk number check box.
        Where the disknumber is the number extracted from the disk name
      5. Select Continue.
    9. Optional: Modify the SQL statement for a data source.
      Note:
      To skip this step, select Skip for the Customize data source SQL statement activity.
      1. In the Setup stage of the playbook, select the Customize data source SQL statement activity.
      2. Double-click (or use the keyboard shortcut) the Custom SQL statement column value for a data source and enter the custom SQL statement.
      3. Repeat the step 9.b for each data source where you want to modify the SQL statement.
      4. Select Mark Complete.
    10. Configure the import schedules to import data at regular intervals.
      1. In the Setup stage of the playbook, select the Configure import schedule activity.
      2. Expand the Parent scheduled data import within the Import schedules list to select the Connection Name-SCCM Computer Identity import schedule.
      3. Select the Active check box, and then fill in the run schedule and time details.

        For more information, see Schedule a data import.

      4. Select Save.
        Alternatively, select Execute Now to execute the import schedule immediately.
      5. Select Continue.
    11. In the Setup stage of the playbook, select the Confirm connection creation activity to verify whether the connection was created.

    What to do next

    Select View all connections to review the connection details. The created connection appears in the Installed connections list.