- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2018 04:30 AM
Hi,
We have configuration items in our CMDB.
We want to update them.
We are going to export this table and then update the excel file in order to import again.
which field is used for the merge? Because the name of the ci will be potentially modified
Can we export the sys_id and the used in the transformation table during the import?
Thank you for your help
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2018 06:53 AM
You need to go to the list view right click on it -> Import -> Update -> Create Excel Template
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2018 04:43 AM
Yes, you can use the sys_id (coalesce = true )for updating the records.
But I guess there will be huge records.
Thanks
Shashikant
Hit Helpful or Correct on the impact of response.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2018 04:46 AM
Thank you for the reply
but how i can export the sys_id of CI records

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2018 05:11 AM
Hi,
Follow the following steps to move cmdb records from Env1 to Env2 with same sysID.
1) Go in the list of cmdb records and apply any filter if needed
2) Right click on the header Export-> XML
3) The records will be downloaded in an XML file with sys_id of the respective records
4)Go to Env2 and search 'Retrieved Update set' and click on 'Import Update set from XML' in related link and upload that file
5) Commit the update set
Let me know in case of any issues.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2018 06:46 AM
Hi
I don't want to add record in a new environnement.
i would like to update Ci record but i don't know how i can export the records with sys_id and class