Is there a way to report on 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?

Environment

CA Service Desk Manager 14.x and 17.x

All Supported Operating Systems and Database Management Systems

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