Which users and when are they using Discoverer?

I just got a question from a colleague how to get some usage information of Discoverer. Who is running what and when?

This question can be answered by using a little bit of SQL to query the End User Layer (EUL) schema in the database. The query depends on the statistic table QPP_STATS of Discoverer so in order to use the below query that statistics setting of Discoverer needs to be turned on. Also note that QPP_STATS will not be updated during the use or session of Discoverer but is updated as soon as the user correctly disconnects from Discoverer, so the end of the session.

To get the required information open up your favourite SQL tool and run below query. Of course, as always, adjust the query to fit your needs. I’ve added the DISTINCT to remove multiple executions of the same query on the same day by the same user, the outer join to include users which are not having an attached HR employee record. Discoverer will log users within the tables by concatenating a # with the USER_ID.

SELECT DISTINCT 
 USERS.USER_NAME
  , STATS.QS_DOC_NAME
  , STATS.QS_CREATED_DATE
  , EMP.FULL_NAME
FROM
  EUL5_QPP_STATS STATS
  , APPLSYS.FND_USER USERS
  , APPS.HR_EMPLOYEES_CURRENT_V EMP
WHERE
  STATS.QS_CREATED_BY = '#' || USERS.USER_ID
  AND USERS.EMPLOYEE_ID = EMP.EMPLOYEE_ID(+)
  AND STATS.QS_CREATED_DATE >= '01-JAN-16'
ORDER BY QS_CREATED_DATE DESC;