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

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

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

Resolution

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