Skip to main content
Solved

See User Login Record

  • July 8, 2021
  • 3 replies
  • 666 views

Forum|alt.badge.img+8

Does anyone know a way to see how often or the last time a user has logged in to IFS Apps 10? We are managed cloud as well. If so, can you tell how you have done this?

Best answer by Sandun Madola

Hi @Ngerst ,

As I understood, you are unable to access to the database since you are a managed cloud. As Kasun mentioned above, you can refer the same thread and set up the SQL type quick reports.

For example, to get a list of currently logged in user 
SELECT * FROM FND_CLIENT_LOGON

 

SQL quick report

 

 

Quick report results

 

This topic has been closed for replies.

3 replies

Kasun Balasooriya
Superhero (Employee)
Forum|alt.badge.img+20

Hi,

 

This seems to be a duplicate of the following Thread..Have you had a look here? 

Last Login for user | IFS Community


Forum|alt.badge.img+8
  • Author
  • July 12, 2021

Thank you, although I didn’t get my answer from that thread. I did post a message back to them, we are managed cloud and don’t have access to some aspects as an on-prem service. 


Sandun Madola
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • Answer
  • July 13, 2021

Hi @Ngerst ,

As I understood, you are unable to access to the database since you are a managed cloud. As Kasun mentioned above, you can refer the same thread and set up the SQL type quick reports.

For example, to get a list of currently logged in user 
SELECT * FROM FND_CLIENT_LOGON

 

SQL quick report

 

 

Quick report results