TMACUL

CA SDM - SQL select group member

Blog Post created by TMACUL Champion on Sep 17, 2015

Do you need select CA Service Desk group member´s?

 

Maybe, this SQL command can be helps.

 

SQL COMMAND

select grp.last_name as group_name, cnt.last_name, grpmem.manager_flag, grpmem.notify_flag

from mdb..grpmem

inner join mdb..ca_contact as grp on grpmem.group_id = grp.contact_uuid

inner join mdb..ca_contact as cnt on grpmem.member = cnt.contact_uuid

Outcomes