This content has been marked as final. Show 2 replies
1 person found this helpful
ryansun wrote:This information is available through APEX views. See:
I wanted to get the counts/information of users logged into a specific Apex application. Is that possible. I searched the forum and came across the object apex_workspace_apex_users. In this I don't see the application the users last logged into.
I was looking for something like
User Count last_login firstname.lastname@example.org 150 21-May-2013 email@example.com 10 22-May-2013 . .
<li>APEX views: Home > Application Builder > Application > Utilities > Application Express Views
<li>Monitoring Activity Within a Workspace
<li>Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
Note that the underlying logs are purged on a regular basis, so for the long term you need to copy the data to your own tables, as Martin suggests here.
Thanks, will try this out. Will keep the thread open just incase I have any queries.