ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF3879D2E0530100007F1FF2 DIS End User Layer Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc AR طبقة المستخدم النهائي للمكتشف D Entdecker-Endbenutzerschicht E Capa de usuario final de Discoverer F Couche utilisateur final Discoverer I Livello utente finale Discoverer JA 発見者エンドユーザー層 KO Discoverer 최종 사용자 계층 PTB Camada do usuário final do Discoverer RU Уровень конечного пользователя S Discoverer-slutanvändarlager TR Discoverer son kullanıcı katmanı US Discoverer end user layer ZHS 发现者终端用户层 0EA18BE427637C3FE06322FF578C143B select last_day(nvl(eqs.month,xrr.month)) month_end, xxen_util.user_name(nvl(xrr.created_by,eqs.created_by)) created_by, (select fu.email_address from fnd_user fu where nvl(xrr.created_by,eqs.created_by)=fu.user_id) email_address, eqs.count discoverer_count, xrr.count blitz_count, eqs.reports discoverer_reports_count, xrr.reports blitz_reports_count, sum(case when eqs.count is not null and xrr.count is null then 1 end) over (partition by nvl(eqs.month,xrr.month)) total_discoverer_only, sum(case when xrr.count is not null and eqs.count is not null then 1 end) over (partition by nvl(eqs.month,xrr.month)) total_both, sum(case when xrr.count is not null and eqs.count is null then 1 end) over (partition by nvl(eqs.month,xrr.month)) total_blitz_only, count(*) over (partition by nvl(eqs.month,xrr.month)) total from ( select distinct substr(eqs.qs_created_by,2) created_by, trunc(eqs.qs_created_date,'month') month, count(*) over (partition by eqs.qs_created_by, trunc(eqs.qs_created_date,'month')) count, count(distinct eqs.qs_doc_name||': '||eqs.qs_doc_details||' ('||eqs.qs_doc_owner) over (partition by eqs.qs_created_by, trunc(eqs.qs_created_date,'month')) reports from &eul.eul5_qpp_stats eqs where 1=1 and eqs.qs_created_by like '#%' ) eqs full join ( select distinct xrr.created_by, trunc(xrr.creation_date,'month') month, count(*) over (partition by xrr.created_by, trunc(xrr.creation_date,'month')) count, count(distinct xrr.report_id) over (partition by xrr.created_by, trunc(xrr.creation_date,'month')) reports from xxen_report_runs xrr where 2=2 ) xrr on eqs.created_by=xrr.created_by and eqs.month=xrr.month order by month_end desc, nvl2(discoverer_count,1,2), nvl2(blitz_count,2,1), discoverer_count desc nulls last, blitz_count desc nulls last, created_by Y US DIS Discoverer and Blitz Report Users Shows the user adoption for companies replacing Discoverer with Blitz Report in a phased approach. The report shows the number of Discoverer worksheets and Blitz Report executed every month per user, to help identifying the users still using Discoverer instead of Blitz Report. Enginatics &eul 1=1 2=2 1 10 1=1 eqs.qs_created_date>sysdate-:history_days Number 400 US Accessed within Days 2 2=2 xrr.creation_date>sysdate-:history_days US Accessed within Days 3 20 1=1 eqs.qs_created_date>=:date_from Date sysdate-:$flex$.accessed_within_days US Accessed After 4 2=2 xrr.creation_date>=:date_from US Accessed After 5 30 &eul <parameter_value> LOV DIS End User Layer 8E2FF36EDF3879D2E0530100007F1FF2 Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc xxen_util.dis_default_eul Y US End User Layer :$flex$.accessed_within_days Accessed within Days Accessed After