Query To Obtain All Resource Timesheet Approvers

Products

• Clarity PPM On Premise

Issue/Introduction

Is there a way to obtain an accurate query of all resources that have the instance right: Resource - Approve Time
and over whom the user has rights over?

 

Resolution

The following basis query can be used as best-effort support:

select a.user_id timesheet_approver, 
b.id of_user,b.unique_name,a.permission_code
from CMN_SEC_CHK_USER_INST_V0 a,
srm_resources b,
cmn_sec_users c
where a.object_instance_id = b.id
and c.id = b.user_id
and a.permission_code = 'prApproveActuals'
--and a.user_id = 1