How to update the imLastLoginDate, imCreationDate, and imLastModifiedDate attributes

Products

• CA Identity Suite
• CA Identity Manager

Issue/Introduction

This article describes how to manage the imLastLoginDate, imCreationDate, and imLastModifiedDate attributes in case you need to generate a Report with these attributes.

Environment

Identity Manager 14.4.x

Resolution

1. For "imLastLoginDate" attribute, see the KB article below where you have the information about the last login date.

https://knowledge.broadcom.com/external/article/13116/how-to-extract-user-login-information-fr.html

 

2. For "imCreationDate" and "imLastModifiedDate", check if these attributes exist in the Policy Xpress (PX).

If the attributes do not exist in the PX, user attributes, you must add them in the UserStore.xml file.

 

3. After checking the attributes in the PX, you must create a PX to update these attributes every time a new user is created or modified.

You can use the PX to get the Time and Date > Today > using the LONG format, this is the compatible format to update the Snapshot database.

 

4. After setting these attributes you will see in the UserStore the attributes populated as follows:

 

5. After running a Snapshot to capture the user data, the imruser6 table has the date populated

Additional Information

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.

https://knowledge.broadcom.com/external/article?articleId=277557