How to Automatically Build Relationships Between cmdb_rel_ci and cmdb_ci_certificate table

[Hari S1]

Hi,

I am currently working on an import process to populate the cmdb_rel_ci table. The goal is to create relationships in this table based on the data being imported, but the data is already present in the cmdb_ci_certificate table.

The challenge is we are importing the duplicate records in cmdb_rel_ci.  For example, I’m importing the records SYM10 and SYM10, which are already present in the cmdb_ci_certificate table. I want the import to build the relationship between the cmdb_rel_ci and cmdb_ci_certificate tables, but only if the records exist in cmdb_ci_certificate and without creating duplicates and update two records separatly with their relationships to be automatically populated on cmdb_ci_certificate table. How can we do that.

Thanks

[Hari S1]

Hi @everyone,

Can someone help me on this?

Thanks

[CBartram]

 Maybe use a business rule to trigger when a certificate record is added or updated - and custom logic to lookup and/or create a cmdb_rel_ci "tag" record if there's not one already there.