Blocker Related to report on Historical User Login

[Arjit Gourav]

Hi Team,

I have a custom requirement related to fetch & build report on the user historical login data (No. of times user has logged into the system) for a 30 days to put at least.
To start achieving this, I tried building report on sysevent table (login/logout). However, as we get data for 7 days per the norms, any suggestions how to achieve the requirement to gather data of last 30 days?

[Slava Savitsky]

You would either need to adjust the retention period for event data or find another place to store login event information (either a custom field in [sys_user] table or a custom table).