Difference between svc_ci_assoc and cmdb_ci_rel

[kcf]

can you please tell me the difference between svc_ci_assoc and cmdb_ci_rel tables in ServiceNow.

[DaveHertel · Accepted solution]

Hi - CMDB_REL_CI is the primary relationship table for the cmdb.  The dependency maps use this table as well as any relationships depicted between CI's is found in this relationship table.  It basically has pointers to 2 CI's (1 parent, 1 child) and a relationship type describing what 'kind' of relationship is between the 2 CI's  (depends on, runs on, etc..)

The SVC_CI_ASSOC table was introduced when service mapping product became a thing... its tracking which CI's belong to a given Service.  In the example below, the service ID field has been grouped, and you can see the (number) indicates the number of CI's associated with the service

Hope this helps?

[SwarnadeepNandy]

Hi Dave,

Thanks for your answer.

If I understand correctly. If I have to perform Service Mapping and show the Business Service to CI relationships(in dependency map), I have to populate both the tables(cmdb_rel_ci and svc_ci_assoc).

Is this correct understanding?

Regards,

Swarnadeep Nandy

[Ashutosh Munot1]

Hi,

Are you doing this manually?

Thanks,
Ashutosh

[SwarnadeepNandy]

The relationship is coming from an upstream system as of now, but not discovered.

How these records are getting populated in the upstream system - honestly I am not aware.

Regards,

Swarnadeep Nandy