Last Logged in Time by User

How can I monitor the last logged in time of a user?

In EAS

We 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 on EAS schema (relational database)

We 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 we are looking for an Application specific record then we 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;

Planning Login details

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

We can make use of auditing options in Planning. We can enable Auditing for Data and Business Rules. You can read more about the same in this link http://www.oracle.com/technetwork/middleware/planning/tutorials/index-091248.html

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.

Greetings

SST!