Combined Account and Access Request Status Reports

[avtan (Avtandil Goginashvili)]

Which IIQ version are you inquiring about?

8.4

Share all details about your problem, including any error messages you may have received.

I want to recreate the “Account Request Report” and “Access Request Reports.” I need to combine them and add some additional fields. Could someone help identify where and how I can find the fields in these reports?
I do not want to create a Java report (datasource type=Java). I do not want recreating or changing java classes. Better to stay with filter or somewhere using SQL (HQL).
Some fields from these reports (“Access Request Status Report” and “Account Requests Status Report”) can be found in IdentityRequest object, but still there are many fields which i could not find. for example

Request Date
Description
Completion Date
Work Item Comments
Completion Comments
Approval Recommendation
Approval Recommendation Reasons
Approval Recommendation Timestamp
Access Request Recommendation
Access Request Recommendation Reasons
Access Request Recommendation Timestamp

Also in mentioned above reports there is only one approver. In our case we have several approvers (Manager, Owner of entitlement/access, special approver - based on the case).
i have checked IdentityRequestItem and WorkItemArchive but it is not clear what attributes from these objects corresponds to fields in the reports.

[Arun-Kumar]

Hi @avtan ,

You can retrieve all necessary details from the IdentityRequest object. This object allows you to access approvalSummary , ProvisioningProject , and identityRequestItem . To proceed, create a new report with a filter type to organize and display this information effectively.

 <DataSource objectType="sailpoint.object.IdentityRequest" type="Filter">

[avtan (Avtandil Goginashvili)]

thank you Arun for reply.
can you provide some example?
i am using IdentityRequest, IdentityRequestItem and WorkItemArchive for my report. i do not know how to connect to Approval and ApprovalItem objects or ApprovalSummaries (i could not find ApprovalSummary)…
any example with this objects (real working example…)…
thank you in advance