Clear the login_failures table...

[harryrundles]

Hi there,

There is a system table named login_failures that tracks user login failures. Is there a safe way to delete data from this table?

Thanks!

[scutter]

Try

select clear_data_collector_collector('LoginFailures');

which clears the underlying Data Collector table dc_login_failures table.

--Sharon

[harryrundles]

Thanks, Sharon! This will help me in the future. Is there an option to clear data based on some criteria? That is, on a date?

[scutter]

Just saw my typo in my previous post - should have been clear_data_collector() of course.

The retention policy is only based on amount of data - there aren't currently any other criteria that can be used to trigger clearing it.

[harryrundles]

Sharon, thanks, again!!!