Monitor last login time in Planning/Essbase - Oracle

Once I had to face this question “How can I monitor the users who are not using the system?”

I modified that to “How can I monitor the last logged in time of a user?”

There are multiple ways to track user statistics in Essbase.

You can create Log charts from EAS.
You can use jrightlog to analyze Essbase log files http://code.google.com/p/jrightlog/

EAS method

You can generate Log Charts for Server (or Application) and select “Logged Users” as filter and refresh the chart.

This will upload the log entries into a table called SERVERLOGDETAIL in EAS schema (relational database).

You can then run a SELECT statement as given below against that table and it’ll give you the last login time of users.

SELECT username as “User Name”, MAX(entrydate) AS “Last Login Date”

FROM serverlogdetail where username is not null

GROUP BY username;

If you are looking for an Application specific record then you can use the below given SELECT statement.

SELECT username as “User Name”, MAX(entrydate) AS “Last Login Date”

FROM serverlogdetail where msgtext like ‘Setting application ASOsamp %’

GROUP BY username;

Jrightlog method

Download jrightlog from here. Run JRightLog.jar file and select Essbase.log and specify a target file.

You can add a filter “Logging in user” which will pull all the login records.

Sample log file

Planning Login details

There is no straight forward check if you want to check the last login time of a user in Planning.

You can make use of auditing options in Planning. You can enable Auditing for Data and Business Rules.

I’ve written something on this here https://orahyplabs.com/2012/01/how-to-check-whether-user-ran-rule.html

This was done with a different purpose, but if you enable Auditing for Data and then you can run a query as given below. (This should give the last data entry made by the user)

SELECT USER_NAME AS “User”, time_posted AS “Last Login Time” FROM HSP_AUDIT_RECORDS WHERE TYPE = ‘Data’;

Similarly you can expand the SQL to check whether a user ran a Business Rule or not and then get his Last Login details.

Just for kicks

When you perform a last login check on Planning, there can be users who logs in and just do a data check and log-off.

Unfortunately there is no means to track those users with above given methods. (they are not performing a data entry and Planning Auditing won’t be able to record those.)

So I was thinking how will I track these users.

You can enable debugging in Planning by (Won’t recommend doing this, however if you are in need) adding an entry in System Properties (DEBUG_ENABLED to true).

This will save user login information in the log file. You can use this bat file to extract the information.

Modify BASE_DIR, EPM_LOG_DIR, LOGFILE according to your environment.

I’ll post a blog on how to rotate the log files soon, so that you can archive the logs and then use that to extract the information.

HTH

Update 01/29/2016

I’ve added an option in the latest NUMSys version an option to get the last login information from Essbase.

NUMSys Web Edition + Essbase Security Viewer

I’m planning to include a command line option in coming releases which can be used to upload log files and generate the last login report.

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

Share this:

Like this:

Related

Leave a Reply Cancel reply

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