User sign-on log?

Hi @jokasper 

I am afraid I didn’t catch your requirement. Could you define it more precisely?

I’m sorry, I meant, sign in by UserID.  If a UserID is XYZ, is there anyway of looking up to see if XYZ has ever logged into IFS?

Thanks,

Jo

Hi @jokasper 

yes, it is.

Check this screen.

Thank you…. I did check this screen and it looks like it goes back about a short time frame….maybe a day or two.  Can this be controlled somewhere for more history?

Jo

Hi @jokasper 

usually it works. You can search by user. Then see the column last call.

Here is the view:

select * from ifsapp.fnd_session_runtime
where status = 'INACTIVE'
and fnd_user not like ' '

Hi,

If you use database authentication and are only interested in IEE logins you can check Fnd_User_api.Get_Last_Activity() which gets last_login from table dba_users

select t.IDENTITY "Identity", t.DESCRIPTION "User Name", Fnd_User_api.Get_Last_Activity(t.IDENTITY) "Last Login"
from FND_USER t
order by t.IDENTITY

BR

Johan

select t.IDENTITY "Identity", t.DESCRIPTION "User Name", IFSAPP.Fnd_User_api.Get_Last_Activity(t.IDENTITY) "Last Login"
from FND_USER t
order by t.IDENTITY

Hi @JohanLindstrom 

I couldn’t find the table DBA_USERS. It is available in IFS APP 10?

select t.IDENTITY "Identity", t.DESCRIPTION "User Name", IFSAPP.Fnd_User_api.Get_Last_Activity(t.IDENTITY) "Last Login"
from FND_USER t
order by t.IDENTITY

Hi,

sys.dba_users is an oracle system view and should be available. Maybe someone else can shed light on why it is or isn’t

BR

Johan

Thank you for your help!  The FND_USER query works for us….thanks again!