How to see Creation Date, Last Login Date and Last Modified Date in User Profile Report or other non OOTB User Attributes.
Article ID: 277557
Updated On:
Products
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 long/epoch time/ Unix time* for Creation Date, Last Login Date and Last Modified Date.
See more: https://knowledge.broadcom.com/external/article?articleId=245433
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 Creation date, modification date and last login date:
,[imr_creationdate]
,[imr_modificationdate]
,[imr_lastlogindate]
Make sure you add them to report.
Generate the report.
====
* Please be aware that for date to show correctly in Report you need to use epoch/Unix time instead of simpleDate format.
simpleDate format is expected if you want date to be used by Logical Attribute Handler - DateDisplayHandler and display and save correctly in GUI.
Additional Information
In Jasper reports go to repository - 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,
imruser6.IMR_LASTLOGINDATE
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:
Feedback
