Skip to main content

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

Hi @sara19 

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

Reply


Terms & ConditionsCookie settings