+5
Hi all,
Is there anyone know how to create quick report that shows login details of users who belongs to one role
Ex: there is a role : ‘economy ‘ and it uses by 10 people. We want to see the login details of that 10 users, want to know who logs in as economy and when.
Can we create a quick report to show those details or is there another way to do this one?
kindly give your opinions.
Thank You
sara
Best answer by Shan Peiris
View originalHi
you can use below SQL Querry for find users who belongs to role “economy”
select a.identity,
a.description,
a.active,
b.role,
ifsapp.fnd_user_api.get_last_activity(a.identity) last_login
from ifsapp.fnd_user a JOIN ifsapp.fnd_user_role_runtime b
ON a.identity=b.identity
WHERE b.role=’economy’
Thanks & Regards
Shan
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
