Skip to main content

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.

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

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.

Hi @Craig_IFS8_to_Cloud 

you can get current logged users from this table.
FND_CLIENT_LOGON_TAB


Thanks & Regards
Shan

Hi @Craig_IFS8_to_Cloud 
What about this table in IFSAPP : IAM_LOGIN_EVENT_DETAIL

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


Terms & ConditionsCookie settings