OPCFoundation/UA-CloudLibrary

Please auto-remove non-validated user account entries in DB after 7 days

Closed this issue · 2 comments

This will keep our DB clean from the recent spambots.

This is NOT possible with the ASP.Net Identity scaffolding as the registration date for users is not captured. It is however simply enough to remove the accounts manually through the following PostgreSQL query:
DELETE FROM public."AspNetUsers"
WHERE "EmailConfirmed" = FALSE;

Ran the PostgreSQL command on both the staging and prod databases. We almost have 1000 active users!