CA Service Management

Hi Guys, I am report dev who working on CASD reporting stuff.

I am trying to figure out the relationship between individual contact and group contact. In my envrionment, they are all in the same table called Ca_contact.

My scenario is: E.g. I have a team name "Support Team" and there are 4 support engineers under this team: they are Amy / Eric / Ben / Smith. Which column could I join and find out their relationship?

Thank you so much for your help.

With Rgds,

Eric

Hi Eric,

Yes the ca_contact table contains both users and groups. Groups have a contact_type of 2308.

The grpmem table is the one that maps individual contacts to groups.

Hope that this helps

Regards,

Gordon.

EricL123 

The following SQL query should provide a list of group members

SELECT *

FROM ca_contact CNT
JOIN grpmem GM
ON CNT.contact_uuid = GM.member
JOIN ca_contact CGR
ON GM.group_id = CGR.contact_uuid

WHERE CGR.last_name = 'T1' and CNT.inactive = 0

Just replace "T1" with your group name.

Thank you guys for your help, really appreciated and they are helpful.