TPAG - Who raised access to what approver details

[MM]

Hi All,

Does anyone have a query to find out who raised the tpag request who approved them and for whom?

Regards,

[rushikeshvartak]

• You can join request_access and ars_requests table to get same information

[MM]

Thanks - but what is the identifier for TPAG?

[rushikeshvartak]

SELECT a.comments,
       a.requestdate,
       Substr(jbpmprocessinstanceid, Instr(jbpmprocessinstanceid, '.') + 1,
       Length(
       jbpmprocessinstanceid)) AS requestid,
       CASE
         WHEN a.status = 1 THEN 'New'
         WHEN a.status = 2 THEN 'INPROCESS'
         WHEN a.status = 3 THEN 'COMPLETED'
         WHEN a.status = 4 THEN 'EXPIRES'
         WHEN a.status = 6 THEN 'DISCONTINUE'
       END                     'REQUEST STATUS',
       u.displayname           AS requestor
FROM   ars_requests AS a
       JOIN users AS u
         ON a.requestor = u.userkey
       JOIN request_access ra
         ON ra.requestkey = a.requestkey
WHERE  a.requesttype IN ( 16, 33 )