For instance administrators Show more
To get the mail addresses of spam bots accounts, you can try the following pgsql query:
SELECT DISTINCT ower(substring(email from position('@' in email) + 1)) AS domain FROM accounts INNER JOIN users ON users.account_id =accounts.id WHERE suspended = true OR silenced = true ORDER BY domain;
Of course, that only works if you've an instance with nice people. If not, you'll also get the mail domains used by reported regular users.
Nasqueron is a budding community of creative people, writers, developers and thinkers. We focus on free culture, ethics and to be a positive change. We share values like respect, justice and equity.