Set up and validate data source connection credentials to import Microsoft SCCM data into your CMDB.

1. Navigate to Service Graph Connector for Microsoft SCCM > Setup.
2. On the Getting Started page, select Get Started.
3. On the Service Graph Connector for Microsoft SCCM page, in the Configure the connection section, select the task Configure SCCM JDBC Connection.
4. To enter your configuration details to your Microsoft SCCM data sources, complete the following steps:
   1. On the next page, in the Configure SCCM JDBC Connection task section, click Configure.
   2. On the form, fill in the fields.

      Table 1. Microsoft SCCM data source configuration form

      Field	Description
      Database name	Name of the database.
      User name	User name for connecting to the database.
      Password	Password for connecting to the database.
      Server	Server name or IP address for the database server.
      Use MID Server	MID Server that has access to SCCM environment to access the JDBC server, if you require an integrated authentication, then check the 'User Integrated Authentication' check box.
      Instance name	Name of the database instance, leave the field empty if you're using a default name.
      Database port	Port of the database server, enter 1433 as a default port.
      Connection timeout	Number of seconds before the MID server connection cache pool closes the connection and removes it. Zero means no timeout.
      Query timeout	Number of seconds the JDBC driver waits for a query to complete. Zero means no timeout. If the timeout runs out, the integration considers the JDBC result inaccessible and places it in an error state.

   3. Click Save.
   4. In the Configure SCCM JBDC Configuration task section, click Mark as Complete.
5. In the Validate data sources task section, click Configure and complete the following steps:
   1. Review the fields on the Data Source form, which are automatically set.

      There is no need to update any values on this page. The data source is pre-configured to use the SCCM JDBC Connection that you set up in the previous step.

      Table 2. Data Source form

      Field	Description
      Name	Unique name of this data source.
      Import set table label	Label of the table that will be created for this data source.
      Import set table name	Name of the table that will be created for this data source.
      Type	Data storage type of the data to be imported.
      Use MID Server	MID server to use to access the JDBC server.
      Format	Format of the data file.
      Instance name	Named instance for SQLServer.
      Database name	Name of the database.
      Database port	Port of the database.
      Application	Application containing this record.
      Use integrated authentication	Windows JDBC integrated authentication.
      User name	User name for connecting to the JDBC server.
      Password	Password for the JDBC server.
      Server	Server name for the JDBC connection.
      Query	Query type. Query all data from a table or run a specific SQL statement.
      Query timeout	Number of seconds the JDBC driver will wait for a query to complete. Zero means no timeout. If timeout is exceeded, the integration considers the JDBC result inaccessible and places it in an error state.
      Connection timeout	Number of seconds before the MID server connection cache pool closes the connection and removes it. Zero means no timeout.
      SQL statement	SQL statement to extract the desired data from the database.
      Use last run datetime	Controls the amount of data that is retrieved from a database during an import run. If unselected, then all rows in the table specified are imported, every time. You might want to use this setting if this is a one-time import, or if all the data in the target table is new. If selected, two additional fields appear, enabling you to select a datetime value to limit imported data to delta values only.

   2. Click the Test Load 20 Records related link to validate your data sources.
      Note: If the completion code is Success, mark this step as complete. If the completion code is Error, there is an error in the SCCM JDBC Connection that you must fix.
   3. In the Help sidebar, click Back to Guided Setup.
   4. In the Validate data sources task section, click Mark as Complete.
6. In the Reset 'Last run datetime' in test load source task section, click Configure and complete the following steps:
   1. Select the Last run datetime field and delete the value.
   2. Click Update to save the change and return to the Configure the connection page.
7. On the left side bar, click the Set up scheduled import jobs button.
8. On the Service Graph Connector for Microsoft SCCM page, in the Set up scheduled import jobs section, select the task Configure scheduled jobs.
   1. In the Configure scheduled jobs task section, click Configure.
   2. On the form, fill in the fields.

      Table 3. Scheduled Data Import form

      Field	Description
      Name	Name of the scheduled job.
      Data source	Data source record that defines the data to import.
      Run as	Option to run the scheduled job with the credentials of the specified user.
      Active	Option to activate the scheduled job. Select this option.
      Concurrent Import	Function that loads the data from multiple import sets. The function then processes and transforms the data concurrently.
      Partition Method	Partition method for the concurrent import set.
      Partition Size	Import set size for early scheduling.
      Execute pre-import script	Option to specify a script to run before the import is performed.
      Execute post-import script	Option to specify a script to run after the import is performed.
      Application	Application that contains this scheduled job.
      Run	Frequency of running the import.
      Conditional	Conditions under which this job is executed.

   3. Click Execute Now.
   4. In the Configure scheduled jobs task section, click Mark as Complete.

Run a script and pull records to update from the Microsoft SCCM 2016 plugin to the Service Graph connector for Microsoft SCCM.

1. Deactivate the scheduled imports from the older SCCM plugin. For more information on how to deactivate scheduled imports, see Upgrade the SCCM integration version.
2. To run the fix scripts, complete the following steps:
   1. Type in Fix Scripts.
   2. In the application scope, run the fix script with the name: SCCM Add Dependent Relationships.
      Note: If there are no Disk or Network Adapter records in the CMDB instance, click Proceed or have it run in the background.
   3. Select Active to activate the script then Update.
   4. When the script is finished, confirm that there are relationship records for Disk and Network Adapter CIs created in the CI Relationship [cmdb_rel_ci] table.
3. Execute a full pull of the computer records using the Service Graph connector for Microsoft SCCM before running software data or any other data source. To pull the records, complete the following steps:
   1. Navigate to Service Graph Connector Microsoft SCCM > Data Sources.
   2. In the Data Sources list, select the SG-SCCM Computer Identity data source.
   3. Confirm the Last run datetime field is empty. If not, edit the data source and clear the field then select Update.
   4. Navigate to Service Graph Connector Microsoft SCCM > Import Schedules.
   5. In the Scheduled Data Imports list, select the SG-SCCM Computer Identity scheduled data import and select Execute Now.
   6. After completing the steps, verify all the computer records with a non-empty Correlation ID have a Discovery Source value. If some computer records are left with no discovery source but have a non-empty Correlation ID, these records are from the legacy SCCM plugin. These records must be updated with SG-SCCM as the discovery source.