Query used in Identity Portal My Requests module

Products

• CA Identity Suite
• CA Identity Portal

Issue/Introduction

Is it possible to get the query used in the My Requests from the Identity Portal?

Environment

Identity Portal 14.x

Resolution

It's not possible to get all information since some data comes from the Identity Manager server, below is the query where can get the data from Identity Portal.

select request.requester as "Requested By" , reqTarget.targetid as "Target", request.REQUESTTIME as "Submit Date", request.status as "Status" , request.ID as ID   from Request request LEFT JOIN REQUEST_TARGETS reqTarget ON request.ID=reqTarget.REQUEST_ID;