This content has been marked as final. Show 4 replies
Also I wanted to know if there is any APEX inbuilt tables already in there that I can query against to get these info.
Please update your forum profile with a real handle instead of "908006".
Is there any way to find out what date a page in an application is last used and by whom? This I am trying to find out for all the pages in an application. I can do that going through each page > Activity > Page views by user. But it is cumbersome to go into each page and run "By User for Page XX".This information is available through built-in reports and APEX views. See:
<li>Monitoring Activity Within a Workspace
<li>Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
<li>APEX views: Home > Application Builder > Application > Utilities > Application Express Views
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 handily suggests here.
Thanks. I will check that.