CI Relationships (Relationship types) Defined

[trishlipe]

We are looking at setting up CI Relationships. I have tried to find a full list of the available CI relationships and a definition of each to share with our department. Can someone help point me in the right direction? Thank you.

[Rob Welsh]

I would like to see that too. As a matter of fact I'm on a call with a bunch of folks expressing frustration that this does not seem to exist.,

[Sudhanshu Talw1]

Hi,

All the relationships are avaliable at cmdb_rel_ci table.

I also suggest you to look Suggested Relationship [cmdb_rel_type_suggest] table which will give you a base to think upon. 

Although its upon you how to relate them, but following it is a good practice.

Thanks 

Hope it helps!!

[Ryan S]

That's not what I'm looking for. I want a definition of the relationship types. I can see all the relationship types the system has available and what it suggests, but nowhere can I find a definition. There are 'relationship governance rules' which suggests that choosing the wrong relationship can cause problems later on, so trying to get it right the first time.

[cmulvaney]

Hi @Ryan S!
I stumbled upon this thread and was wondering if anyone has found any definitions for relationship types. I have a list of types myself out of SNOW but no clear definitions for each one. It seems like a common problem, but hopefully, someone has found a solution. Any help would be greatly appreciated!

[Anirban Roy]

Hi @trishlipe ,

In most of the cmdb classes(or tables), relationships can be found on form, as shown below under Related Items Formatter.

This formatter is built with data coming from 'cmdb_rel_ci' table -

e.g. Our ci 'dbaix900nyc' depends on 'nyc ras nas200'  mass storage device. 

This information is stored in the cmdb_rel_ci record. Thus 2 cis are linked via a relationship type.

For bulk upload, you can load the below table

Please mark the response helpful/ correct, if it helps.

Regards,

Anirban