Retrieving Custom Attribute Information from View Submitted Tasks - Identity Manager

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

Generating Jasper reports for Identity Manager requires extracting specific metadata stored in the audit database. This process identifies how to retrieve values from custom column attributes configured within the View Submitted Task (VST) screens.

Environment

Identity Manager 14.5

Cause

Standard audit queries often overlook data stored in the IMSAUDITOBJECTATTRIBUTES12 table. When custom attributes are added to a task tab, they are stored as imString variables, necessitating a nested SQL join to associate the event with its specific attribute value.

Resolution

1. Log in to the Identity Manager User Console.
2. Navigate to the Tabs tab of the specific task configuration.
3. Define the Custom column heading and Custom column attribute (e.g., imString100).
4. Run the following SQL query to retrieve the data for your Jasper report:

   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         FROM IMSAUDITOBJECTATTRIBUTES12         WHERE ATTRIBUTE_NAME = 'imString100'         AND ATTRIBUTE_NEWVALUE = $P{ParameterTicket}    )) ORDER BY SUBJECT_USER, AUDIT_TIME;

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.