The table IAM_LOGIN_EVENT_DETAIL_TAB - is there a cleanup routine? This is growing alarmingly

Hi @Roy Almeida,

I checked the system parameters and scheduled database tasks, but there appears to be none that will cleanup this table. There are no appropriate methods in the Iam_Login_Event_Detail_API either. I think it is best to report this through a case so that it can be directed to R&D.

Hope this helps!

sounds like a good idea...

Hi Roy,

In 23R1 there is an API in the Default Batch Queue for IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS:

There is also a System Parameter in the Security category for - Cleanup age limit in Days for IAM Events Log.  In our environment that is set for 3 days.

Hope that helps!!

Amy

IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS did not have a provision to remove rows from IAM_LOGIN_EVENT_DETAIL_TAB.

It only removes/cleans up rows from

iam_login_event_tab

iam_admin_event_tab

Per the latest from R&D:

i.e. the fix is in 22R1 SU20 .

The JIRA link is

https://ifsdev.atlassian.net/browse/PACZSECA-5619