How to export pending approvals into Excel/CSV Format.

[ranudeepreddy]

We have a scenario where there are pending approvals which are expired as we didn't run an utility job yet. How to archive/export that data? (This could help to keep track/ save the data before clearing).

I couldn't see any option to export data in pending approvals tab.

Is there any query to run in Data Analyzer? - to fetch this data?

[rushikeshvartak]

Query : Expired request 

select ar.REQUESTKEY,username as REQUESTOR,ar.REQUESTDATE
from ars_requests ar join request_access ra on ra.requestkey=ar.requestkey join access_approvers aa on aa.request_access_key=ra.request_accesskey join users u on u.userkey = ar.REQUESTOR where ar.status in (4)

JOB  to archive Request Data:  Admin - Job Control Panel - Utility- ArchiveJob

[Srinivas]

Hi Ranudeep

Yes we can have an analytics for the same and then export it. At times you can also set up a dashboard and download it.

Thanks & Regards

Srinivas