- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-12-2014 01:30 PM
Hello, I'm fairly new to Service Now and I have not had any formal training as of yet. I am focusing on major clean up efforts I have run into problems trying to update configuration items in the system using the load data/import function. First off, can existing CI's data be manipulated or updated using load data/import sets? If yes then how can we perform the updates without creating new CI's? For example, I want to just update the location field from abc to xyc along with the status an assigned user = 3 attributes within the existing CI table. Please help - manually updating is not fun. We have not turn on AM as of yet as this is another project that is not yet slated to be scoped.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-12-2014 03:50 PM
Hi Eri,
Yes, you can use import sets to overwrite data in existing CI's by marking one of the field map entries as the coalesce field: Using the Coalesce Field - ServiceNow Wiki. If your import data source has a field that uniquely identifies the CI, simply mark it as the coalesce and ServiceNow will ensure matching CI's are updated instead of inserted.
Here are a couple wiki articles that may help:
Creating New Transform Maps - ServiceNow Wiki
Transform Map Scripts - ServiceNow Wiki
Kind regards,
Travis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-23-2016 10:07 PM
Hi,
I need your help to resolve the issue to update CIs in Servicenow from UCMDB.
Servicenow is having sccm CIs and same CIs need to be updated from UCMDB CIs.
I have achieved this using web service import set.
I have uploadd global id in service now in correlation id field and made it coalesce in import set and push job had updated existing CIs with UCMDB cis at first run. But second time it doesnot update the same CIs with same information which throws error in log saying " sys_id not found for this CIs".
But oob job from UCMDB which pushes the CIs to Servicenow(cmdb_ci_win_server table) is able to update it second time .
Please let me know the mechanism how the update take place in servicenow from ucmdb.
Regards,
Nick
