How to see Creation Date and Last Modified Date in User Profile Report or other non OOTB User Attributes.
search cancel

How to see Creation Date and Last Modified Date in User Profile Report or other non OOTB User Attributes.

book

Article ID: 277557

calendar_today

Updated On:

Products

CA Identity Suite

Issue/Introduction

How to add user attributes that are not OOTB to User profile report.

Cause

Some User attributes are not snapshotted by default if you want to add them to reports you need to do some additional steps.

Resolution

Make sure storage pattern is set to yyyyMMddHHmmss for  Creation Date and Last Modified Date.

Create custom snapshot definition for user profile report that will contain user attributes you require.

Assign this definition to the User profile report.

Run obtain snapshot for the definition created. 

Edit the report in Jasper to collect data from second table: imruser6 which contains Creationdate,modificationdate and last login date:

      ,[imr_creationdate]
      ,[imr_modificationdate]
      ,[imr_lastlogindate]

Make sure you add them to report.

Generate the report.

 

Additional Information

In Jasper reports go to reporistory - reports, right click on report "user profile" - pick open in editor - from the list pick -  main jrxml - click ok.

click on dataset and enable "show query editor"

Modify SQL query to include attributes you want to show in report:

In my case I added:

imruser6.IMR_CREATIONDATE,

imruser6.IMR_MODIFICATIONDATE,

after line 19.

 

Add Field: 

Click ... and fill the field like this:

repeat the steps for each added attribute.

 

add the attribute in text field in the report:

Expression for me is: $F{IMR_MODIFICATIONDATE}

 

Example like this: