Oracle Transactional Business Intelligence

Need a SQL query to list all the scheduled OTBI Analsis and dashboards
Summary
We need to review and track all the OTBI reports that are scheduled via agents
Content
Having the ability to query this out helps us understand who all have scheduled the reports other wise there is no easy way for the administrator to know..
Comments
-
Hi Vishal
Have you checked the logs in OBIEE Administration>Manage Sessions or Administration>Manage Agent Sessions
It's not pretty but will show you analyses run and gives you some sort and filter options. Be careful though as you can clear the cache
Thanks
Tom -
Hi Vishal!
May I know how have you attained the resolution for this query of yours?Our business here also wants to keep track of all the BI Scheduled Reports with the timings and the recipients. With the list being long we also are trying to figure out a SQL query or a way to get it but unable to.
Thanks,
Akshay