I am sure time and again various people have posted about how to obtain the user login information from EAS. Users Last Logon Time post by Celvin provides a good deep dive into how this is achieved across versions.
One method to tune the query Date wise ,published by Celvin is to add ORDER BY "Last Login Date" to the end of the query. So Basically, at the end of the query it should look like,
SELECT username as "User Name", MAX(entrydate) AS "Last Login Date"
FROM serverlogdetail where username is not null
GROUP BY username ORDER BY "Last Login Date";
However, this query doesn't serve the purpose in the 11.1.2.2 version.
This setting is supposed to populate the Last Login Time" column in the eas console under "Enterprise View > Administration Servers > Essbase Servers > [Hostname] > Security > Users
Add to esbase.cfg the setting: PERSISTUSERATLOGIN TRUE and then restart
the Essbase service.
No comments:
Post a Comment