Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Discoverer Reports query

sarah_kSep 15 2011 — edited Sep 21 2011
Hello,

I use the following query to give me a list of all discoverer reports and a run count.

SELECT a.qs_doc_owner Owner, a.qs_doc_name Workbook, count(*) run_count
FROM eul_us.eul5_qpp_stats a, eul_us.eul5_documents b
WHERE a.qs_doc_name = b.doc_name
GROUP BY a.qs_doc_owner, a.qs_doc_name--, a.qs_doc_details
ORDER BY Workbook asc

Is there any way of modifying this query to also show the date the report was last run on? I can only seem to find a created date?

Thank you

Sarah

Edited by: user11979562 on 15-Sep-2011 06:49
This post has been answered by Patrick Bacon on Sep 20 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2011
Added on Sep 15 2011
#business-intelligence-applications, #business-intelligence-foundation, #discoverer, #query, #reporting
2 comments
2,791 views