Is there a way to report on CA Service Desk Manager (CA SDM) contacts based on their role?

Document ID : KB000011599
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Is there a way to report on CA Service Desk Manager (CA SDM) contacts based on their role?

Answer:

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."

search.jpg

 

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