How to implement relationship between cis in cmdb_rel_ci

[vamshi2]

Hi Team,

Anyone please suggest how to import records in cmdb_rel_ci table

i have data like connects to, is served by in excel

Thanks & Regards,

ramu

[Dr Atul G- LNG]

Hi @vamshi2 

It's 3 step

1. Bring the source CI in CMDB ( Parent)

2. Bring the target CI in CMDB (Child)

3 Then get the relationship in cmdb_rel_ci and create a transform map and run the map. Make sure the parent and child CI name must match with cmdb data. 

[vamshi2]

Hi @Dr Atul G- LNG 

Thank you so much for quick reply 

i try to import the data (for example new ci type as "requires" ,"is authorized by",..) using transform map in cmdb_rel_ci table i am facing below error as the ci type is not available in  "cmdb_rel_type" 

"Operation against file 'cmdb_rel_ci' was aborted by Business Rule 'Prevent Recursion in CI Relationships^50fa16a3475dd290535ad38a516d43c3'. Business Rule Stack:Prevent Recursion in CI Relationships" 

could you please advice 

[Dr Atul G- LNG]

Hi @vamshi2 

Try to create this relationship manually and see did you get errro?

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0813377

https://www.servicenow.com/community/developer-forum/how-to-solve-operation-against-file-cmdb-rel-ci...

[vamshi2]

Hi @Dr Atul G- LNG 

Thank you for quick reply

i have tried creating manually and the record is not creating 

it is creating when we provide both parent description and child description of cmdb_rel_type but as of now transform map is on cmdb_rel_ci table which i am creating relationship if in data is not present in servicenow by using choice action create