FND User Login Summary

Description

Categories
Enginatics
Repository
GitHub
Active application user count per month

SQL 9 lines

select distinct
trunc(fl.start_time,'month') month,
count(distinct fl.user_id) over (partition by trunc(fl.start_time,'month')) user_count
from
fnd_logins fl
where
1=1
order by
month desc

Parameters 4

ParameterTypeList of values SQL
Logged in within DaysNumber
fl.start_time>=sysdate-:days
Date FromDate
fl.start_time>=:date_from
Date ToDate
fl.start_time<:date_to+1
Exclude User NameLOV
fl.user_id<>xxen_util.user_id(:exclude_user_name)