Please auto-remove non-validated user account entries in DB after 7 days
Closed this issue · 2 comments
barnstee commented
This will keep our DB clean from the recent spambots.
barnstee commented
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;
barnstee commented
Ran the PostgreSQL command on both the staging and prod databases. We almost have 1000 active users!