Synch custom fields from the CMDB to Entities

[Ian Jessop]

We have the need to bring a couple of True/False fields from the CMDB CIs into our entities. The empty field exists on the entities but the value is not populated. Is there a way to synchronize that data using OOTB tools or would we need to script something to do that? 

[Community Alums]

Hi @Ian Jessop ,

Unfortunately, there is no OOTB mechanism to bring in.

[GouthamAnumolu]

Hi @Ian Jessop, if you want to bring some True/False fields from cmdb ci to entities, you can introduce similar fields on entity and when those fields changes on CMDB CI, you can write a custom Business rule(sync/async) on CI which looks at the entities linked to that CI and updates the field accordingly.

You can execute BR sync or asynchronously depending on the entities in the system and entities linked to single CI.

[Aakash2]

There is no OOB solution to sync the data as mentioned. But even if tried to build the custom solution then there are very less chances of not getting into the performance issue. As cmdb can have multiple data source and may get updates very frequently from multiple sources and triggering the sync based on the cmdb updates might impact on the platform performance.

As you already have that data on CMDB, you can try to access it using DOT WALK from 'cmdb_ci' field of Entity. This will also help to reduce data duplicacy on the platform.

Ex.  Accessing 'Assigned to' field of 'Mapped App Services (cmdb_ci_service_discovered)' table from Entity record.

cmdb_ci.ref_cmdb_ci_service_discovered.assigned_to