Is there a way to report on CA Service Desk Manager (CA SDM) contacts based on their role?
CA Service Desk Manager 14.x and 17.x
All Supported Operating Systems and Database Management Systems
There is no CA SDM function/report to search for CA SDM contacts based on a specific role. You can search by "Contact Type" and "Access Type."
However, you could query the MDB database directly to find this information.
select A.last_name, A.first_name, A.contact_uuid
from ca_contact A, usp_cnt_role B, usp_role C
where C.name = '<ENTER THE NAME OF THE SPECIFIC ROLE>'
AND C.id = B.role_obj
AND B.contact = A.contact_uuid
For example:
select A.last_name, A.first_name, A.contact_uuid
from ca_contact A, usp_cnt_role B, usp_role C
where C.name = 'Administrator'
AND C.id = B.role_obj
AND B.contact = A.contact_uuid