0 Replies Last post: Feb 10, 2012 12:22 AM by Community Admin  
Novice 44 posts since
Mar 30, 2009
Currently Being Moderated

Feb 10, 2012 12:22 AM

Oracle Discoverer Usage Reporting

To find which Discoverer reports users are running, and how many times a particular worksheet is accessed, you can run the query below on the server where Discoverer End User Layer (EUL) is located. 

To find out how many reports per user and first/last used date, run:

SELECT DISTINCT

UPPER(QS.QS_DOC_OWNER) USERNAME,

COUNT(QS_ID)REPORTS_RUN,

MAX(QS.QS_CREATED_DATE) LAST_USED,

MIN(QS.QS_CREATED_DATE) FIRST_USED

FROM EUL_US.EUL5_QPP_STATS QS

WHERE QS.QS_CREATED_DATE > '01-JAN-2011' AND

QS_DOC_OWNER IS NOT NULL

GROUP BY UPPER(QS.QS_DOC_OWNER)

ORDER BY 1;

To find out how many times a particular worksheet has been run:

SELECT

a.qs_doc_owner Owner,

a.qs_doc_name Workbook,

a.qs_doc_details Worksheet,

count(*) run_count

FROM 

EUL_US.eul4_qpp_stats a,

EUL_US.eul4_documents b

WHERE a.qs_created_date > '01-JAN-2011'  -- only recent reports

AND a.qs_doc_name = b.doc_name

GROUP BY

a.qs_doc_owner,

a.qs_doc_name,

a.qs_doc_details

ORDER BY run_count DESC

More Like This

  • Retrieving data ...