Set the discovery source field when importing SCCM data into CMDB

This article shows how to set the discovery_source field during the one-direction import of Microsoft System Center Configuration Manager (SCCM) into the ServiceNow Configuration Management Database (CMDB). By default, SCCM data imports do not set this field in the CMDB. 

Any

1. Open the SCCM 2016 Computer Identity transform map.
2. In the Related Links, create a new field map as follows, and then submit:

• Map: SCCM 2016 Computer Identity
• Source table: imp_sccm2016_computer_id
• Use source script: ticked
• Choice action: ignore
• Target table: cmdb_ci_computer
• Target field: Discovery source
• Source script: answer = "MS SMS";