Skip to main content
Question

Is there a Record of which USERs were Logged into IFS?

  • February 16, 2023
  • 5 replies
  • 258 views

Forum|alt.badge.img+2

I’m trying to find out when USERs are typically logged in or not on the system.  Is there any way to monitor this?

 

I’m hoping for an IFS logging TABLE which logs the USER_IDs of the Users in IFS, rather than Oracle, if possible.

5 replies

Forum|alt.badge.img+9
  • Hero (Employee)
  • 79 replies
  • February 16, 2023

Hi @Craig_IFS8_to_Cloud 

Auditing functionality is available from 21R2 release for IFS Cloud version.

However you can try below things used by some other customer.

https://community.ifs.com/distribution-crm-commerce-39/aurena-logins-4707

https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/last-login-for-user-306

Thanks & Regards
Shan


Forum|alt.badge.img+2

Thank you for your swift reply.  They both sound useful, however, I need to set up the TRIGGERs in order to capture this information and we have had the problem for the last two weeks and only just found out about it, so I was hoping that there was something that has already captured this in the system.

I assumed that there would be a lot of IFS logging going on already in the background, naturally.  I guess that’s not the case.


Forum|alt.badge.img+9
  • Hero (Employee)
  • 79 replies
  • February 16, 2023

Hi @Craig_IFS8_to_Cloud 

you can get current logged users from this table.
FND_CLIENT_LOGON_TAB


Thanks & Regards
Shan


HDAL
Sidekick (Customer)
Forum|alt.badge.img+7
  • Sidekick (Customer)
  • 32 replies
  • March 10, 2023

Hi @Craig_IFS8_to_Cloud 
What about this table in IFSAPP : IAM_LOGIN_EVENT_DETAIL


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 17 replies
  • September 16, 2024

Hi ,

when i trying to use SQL to select this table in SQL Query Tool

,it shows a error msg “insufficient privileges”

and I already had set up at History Log Configuration

I have no idea how this happens. i have almost all the permission in test environment


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings