TM1 Logs

[jyotish84]

Hi,

I want to know the names of the users who accessed TM1 on the past 3 months. How do I get that list.
We use TM1 Web and TM1 Perspectives. I am required to provide a list of active users in both Web and Perspectives.

Please advice.

Thanks
Jyo

[jim wood]

This depends on the level of logging set. If you have it set correctly then you can glean the information from the TM1slog files. Again it depends if you have archived these files. As for web it depends on the version you are running. My advice would be to hit the admin guide to some of the fundamental knowledge you need to complete this,

Jim.

[lotsaram]

Check this post http://www.tm1forum.com/viewtopic.php?p=28657 this will produce what you need without you having to lift nary a finger provided that your server configuration file includes a value for the ClientPropertiesSyncInterval parameter and transaction logging is enabled for the client properties cube. If it doesn't and you're not using the audit log (which hardly anyone does) then you're stuffed as there is no way to capture this retrospectively without said client properties sync parameter switched on.

For a more enterprise solution look at Pulse for TM1 (disclaimer; I do work for the company that makes this)