FND User Login Summary

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Active application user count per month
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
Parameter NameSQL textValidation
Logged in within Days
fl.start_time>=sysdate-:days
Number
Date From
fl.start_time>=:date_from
Date
Date To
fl.start_time<:date_to+1
Date
Exclude User Name
fl.user_id<>xxen_util.user_id(:exclude_user_name)
LOV
Download
Related Blitz Reports
COPY OF: FND User Login History FND User Login History XXEN: FND User Login History with Geolocation AR Unaccounted Transaction Sweep FA Additions By Source CAC Cost Group Accounts Setup CAC Shipping Network (Inter-Org) Accounts Setup ECC Procurement, Purchase Orders FND Concurrent Requests 11i
Blitz Report™