--- sourceDocument: Australia ServiceNow AI Platform Capabilities sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/de-DE/servicenow-platform Release : - australia ft:locale : - de-DE ft:publication_title : - Australia ServiceNow AI Platform Capabilities ft:clusterId : - platcap bundleId : - platcap workflow : - Platform --- # Configure using SGC Central # Configure Service Graph Connector for Microsoft SCCM using SGC Central {#ariaid-title1} * Freigeben Version: Australia * * Aktualisiert 12. März 2026 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 7 Minuten Lesedauer 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. ## Vorbereitungen 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](https://www.servicenow.com/docs/access?context=t_InstallApplications&version=australia&pubname=australia-platform-administration&ft:locale=en-US). To access Microsoft SCCM data, you must have appropriate access to the Microsoft SCCM database. You must have sufficient credentials to query the SQL Server that contains the Microsoft SCCM database. You must do the following: 1. Create a SQL Server account to connect to the Microsoft SCCM database on the MID Server to use the data sources. 2. Connect to your Microsoft SCCM SQL Server and configure the following: 1. Add a new login user name and password for SQL authentication. 2. Choose the Microsoft SCCM database that ServiceNow data sources will connect to. 3. Assign the db_datareader role membership to the Microsoft SCCM user. {#sgcc-configure-sccm-integ__ol_ih3_q1f_k3c} {#sgcc-configure-sccm-integ__ol_hh3_q1f_k3c} Air gap connections are available from version 3.7.0 of the Service Graph Connector for Microsoft SCCM. You can add either standard data sources or air gap data sources. Before you set up air gap data sources, you must configure the air gap solution for the Service Graph Connector for Microsoft SCCM in your high-secure server and low-secure server. See [Configuring air gap connections for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/jEnpriGiKUa2Fb_njYhS7g "The Service Graph Connector for Microsoft SCCM supports an air gap solution for networks that are configured in a manner that doesn't support a MID agent."). Role required: The following table shows the roles required for each stage of the playbook.{#sgcc-configure-sccm-integ__table_zcy_w5p_4hc__entry__2} | Stage | Role | |-|-| | Prerequisites | admin | | Setup | SGC-Admin (sn_cmdb_int_util.sgc_admin) or admin | [Tabelle : 1. Role required for each playbook stage] {#sgcc-configure-sccm-integ__table_zcy_w5p_4hc} Hinweis: The admin user role is required to run background scripts and to provide access to global tables to the SGC-Admin user. For information about the user roles for Service Graph Connectors, see [Service Graph Connector user roles](https://servicenow-prod.fluidtopics.net/1wLEV8ubYlPM_nDUSO~F~Q#cmdb-sgc-intro__section_ett_spp_4hc). ## Warum und wann dieser Vorgang ausgeführt wird The playbook experience for onboarding connectors is activated with SGC Central in the Service Graph Workspace or CMDB Workspace. To configure the SGC Central application, see [Configuring SGC Central](https://servicenow-prod.fluidtopics.net/UnQAG~FYFjoCfIHuaKAkKw "Set up the SGC Central application for onboarding and maintaining Service Graph Connectors and monitoring the errors related to connections added using Service Graph Connectors.") and for more information on how to interact with a playbook, see [Interact with Playbook](https://www.servicenow.com/docs/access?context=playbook-ui&version=australia&pubname=australia-build-workflows&ft:locale=en-US). ## Prozedur 1. Use one of the following methods to open SGC Central: * Navigate to WorkspacesService Graph Workspace, and from the left navigation panel, select the Ingestion icon ![]() to open the SGC Central view. * Navigate to WorkspacesCMDB WorkspaceSGC Central. {#sgcc-configure-sccm-integ__choices_bd1_nrz_k3c} 2. Navigate to WorkspacesCMDB Workspace. 3. In the CMDB Workspace, select SGC Central. 4. On the Overview page, select Create connection. Tipp: Alternatively, you can select Create connection on the All connections page. 5. On the Create connection window, select the Microsoft SCCM connector type, and then select Create connection. 6. Complete the initial prerequisites when setting up a connection for the first time using a connector. Hinweis: This step is required only during the first-time setup. See [Perform initial setup tasks when creating a connection in SGC Central](https://servicenow-prod.fluidtopics.net/wlOQcTjvJsvl51egxq37JQ "Complete the prerequisites for setting up a connection for the first time using a Service Graph Connector within the SGC Central view of the Service Graph Workspace or CMDB Workspace."). 7. Select an air gap template or 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 one of the following templates. * SCCM JDBC Connection Credentials: Select this option to use a user name and password to establish a JDBC connection to the SCCM database. Hinweis: The new user must be assigned the db_datareader role membership. For more information, see [Create a database user](https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-ver15). * SCCM Air Gap: Select this option to use an air gap connection if you're working with restricted environments that don't have direct internet access (see [Configuring air gap connections for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/jEnpriGiKUa2Fb_njYhS7g "The Service Graph Connector for Microsoft SCCM supports an air gap solution for networks that are configured in a manner that doesn't support a MID agent.")). * SCCM JDBC Conn Cred (Integrated Auth): Select this option to use Windows JDBC-integrated authentication, which uses domain credentials, for authenticating a JDBC connection to the SCCM database. Hinweis: The account that runs the MID Server agent must have the db_datareader role to access the SCCM DB. {#sgcc-configure-sccm-integ__ul_yry_pp2_gcc} {#sgcc-configure-sccm-integ__substep_tk2_qgs_4gc} {#sgcc-configure-sccm-integ__substep_tk2_qgs_4gc} 3. Select Continue. * If you selected SCCM Air Gap in step [7.b](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__substep_tk2_qgs_4gc), proceed to step [8](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__step_bzt_lbh_g3c). * If you selected either SCCM JDBC Connection Credentials or SCCM JDBC Conn Cred (Integrated Auth) in step [7.b](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__substep_tk2_qgs_4gc), proceed to step [9](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__step_skd_3hs_4gc). {#sgcc-configure-sccm-integ__ul_dmz_3bh_g3c} {#sgcc-configure-sccm-integ__alias-template} {#sgcc-configure-sccm-integ__alias-template} 8. Download and run the PowerShell scripts to set up an air gap connection. The PowerShell Script Download activity appears only when you select SCCM Air Gap as the template in step [7.b](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__substep_tk2_qgs_4gc). Hinweis: Before you add an air gap connection, you must configure the air gap solution for the Service Graph Connector for Microsoft SCCM in your high-secure and low-secure servers. See [Configuring air gap connections for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/jEnpriGiKUa2Fb_njYhS7g "The Service Graph Connector for Microsoft SCCM supports an air gap solution for networks that are configured in a manner that doesn't support a MID agent."). 1. In the Setup stage of the playbook, select the PowerShell Script Download activity. 2. Select Download Airgap Scripts. 3. Run the PowerShell scripts. 4. After configuring the air gap connection, select the I have read the instructions and executed the scripts accordingly check box. 5. Select Continue. {#sgcc-configure-sccm-integ__substeps_xn1_lgs_4gc} {#sgcc-configure-sccm-integ__step_bzt_lbh_g3c} {#sgcc-configure-sccm-integ__step_bzt_lbh_g3c} 9. 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 on the form depending on the template you selected in step [7.b](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__substep_tk2_qgs_4gc): [SCCM JDBC Connection Credentials](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__li_dqk_g2h_g3c), [SCCM JDBC Conn Cred (Integrated Auth)](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__li_dqk_g2h_g3c), or [SCCM Air Gap](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__li_ncv_g2h_g3c). * For the SCCM JDBC Connection Credentials and SCCM JDBC Conn Cred (Integrated Auth) templates:{#sgcc-configure-sccm-integ__table_ahn_xtg_rmb__entry__2} | 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. Mandatory for an Integrated Authentication connection; recommended for all JDBC connections. | | Hinweis: The following fields appear only when you select the SCCM JDBC Connection Credentials template in step [7](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__alias-template). || | 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. | [Tabelle : 2. Create and test connection form] {#sgcc-configure-sccm-integ__table_ahn_xtg_rmb}{#sgcc-configure-sccm-integ__li_dqk_g2h_g3c} {#sgcc-configure-sccm-integ__li_dqk_g2h_g3c} * For the SCCM Air Gap template:{#sgcc-configure-sccm-integ__table_zxl_g3s_4gc__entry__2} | Field | Description | |-|-| | Connection name | Display name for the connection. | | Parent directory | Path of the Microsoft SCCM directory where the data is stored in your low-secure server. | | Archive data after retrieval | Option to archive data after retrieval. | | Archive path \[Optional\] | Folder where the data is to be archived if the Archive data after retrieval check box is selected. | | MID server | Name of the MID Server that you deployed in your low-secure server. See [Configure air gap solution for Microsoft SCCM in a low-secure server](https://servicenow-prod.fluidtopics.net/SyCe5Y4VWKqNrW4n~0WEWQ "Configure the air gap solution for the Service Graph Connector for Microsoft SCCM in your low-secure server after you finish the configuration in your high-secure server."). | [Tabelle : 3. Create and test connection form] {#sgcc-configure-sccm-integ__table_zxl_g3s_4gc}{#sgcc-configure-sccm-integ__li_ncv_g2h_g3c} {#sgcc-configure-sccm-integ__li_ncv_g2h_g3c} {#sgcc-configure-sccm-integ__ul_cdb_b3s_4gc} 3. Select Create and test connection. 4. Once the connection test is complete, select Continue. {#sgcc-configure-sccm-integ__substeps_p1l_fnb_gcc} {#sgcc-configure-sccm-integ__step_skd_3hs_4gc} {#sgcc-configure-sccm-integ__step_skd_3hs_4gc} 10. **Wahlweise:** Configure the connection and connector properties to map attributes and manage data imports. Hinweis: 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. {#sgcc-configure-sccm-integ__substeps_umj_3df_gcc} 11. **Wahlweise:** Modify the SQL statement for a data source. Hinweis: 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. {#sgcc-configure-sccm-integ__custom-sql} {#sgcc-configure-sccm-integ__custom-sql} 3. Repeat the step [11.b](https://servicenow-prod.fluidtopics.net/XOfmGQMQH_uZtG037u2eSg#sgcc-configure-sccm-integ__custom-sql) for each data source where you want to modify the SQL statement. 4. Select Mark Complete. {#sgcc-configure-sccm-integ__substeps_hf5_plf_gcc} 12. 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](https://www.servicenow.com/docs/access?context=t_ScheduleADataImport&version=australia&pubname=australia-integrate-applications&ft:locale=en-US#table_r53_5hm_xp). 4. Select Save. Alternatively, select Execute Now to execute the import schedule immediately. 5. Select Continue. {#sgcc-configure-sccm-integ__substeps_lf4_yvw_fcc} 13. In the Setup stage of the playbook, select the Confirm connection creation activity to verify whether the connection was created. ## Nächste Maßnahme Select View all connections to review the connection details. The created connection appears in the Installed connections list. **Zugehörige Konzepte** * [Service Graph Connector for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/t0Og3xC770jm_ubtSXcgkQ "Use the Service Graph Connector for Microsoft SCCM to pull data from Microsoft System Center Configuration Manager (SCCM) into your ServiceNow instance.") * [Accessing the connection details of Service Graph Connector for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/yWELCeIBjwwkxlQyh_cHtw#sgc-cmdb-sccm-conn "You can access the connection details of the Service Graph Connector for Microsoft SCCM in a single view using the common connection framework (CCF) included within the Integration Commons for CMDB (sn_cmdb_int_util) store app.") * [Configuring air gap connections for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/jEnpriGiKUa2Fb_njYhS7g "The Service Graph Connector for Microsoft SCCM supports an air gap solution for networks that are configured in a manner that doesn't support a MID agent.") **Zugehörige Tasks** * [Enable Software Editions in Service Graph Connector for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/v3dlz3Gv1SsVMoX8~AMS7g "Enable software editions so that you can gather edition information for products such as Adobe Acrobat, Microsoft SQL Server, and Windows Exchange Server into the Service Graph Connector for Microsoft SCCM.") **Zugehörige Verweise** * [CMDB classes targeted in Service Graph Connector for Microsoft SCCM](https://servicenow-prod.fluidtopics.net/hWi7qF7IOqbZCkRI18MXeA "When you complete setting up the connection, you can configure the integration to periodically pull data from Microsoft SCCM. The data is saved in tables that extend from the Configuration item [cmdb_ci] table.")