Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/19/2024 05:36 PM
Hi All,
Does anyone have a query to find out who raised the tpag request who approved them and for whom?
Regards,
09/19/2024 07:28 PM
09/19/2024 09:19 PM
Thanks - but what is the identifier for TPAG?
09/19/2024 09:35 PM
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 )