cmdb ci relationship

[Rishabh Dev Kha]

Hi Everyone,

Can anyone suggest how to move ci from one instance to another, I tried using update set but relationship is not getting captured.

[Sruthi17]

Hi @Rishabh Dev Kha 

The CI relationships are generally not captured in update set. They are not treated as config changes but treated as data. So, to move the relationship from one instance to another, you have to export and import the relationship data file which is stored in "cmdb_rel_ci" table.

Please mark helpful or accept solution, if it solves your problem. Thanks!

[Robbie]

Hi @Rishabh Dev Kha,

The best way to move data and records between instances is via 'xml'. 

Simply create a filter on the table which display the records you wish to move (in your case the cmdb_ci table), and then right-click on one of the table headers and select 'Export XML'..

You'll also need to export the relationship via XML as well. This can be achieved by opening up the CI record and navigate to the relationship record. Open this and export via XML the same way (Right-click at the top of the record).

If you need to export multiple records and multiple relationships... simply open the 'cmdb_rel_ci' table and filter the table to include all the required records and export these.

One you have the exported files which will be stored locally on your machine.... go to the instance you wish to move the records to, navigate to the same cmdb_ci and cmdb_rel_ci table - right click at the top of the table and select 'Import XML' - Jobe done.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.

Thanks, Robbie

[Community Alums]

Hi @Rishabh Dev Kha ,

Please mark to export the XML and try to import it in another instance it will work.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak

[Ashok Sasidhara]

You need to move the required data from each of the specific CMDB tables in XML format followed by the required data from cmdb_rel_ci in XML format.