How to find list of reports and respective roles in OTM?
Summary:
I need to find the List of the Reports and map them to the respective Roles from which they can be run.
Content (please ensure you mask any confidential information):
Using the below query I was able to find the list of the lastest Reports run:
SELECT REPORT_GID, MAX(RUN_DATE) AS LAST_RUN_DATE
FROM REPORT_LOG
GROUP BY REPORT_GID
ORDER BY LAST_RUN_DATE DESC;
Version (include the version you are using, if applicable): 25B
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0