Microsoft SCCM integration 3.0 The Microsoft System Center Configuration Manager (SCCM) integration is a one direction import of SCCM data into ServiceNow's Configuration Management Database (CMDB). Scheduled imports bring relevant data from SCCM tables into the CMDB through a flat table created in the SQL database and mapped to the ServiceNow instance. The import is achieved using a JDBC connection via the MID Server. This functionality requires the Integration - Microsoft SCCM plugin and a new table in the SQL Server database. Microsoft SCCM 3.0 OverviewVersion 3.0 uses a flat transition table to gather specific data from all the SCCM tables (except the Software table).Supported versionServiceNow Microsoft SCCM integration version 3.0 supports Microsoft SCCM 2007 R2.How the version 3.0 SCCM integration works How the Version 3.0 SCCM Integration WorksTask 1: Connect to the SQL server databaseEstablish connection from within the ServiceNow Microsoft SCCM application to the SQL Server database in which Microsoft SCCM stores its data objects.Task 2: Create the flat table in the SQL server databaseA database administrator must create a new table in the SQL Server SCCM database that uses the column names from SCCM listed here.Task 3: Configure the data sourcesBefore you schedule an import of the SCCM data into the instance, configure the SCCM data sources, the SCCM flat table and the SCCM Software table to ensure that the CMDB receives appropriate data.Task 4: Schedule an importAfter data has been imported from SCCM into the SCCM Computer Info [imp_sccm_computer_info] table in the SQL Server database, schedule an import from that table into the ServiceNow instance using the default transform map provided in the plugin.SCCM transform mapThe following field mapping is provided for importing data from the SCCM Computer Info [imp_sccm_computer_info] and SCCM Software [imp_sccm_software] tables into existing fields in the ServiceNow CMDB.