Blitz Report License User Count

Description
Categories: Enginatics
Repository: Github
Shows the number of active Blitz Report users at evey month start (looking back the past 60 days)
Run Blitz Report License User Count and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.month,
(select count(distinct xrr.created_by) from xxen_report_runs xrr where xrr.creation_date>=x.month-60 and xrr.creation_date<x.month) user_count
from
(select add_months(trunc(sysdate,'month'),-level+1) month from dual connect by level<=ceil(months_between(trunc(sysdate,'month'),(select min(xrr.creation_date) from xxen_report_runs xrr)))) x
Blitz Report™