EIS Usage Summary
Description
- Categories
- EIS
EIS eXpress Reporting usage by calendar month of the run start, to estimate the number of Blitz Report licenses required for the EIS user base.
User Count is the number of distinct users who ran an EIS report in the month. User Count 60 Days is the number of distinct users in the 60 days before the month started, which corresponds to the rolling 60-day window that Blitz Report licensing is based on.
Runs count executions from eXpress and XL Connect. A scheduled run counts for the user who created the schedule. Email distribution jobs are deliveries of a run and are not counted.
EIS purges its run history, so the counts of the first retained months are understated. EIS Execution History shows the earliest retained run.
User Count is the number of distinct users who ran an EIS report in the month. User Count 60 Days is the number of distinct users in the 60 days before the month started, which corresponds to the rolling 60-day window that Blitz Report licensing is based on.
Runs count executions from eXpress and XL Connect. A scheduled run counts for the user who created the schedule. Email distribution jobs are deliveries of a run and are not counted.
EIS purges its run history, so the counts of the first retained months are understated. EIS Execution History shows the earliest retained run.
SQL 49 lines
select to_char(z.month,'yyyy-mm') month, count(distinct case when z.window_flag is null then z.user_id end) user_count, count(distinct case when z.window_flag='Y' then z.user_id end) user_count_60_days, sum(z.runs) runs, sum(z.scheduled_runs) scheduled_runs, sum(z.runs)-sum(z.scheduled_runs) ad_hoc_runs, sum(z.xl_connect_runs) "XL Connect Runs", count(distinct case when z.window_flag is null then z.report_id end) report_count from ( select add_months(trunc(y.run_date,'mm'),rowgen.column_value-1) month, decode(rowgen.column_value,1,null,'Y') window_flag, y.user_id, decode(rowgen.column_value,1,y.report_id) report_id, decode(rowgen.column_value,1,y.runs) runs, decode(rowgen.column_value,1,y.scheduled_runs) scheduled_runs, decode(rowgen.column_value,1,y.xl_connect_runs) xl_connect_runs from ( select erp.created_by user_id, erp.report_id, trunc(erp.start_time) run_date, count(*) runs, count(case when erp.start_time-ers.logon_time>1 then 1 end) scheduled_runs, count(case when erp.submission_source='XL Connect' then 1 end) xl_connect_runs from xxeis.eis_rs_processes erp, xxeis.eis_rs_sessions ers where erp.submission_source in ('eXpress','XL Connect') and erp.report_id<>-999 and erp.session_id=ers.session_id(+) group by erp.created_by, erp.report_id, trunc(erp.start_time) ) y, table(xxen_util.rowgen(4)) rowgen where (rowgen.column_value=1 or add_months(trunc(y.run_date,'mm'),rowgen.column_value-1)<=y.run_date+60) and add_months(trunc(y.run_date,'mm'),rowgen.column_value-1)<=sysdate ) z group by z.month order by z.month desc |