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?
Hi,
You can create a Service manually and then ask it to build the relationship between the other CI.
You can recalculate the business service or application service which will bring all the CI into SVC_CI_ASSOC.
See this: I create a relationship manually using the UI and then recalculated the Service which generated this list in SVC_CI_ASSOC.
Thanks,
Ashutosh
