Hi, We are wanting to track the usage of a group of user logins to see where accounts are not used for 6 months. The table IAM_LOGIN_EVENT looks to records login events (where name = 'SMTP_MAIL_ADDRESS'). However the system parameter "Cleanup age limit in days for Iam Events Log" is set to 3 days. The number of records in this table is already 55k in CFG and would get extremely large if the system parameter setting was changed to 180 days on a Production environment. Does anyone have any recommendations/alternative approaches please?
Thanks
Question
Tracking User Account Login Events
Hi, we used a very basic approach: we have created a custom logical unit with 2 columns: user_id, date. We have a scheduler that runs every 30 min, take a snapshot of database session view, list users there and update the previous custom logical unit with the user id and today date. Of course any duplicate will be ignored, so we have only 1 line for 1 user per day maximum. At the end of the month, it s very easy to know how many times users connected to IFS.
+8We have SSO enabled and the reports are driven from Active Directory. All the login successes and Fails are logged.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.