Are there a set of tables that I can query that tell me if a report or portlet have been used; when and by whom?
From a report perspective, check this -
Query for reports in the library
From a portlet perspective, somewhat on similar lines, an idea exists -
"Recently/Frequently used" portlet
This is great. Thanks a LOT!!!!! This will cover identifying who/when for reports. Will this also pull in who/when for portlets, or are there similar tables to query that will give the same information for Portlets
With portlets, I believe the only way is to query the logs.
There may be a better way or an available product from a third party to do this for you.
This is the basis for a report runs query.
FROM CMN_SCH_JOBS J
INNER JOIN CMN_SCH_JOB_RUNS R ON R.JOB_ID = J.ID
INNER JOIN CMN_SCH_JOB_RUN_PARAMS P ON P.JOB_RUN_ID = R.ID
WHERE NAME LIKE '%***%'
Retrieving data ...