Connector Onboarding Guide for Service Graph Connector for SCCM

[adarsh_kumar]

Purpose of Onboarding Service Graph Connector for Microsoft SCCM

Service Graph Connector for Microsoft SCCM enables you to pull Microsoft SCCM data into your ServiceNow Configuration Management Database (CMDB). This integration helps maintain accurate configuration data by importing computer systems, software, and other configuration items from your Microsoft SCCM environment directly into your CMDB.

Before you begin

• Install Service Graph Connector for Microsoft SCCM version 3.5.0 or later from the ServiceNow Store.
• Role required: cmdb_inst_admin or admin

Configuration Steps

Navigate to CMDB Workspace

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.

Complete Initial Prerequisites

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.

Update Data Source Access

1. In the Prerequisites stage of the playbook, select the Update data source access activity.
2. Select Update access.
3. To edit the record, select the Global application scope from the application picker.
4. In the Application Access related list of the Data Source form, select the Can create, Can update, and Can delete check boxes.
5. Select Update.
6. From the application picker, select the application scope of the connector.
7. After completing the Update data source access activity, select Continue.

Clear Cache

1. In the Prerequisites stage of the playbook, select the Clear cache activity.
2. Select Run clear cache.
3. In the Run script text box of the background script page, enter the following script:

   GlideTableManager.invalidateTable("sys_data_source");
   GlideCacheManager.flushTable("sys_data_source");
   GlideTableManager.invalidateTable("sys_db_object");
   GlideCacheManager.flushTable("sys_db_object");

4. Select Run Script to run the background script in the global scope. The script may take several minutes to execute.

5. After the script is executed, select Close.

6. From the application picker, select the application scope of the connector.

7. After completing the Clear cache activity, select Continue.

Select Alias Template

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 username 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.

Create and Test Connection

1. In the Setup stage of the playbook, select the Create and test connection activity.
2. On the form, fill in the fields:

   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:

   Field	Description
   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.

Configure Properties (Optional)

1. In the Setup stage of the playbook, select the Configure properties activity.
2. In the Connection properties section:
• To map the asset tags from Microsoft SCCM to the asset tag attribute in the Computer [cmdb_ci_computer] class, select the Map asset tags check box.
3. In the Connector properties section:
• To avoid creating duplicate records in the CMDB Disks [cmdb_ci_disk] table when the Discovery application is running, select the Avoid creating duplicate records check box.
• To set the import disk name to the format starting with Disk #[disknumber], select the Transform disk name to disk number check box. Where the disknumber is the number extracted from the disk name.
4. Select Continue.

Customize Data Source SQL Statement (Optional)

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 step 2 for each data source where you want to modify the SQL statement.
4. Select Mark Complete.

Configure Import Schedule

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.

Confirm Connection Creation

1. In the Setup stage of the playbook, select the Confirm connection creation activity to verify whether the connection was created.
2. Select View all connections to review the connection details. The created connection appears in the Installed connections list.

What to do next

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

NOTE: This article will be updated continuously with new setup steps being added in connector.