Discoverer change overview

This shows an overview of all the new additions or changes done to your discoverer environment

select 'New Workbooks' "Category", count(*) cnt from EUL5_DOCUMENTS
where doc_created_date between sysdate- 30 and sysdate
union all
select 'Updated Workbooks' catg, count(*) from EUL5_DOCUMENTS
where doc_updated_date between sysdate-30 and sysdate
union all
select 'Un-Used Workbooks', count(*)
from
EUL5_DOCUMENTS doc
where doc.doc_name not in
(
select distinct qs_doc_name from
eul5_qpp_stats stats
where qs_created_date between sysdate-30 and sysdate
)
union all
select 'Business Areas' "Objects", count(*) Total from EUL5_bas
union all
select 'Folders', count(*) from EUL5_objs
union all
select 'Items' , count(*) from EUL5_expressions