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
- Open the Operating system record, add custom SQL Statement.
Method –2
- Type SCCM in Navigator-> Open Data sources under SCCM
- Open the SGC-SCCM Operating System record, add custom SQL Statement.
Step-3: Mapping of attribute in ETL
Prerequisite: Install IntegrationHub ETL plugin.
- Open SGC-SCCM Operation system data source.
- Follow steps 1 and 2.
- open the 3. Map Data to CMDB and Add Relationships
- Using add attribute option map the custom target field with source field (drag from right side)
Step 4: Execute the import schedule job, Data gets updated in CMDB .
