Identity Manager- How to get the information from custom attribute from View Submitted Tasks

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Customer has filled in the View Submitted Task attributes:
From Tabs tab, fill in the attributes:
- Custom column heading
- Custom column attribute

Now the customer needs to generate a Jasper report based on View Submitted Task information and add this custom attribute.

Environment

Virtual Appliance 14.x

Resolution

 At this query we are considering the 'AssignProvisioningRoleEvent', 'RevokeProvisioningRoleEvent'
 
select EVENT_NAME, EVENT_DESCRIPTION, EVENT_STATE, AUDIT_TIME, SUBJECT_USER from IMSAUDITEVENT12 where event_name in ('AssignProvisioningRoleEvent','RevokeProvisioningRoleEvent) and id in (select parent_event_id from IMSAUDITEVENTOBJECT12 where id in (select parent_object_id fromIMSAUDITOBJECTATTRIBUTES12 where ATTRIBUTE_NAME = 'imString100' and ATTRIBUTE_NEWVALUE = $P{ParameterTicket})) order by SUBJECT_USER, AUDIT_TIME