Mapping custom attribute from SCCM to CMDB ServiceNow

Pradeep Thipani
Mega Sage

Mapping Last Reboot date attribute from SCCM to CMDB ServiceNow 

 

Step 1: Create Custom field under computer class.  

Field name: Last reboot date (u_last_reboot_date) 

Type: String or Date/Time 

You may also want to update the Form and List views for the Computer Table to also show this information. 

 

Step 2:  Add Custom SQL Statement to get data (Get the custom SQL from SCCM/DB team) 

Method-1 

  • Type SCCM in Navigator-> Open Instances under SCCM 

PradeepThipani_0-1737562670497.png 

 

  • Open the Operating system record, add custom SQL Statement. 

PradeepThipani_1-1737562670499.png

 

 

Method –2 

  • Type SCCM in Navigator-> Open Data sources under SCCM 

PradeepThipani_2-1737562670500.png

 

  • Open the SGC-SCCM Operating System record, add custom SQL Statement. 

PradeepThipani_3-1737562670501.png

 

Step-3: Mapping of attribute in ETL 

Prerequisite: Install IntegrationHub ETL plugin. 

  • Open SGC-SCCM Operation system data source.  

PradeepThipani_4-1737562670502.png

  • Follow steps 1 and 2. 
  • open the 3. Map Data to CMDB and Add Relationships 

 

PradeepThipani_5-1737562670503.png

 

 

PradeepThipani_6-1737562670504.png

 

  • Using add attribute option map the custom target field with source field (drag from right side)  

PradeepThipani_7-1737562670504.png

 

Step 4: Execute the import schedule job, Data gets updated in CMDB .

 

 

"If this response was useful, please select 'Accept as Solution' and mark it as 'Helpful.' This helps me provide better answers and assists the community ".

Regards,
Pradeep
1 REPLY 1

Manideep Arja
Tera Contributor

Great content