Planning Analytics

 View Only

  • 1.  TM1 Usage details Retrieval

    Posted Tue June 04, 2019 03:06 PM
    Hi All

    Is there any way to retrieve active users, users access history for a period, inactive users from TM1 10.2.2 We have LDAP CAM 5 auth enables and auditing is not enabled .. Please suggest approaches of how can we achieve this to plan our license purchase based on usage of TM1

    Thanks
    Ajay

    ------------------------------
    Ajay Yendluru
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: TM1 Usage details Retrieval

    Posted Wed June 05, 2019 07:07 AM
    Hi Ajay,

    Audit logging is one option.  Audit logging is either on or off, so it might log a lot more detail than what you need.  If you just want to record when users login and logout you can enable a debug option for login.  Try adding the following lines to your tm1s-log.properties file.

    log4j.logger.TM1.Login=DEBUG, LOGIN
    log4j.additivity.TM1.Login=false

    log4j.appender.LOGIN=org.apache.log4j.SharedMemoryAppender
    log4j.appender.LOGIN.File=login.log
    log4j.appender.LOGIN.MaxFileSize=100 MB
    log4j.appender.LOGIN.MaxBackupIndex=20
    log4j.appender.LOGIN.TimeZone=Local 

    This will generate a login.log file in the same directory as your tm1server.log file that shows when users login and log out.  I'm not sure if it will show the username or the CAMID.

    The Planning Analytics team is looking into enhancements to audit logging that will better answer questions about which users are active in the  TM1 database (e.g last login, is the user reading or writing data, amount of time spent logged into TM1, etc).


    ------------------------------
    STUART KING
    ------------------------------

    Original Message


  • 3.  RE: TM1 Usage details Retrieval

    Posted Wed June 05, 2019 07:16 AM
    Hi Stuart,

    Thanks for your valuable insight. We have around 500 users globally logging into TM1 Web and want to know the actual usage of TM1 to determine the licensing with IBM
    My requirement is as below
    1) Analyse the TM1 user activity for the past 90 days which gives me list of users who are using/not using
    2) How much time user spent in TM1 Web
    3) Activities users are performing within their session

    I believe Audit Logging will give us the activity part and DEBUG option will only give us picture of current day usage of TM1 and not the historical ?

    Please correct me if I am wrong and guide accordingly
    Greatly appreciated

    Thanks in Advance
    Ajay

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 4.  RE: TM1 Usage details Retrieval

    Posted Wed June 05, 2019 07:33 AM
    The login debug will address your first requirement.

    It's difficult to determine how much time users spent in TM1Web based on the audit logging.  The audit logging is currently only accessible through the older Architect client tool.  We are adding REST API calls into the 2.0.8 release to access the audit logging.   We still need to do significant work in Planning Analytics Workspace to access the audit logs and generate reports that would address requirements 2 and 3. 

    I would suggest enabling and testing the audit functionality on one of the sample TM1 models to get a feel for it's capability.

    ------------------------------
    STUART KING
    ------------------------------

    Original Message


  • 5.  RE: TM1 Usage details Retrieval

    Posted Wed June 05, 2019 06:01 PM
    Hi Ajay

    The approach that we take is to use a chore to run a process every hour that checks the }ClientProperties cube to see whether the user is Active. For this to work you need to set ClientPropertiesSyncInterval=60 in your TM1S.CFG, otherwise the ACTIVE does not appear in this cube. We record the results in a cube dimensioned by Day and by Hour.

    That at least tells us which users have logged in and allows us to track that over a period of time.

    It does not however tell you what they were doing. However, from the point of view of IBM licensing that does not matter.

    As you may know the downside of Audit logging can be the overhead on the system but it can give you a bit more info.

    The other issue is that neither approach will tell you what went on in the past.

    If you want to know what went on in the past, then you could try the TM1Server.log. However, assuming normal log4J settings, that will only tell you if a user ran a process, and will not record anything if they were just viewing data or updating data in views or web sheets.

    You could also scan the TM1Transaction.log. Assuming that you have the above TM1S.CFG setting you can look back at actions on the }ClientProperties cube for the data being changed from blank to ACTIVE.

    However, if you main concern is IBM licensing then you will need to check with your Account Manager as to exactly how IBM counts users on your particular license.

    We previously had IBMs ILMT but for our licensing at that time it was more about defined users and had nothing to do with whether they had actually been active. Since upgrading to PA we changed our licensing so we no longer need ILMT, which saves a lot of time as it was a pain to implement and needed its own server.

    Regards

    Paul Simon

    ------------------------------
    Paul Simon
    ------------------------------

    Original Message


  • 6.  RE: TM1 Usage details Retrieval

    Posted Wed May 04, 2022 09:56 AM
    Hey Stuart,
    A few of my clients are trying to do a license audit based on when people log-in into PA. You had mentioned more information on logging was coming with Planning Analytics. Do you know when this will happen?

    It seems the best option auditing the log-in is via TM1 server logs. This still means a manual work in terms of tying the SSM back to Server logs, or are there other options?

    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message