Audit requirements - user login creation datestamp

Post Reply
User avatar
Ajay
Regular Participant
Posts: 183
Joined: Wed May 14, 2008 8:27 am
OLAP Product: TM1
Version: 10.2.0, PA 2.0.9
Excel Version: 2016
Location: London

Audit requirements - user login creation datestamp

Post by Ajay »

Hi All

It is that time when auditors are crawling around and i need to provide some kind of record to show when user logins were created on the system.

I've looked through the control cubes but couldn't find a specific one which shows when a login is created.

Any ideas ?

Thanks
Ajay
Alan Kirk
Site Admin
Posts: 6644
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Audit requirements - user login creation datestamp

Post by Alan Kirk »

Ajay wrote:Hi All

It is that time when auditors are crawling around and i need to provide some kind of record to show when user logins were created on the system.

I've looked through the control cubes but couldn't find a specific one which shows when a login is created.

Any ideas ?
You won't find it in any of the cubes. I haven't examined all of the new metadata logging in 9.4 yet, and there may be something specific in there... but then, you aren't on that version anyway.

Failing that, probably the best way of finding it is to search the log files for all instances of a change in the Password element of the }ClientProperties cube. (Assuming that you don't let them have their login without a password, or the sods will never add one!) It should be a simple case of then filtering out the oldest change (which will probably be by an Admin rather than the user) which will tell you when the account was created.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply