Categories
- All Categories
- 143 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
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
Tom0 -
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
0