Mapping custom attribute from SCCM to CMDB ServiceNow
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2025 08:22 AM
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 .
"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
Regards,
Pradeep
- 633 Views
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2025 08:53 AM
Great content