Hello, This seems like the most basic of questions... how many reports do I have? I have spent large amounts of time trying to determine this and I still can't. In the end, I need to get a list of current reports that need to be converted along with the report owner's name in and Excel spreadsheet. I expect there to be a couple thousand. * I've posted to MOSC and been told to install the EUL Status Workbooks. The doc says to run the eul5.sql and eul5.eex files which were installed with Oracle Discoverer Administrator. The DBA has searched his computer and we've searched the Unix server... no files like this exist. * I've asked how to handle this without the EUL Status Workbooks since I no doubt can't get them installed on the production machine... to which the Oracle rep suggested I install it on the test system, pull the SQL from the workbook and then run the SQL against the production database to get the list. Sounds good, but without the files mentioned above, I can't do this. I asked if they could post the SQL from the workbook for me but... no response. (Can anyone reading this post it??) * I've searched and found a number of helpful individuals who offer queries into the underlying tables (which Oracle says are proprietary so there is no documentation). The queries they suggest do not work with our data. The workbook data is in the EUL5_DOCUMENTS table and the worksheet data is supposedly in the EUL5_QPP_STATS table. The stats table appears to be a log of every time someone runs a report (so you can see the owner and the actual executor of the report). Some of the problems I have encountered: I have workbooks with no worksheet and worksheets with no workbook. Furthermore, I have a user who sees a set of 6 workbooks and a total of 10 worksheets in the Discoverer Plus view... but when I query this information in the database, I only find 7 of the worksheets. (I even wrote a program to find every character based column in tables owned by DISCOVERER and searched each one for the workbook name... no luck. But I also identified these two tables are the only place where this data is stored.). Here is the query that is supposed to join the tables (notice I have joined on doc_name AND doc_owner... the queries found online only joined by doc_name but our users have some duplicated workbook names so it requires both values in order to be unique). SELECT DOCS.DOC_CREATED_BY DOC_OWNER, DOCS.DOC_UPDATED_BY DOC_UPDATED, DOCS.DOC_NAME WORKBOOK_NAME, STATS.QS_DOC_DETAILS WORKSHEET, (SELECT TRUNC(MAX(DM.QS_CREATED_DATE)) FROM EUL5_QPP_STATS DM WHERE DM.QS_DOC_NAME = STATS.QS_DOC_NAME AND DM.QS_DOC_OWNER = DOCS.DOC_UPDATED_BY) LAST_RUN, count(*) FROM EUL5_QPP_STATS STATS, EUL5_DOCUMENTS DOCS WHERE DOCS.DOC_NAME = STATS.QS_DOC_NAME(+) AND DOCS.DOC_UPDATED_BY = STATS.QS_DOC_OWNER(+) GROUP BY DOCS.DOC_CREATED_BY, DOCS.DOC_UPDATED_BY, DOCS.DOC_NAME, QS_DOC_DETAILS, STATS.QS_DOC_NAME ORDER BY DOC_UPDATED_BY, COUNT(*), LAST_RUN DESC, DOCS.DOC_NAME; Any new suggestions or assistance would be really appreciated. Thanks.