Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

29 thoughts on “Monitor last login time in Planning/Essbase

  • Anonymous

    Hi Celvin, Thanks for the info (very useful). One little question regarding the Log Charts: is there a reason why the interface only shows me a subset of the log entries from the Essbase.log file? For example, in the dialog box where I set the options for generating the log chart, it tells me that the earliest date stamp in the log file is Feb 25, 2013, but I know for a fact that the earliest entry in the log file is Nov, 21, 2011. Is there a way around this? many thanks, mikeCC

  • natalia

    Hello all!

    Do you knows if there is any solution to monitoring users login and logout in Hyperion Planning?
    And if the IP adress could be registered?

    Thanks a lot!
    Natalia

  • Celvin Kattookaran

    @natalia
    Login can be captured, you can read how to do that in this blog (I think you already did that.)
    only way to track unsuccessful login is check whether this line "Invoking CSS Authenticate using following context:{APPLICATION_NAME=Planning, hyperion.login.hostinfo=0:0:0:0:0:0:0:1}" is not followed by "Fetching roles list for user took time"

  • Celvin Kattookaran

    @natalia
    for logout this is the only entry that gets captured, where Primary Key is the USER_ID from HSP_USERS table.

    Propegating external event[ FROM_ID: 204d18a4 Class: class com.hyperion.planning.sql.HspPrefs Object Type: 17 Primary Key: 50001 ]
    Looking for applications for INSTANCE: []

  • Celvin Kattookaran

    @natalia Seems like you can capture IP address also 🙂

    Check in access.log of your EPM domain. E:OracleMiddlewareuser_projectsdomainsyourdomainserversyourservernamelogsaccess.log

    that'll provide you information about all the ip address that access planning

  • Maxime

    To track Planning LOGIN connections you can use hbrlaunch.log, or hbr audit as describe before.

    Actually, if a hbr is launched when a user OPEN a form(this hbr can be empty), you will be able to track user who are opening a form (without change any data).

    It is, I think an alternative to track all users who are using Planning (for reading or writing purposes).

  • Anonymous

    Hi Celvin,

    Great post. It is very helpful.
    1. Is it possible to automate log charts filter creation through Maxl,etc ?
    2. Are the custom filters and their settings retained when the logs are cleared or Hyperion services are restarted ?
    3. Is the refresh rate setting retained for "Logged users" filter after restart of Hyperion services ?
    4. When we clear the logs or log chart , is the data also cleared from database tables (serverlogdetail and serverlogid) ? If yes, is it possible to retain it ?

    Unfortunately I don't have access to dev environment to try it out. Appreciate your help.

    Thanks,
    Andy

  • Ben

    @Andy,

    Wondering if you ever received any answers for you're questions from Feb 2014?

    I'm really baffled at how rudimentary the overall Essbase logging functionality is. And that you have to conduct so many manual operations to actually extract any value from the log data. Either by:
    1) executing "generate log charts" in EAS
    2) or using jrightlog to parse the logfile data.

    Can't Essbase be configured to automatically write all events to the SERVERLOGDETAIL table?

    Such a pain!

    I do appreciate all of the folks chiming in though as to how they've addressed their own particular usage tracking hurdles.

    Much obliged,

    Ben

  • Pritesh

    Hi Celvin,

    Is there a way to track Hyperion workspace login's and specifically web analysis report usage on 11.1.2.3?

    Regards,
    Pritesh

  • Prajin

    Hi Celvin,

    I tried to extract the login info for Essbase for a period of 3 months as per business request but I don’t get an option to change the filter and duration. It’s grayed out. By default duration is weekly and filter is set to errors.Also is this only capturing the EAS console login or it tracks excel add-in & smart view login and retrievals.

    Thanks,
    Prajin

    • Celvin Kattookaran Post author

      I think this post deals with other options, like looking at logs. Also this is an old one. I guess Shared Services auditing now allows you to track login from Planning. Check that.