All discoverer folders and workbooks that you create get stored in database. You can use the below queries to find the details.
Find your Discoverer Workbook and Folder Details from Database:
select  fu.user_name owner,
doc.doc_id "Document Id",
doc.doc_name "Document Name",
doc.doc_developer_key,
doc.doc_folder_id,
doc.doc_created_by,
doc.doc_created_date,
doc.doc_updated_by,
doc.doc_updated_date,
min(qs.qs_created_date) first_acc,
max(qs.qs_created_date) Last_Acc
from disco_apps.eul5_documents doc,
apps.fnd_user fu,
disco_apps.eul5_qpp_stats qs
where '#'||fu.user_id = doc.doc_created_by
and qs.qs_doc_name=doc.doc_name
and qs.qs_doc_owner=fu.user_name
and doc.doc_created_date<qs.qs_created_date
group by fu.user_name,
doc.doc_id,
doc.doc_name,
doc.doc_developer_key,
doc.doc_folder_id,
doc.doc_created_by,
doc.doc_created_date,
doc.doc_updated_by,
doc.doc_updated_date
order by doc.doc_updated_date desc;

Find your Discoverer Workbook performance for different Business Areas:

select  ba.ba "Business Area",
usr.user_name,
doc.doc_name "Work Book",
min(qs_act_elap_time) "Fastest",
max(qs_act_elap_time) "Slowest",
round(avg(qs_act_elap_time),2) "AVG (s)",
round(avg(qs_act_elap_time)/60,2) "AVG (m)",
count(*) "Often",
doc.doc_created_date,
min(acc.qs_created_date) "First",
max(acc.qs_created_date) "Last Access"
from disco_apps.eul5_documents doc,
apps.fnd_user usr,
disco_apps.eul5_qpp_stats acc,
(select distinct gd_doc_id from disco_apps.eul5_access_privs ) privs,
(
select distinct doc.doc_id,ba.ba_name ba
from disco_apps.eul5_documents doc
,disco_apps.eul5_elem_xrefs eex
,disco_apps.eul5_ba_obj_links bol
,disco_apps.eul5_objs obj
,disco_apps.eul5_bas ba
WHERE doc.doc_id = eex.ex_from_id
AND eex.ex_to_par_name = obj.obj_name
AND obj.obj_id = bol.bol_obj_id
AND bol.bol_ba_id = ba.ba_id
)ba
where '#'||usr.user_id=doc.doc_created_by
And doc.doc_name=acc.qs_doc_name
And privs.gd_doc_id = doc.doc_id
And usr.user_name = upper(acc.QS_DOC_OWNER)
And doc.doc_created_date<acc.qs_created_date
And doc.doc_id=BA.doc_id
group by ba.ba,
usr.user_name,
doc.doc_name,
doc.doc_created_date;

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply