CI/User Relationships

[Gurpreet07]

There is a module 'CI/User relationship types' under Configuration application. We can also create relationships of ci with a user/group.

But the question is,

Where these CI/User relationships are stored ?

I'm   sure that they are not in 'cmdb_rel_ci' table . If we know that table we can use ci/user relations to assign a support owner,BS Admin (lots of references to user table) to a ci and   reduce many of the fields in child cmdb_ci tables .

[Sanjeev Kumar1]

Hi,

For All CI If you have created a "Support Owner Group" field as Reference you not need to create a relation ship.

In my case I have created a Reference field on CI and attached a Group to that CI.

because Support group may have more than 1 member for support so I recommend you to create Support group and keep Reference of that group in CI. Instead of creating Relationship B/W CI and User.

Thanks,

Sanjeev Kumar  

[vlbond · Accepted solution]

These relationships are stored in cmdb_rel_person table. They are useful when you want to link several users that perform one function for a certain CI (e.g. several sysadmins for one server).

If you are sure there will be only one user supporting a CI, then a dedicated field on a Configuration Item table would work better IMHO.

[Gurpreet07]

Thanks Bondarchik   , thats what i was looking for 'cmdb_rel_person'

[John H1]

I was trying to use the Assigned Ti field to store that value.

Should I be using something different or is there a way to use the Assigned to field?