|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Product/Service Type: Enterprise Data Collector (EDC), Account Data Collector (ADC)
RSA Version/Condition: 6.9.1 and above
|Issue||The RSA Identity Governance & Lifecycle UI can show the Last Modified Date for an Application. However, underneath the covers (i. e., in the database), Applications have Creation Dates and IDs, where the Last Modified Date is (really) the Creation Date for that ID.|
So if, for example, it needed to be determined which of the Applications were recently onboarded, it cannot be done from the UI. This is because only the Last Modified Date is available, when an Application may have been onboarded in an earlier Creation Date + ID number.
Further, the ID is a sequential number for each Version of the Application, so we can treat the ID as the Version. However, please note that the ID does not start at 1 for each Application.
Finally, the Creation Date and ID (Version) is kept to maintain consistency for accounts and entitlements that were collected before a modification is made.
|Tasks||As this article will be referring to Identity and Governance Lifecycle database tables, please review the following documents, depending on the version.|
Lists all applications defined in RSA Identity Governance and Lifecycle.
The Last Modified date shown in the UI is actually the CREATION_DATE column in the T_APPLICATIONS table, for the current version of the Application record.
Historical data for earlier versions of an Application record are stored in the T_APPLICATIONS_VERSIONS table.