I was wondering if there is any way to check when hyperion users were created.
For example, there is a user Jsmith.
Is there any way we can check and see when the user was created in Shared Services or how long he has been using Planning/Essbase, etc.
Any suggestion is appreciated.
Is the user a native user or an AD user, as AD users are not actually created in Shared Services only provisioned, if it is a native user then the Shared Services relational tables CSS_USER, CSS_GROUP have columns CREATEDTIMESTAMP,UPDATEDTIMESTAMP
There is also CSS_PROVISIONING_INFO which holds provisioning and has CREATEDTIMESTAMP
I would suggest the provisioning and security report in Shared Services but they are pretty limited.
As it is for AD users then joining to the CSS_USERS table will not help as AD information is not stored in that table, the provisioning table holds the AD ID attribute which links back to the AD.