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
https://communities.ca.com/message/117118756#117118756
From a portlet perspective, somewhat on similar lines, an idea exists -
"Recently/Frequently used" portlet
https://communities.ca.com/ideas/235722281
NJ
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.
SELECT R.*
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 '%***%'