Historical List of Login Attempts

[MichelG]

I'm trying to get a list of all successfull und non-successful login attempts over the last 2 years. I thought I could use table sys_user_login_history to get the needed information. But it looks like all data older than 1 month is deleted from it. Does anybody know which job does the deletion / maintenance of this table and if it is possible to extend the holding time from 1 month to 2 years? 

[Anwesha3]

Hi @MichelG  
Check in scheduled script execution table. 
something similar to this " Clear sessions in Login History table for node failure " will be there. 

Kindly mark the reply as a correct answer / helpful if it helped to solve your question.

Thanks,
Anwesha

[MichelG]

Hi @Anwesha3 

Thank you for your reply. Yes, there is a job "Clear sessions in Login History table for node failure". It deletes old session data in sys_user_session where the session is longer open than 1 day and uses sys_user_login_history as reference. What I am looking for is the maintenance of the sys_user_login_history table where all entries older than 1 month are deleted.  

[MichelG · Accepted solution]

I found the following solution:

There ist a table cleaner which can be configured under
sys_auto_flush_65189cd0eb011110bd1e0c73a2522883.xml
https://my_instance.service-now.com/nav_to.do?uri=sys_auto_flush.do?sys_id=65189cd0eb011110bd1e0c73a...
The "Age in seconds" field defines how long the records are kept in the table. Default value is 2'592'000. I set it to 63'500'000 seconds which is a little bit more than 2 years.
Since the number of daily logins is manageable I don't expect any performance issues.