Script for Discoverer Report Names??

Reddy007

Hi friends,

We are trying to Extract the discoverer Scripts, from application but it is taking too long time in order to achieve this and even Tool is responding slow.

Please provide query to find out discoverer report name is assigned to which responsibility and user(we are able to view the all  folder names)...??? So that we can Navigate to particular responsibility and take scripts

We are using :

OracleBI Discoverer 10g (10.1.2.3)

Thanks in Advance....

Reddy007

Please reply me Anybody as this didn't got solved yet...??

GreenMachine

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_secs",

            ROUND (AVG (qs_act_elap_time) / 60, 2) "AVG_mins",

            COUNT (*) "Often",

            doc.doc_created_date,

            MIN (acc.qs_created_date) "First",

            MAX (acc.qs_created_date) "Last_Access"

       FROM eul5_documents doc,

            apps.fnd_user usr,

            eul5_qpp_stats acc,

            (SELECT DISTINCT gd_doc_id

               FROM eul5_access_privs) privs,

            (SELECT DISTINCT doc.doc_id, ba.ba_name ba

               FROM eul5_documents doc,

                    eul5_elem_xrefs eex,

                    eul5_ba_obj_links bol,

                    eul5_objs obj,

                    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;

Reddy007

Thankyou for your response.

Raju1225

the table eul5_access_privs resp information to pull workbooks list .