Monday, February 22, 2016

How to list discoverer documents by user access log


List user access log on discoverer documents and sheets

SELECT b.user_name Doc_Owner
               ,a.doc_name
               ,a.doc_developer_key
               ,c.QS_DOC_NAME
               ,c.QS_DOC_DETAILS
               ,d.user_name accessed_by
               ,QS_CREATED_DATE
FROM <schema name>.EUL5_DOCUMENTS a
            ,fnd_user b ,
           ,<schema name>.EUL5_QPP_STATS c ,
           ,fnd_user d
WHERE a.DOC_CREATED_BY <> 'ORACLE_APPS'
AND '#'||TO_CHAR(b.user_id) = a.DOC_CREATED_BY
AND a.doc_name = c.QS_DOC_NAME
AND '#'||TO_CHAR(d.user_id) = c.QS_CREATED_BY

ORDER BY QS_CREATED_DATE DESC 

No comments: