In which table i can find requestid number

[Vidhya]

Hi,

We are generating analytic reports of access request details. Can anyone say where does requestid number is stored. I want to fetch the request id generated

[NM]

@Vidhya if you are referring to requestkey then ars_requests table 

[rushikeshvartak]

SELECT DISTINCT substr(jbpmprocessinstanceid, instr(jbpmprocessinstanceid, '.') + 1, length(jbpmprocessinstanceid)) AS 'REQUEST ID' from ars_requests

[Vidhya]

How do we fetch approval action whether request is approved or rejected 

[Vidhya]

Thank you @rushikeshvartak