Not super easily. It can be done by querying the postgresql dabase, but there is no built-in method to do it using the browser interface at the moment. When anyone from any instance does report them, you will see the report.

Do you have an example of a query I could use? I’m a bit rusty with databases :) with an example I can get chatgpt to build me something better

I see, occasionally I get reports from local users about something elsewhere from a ‘foreign’ user… which I can then delete. I assume that’s not deleting from their server?

For example I get a report from a local user about a lemmy.ml user with a post in lemmy.world

I don’t unfortunately, I deliberately don’t log that due to some of the sensitive stuff on my own instance (we’re China based)

Yup I’ve got them, luckily 5 or more repeating numbers in their email pretty much identified 99% of them. Would you like me to send the CSV somewhere? 27k+ bots

That’s okay I found it, luckily there’s a pattern here too… I dug up 27k with repeating numbers on emails which is a good start!

Huh adminer would definitely be an easier way to do this, do you have the part of the docker-compose you used with the env vars etc?

Yeah that’s the issue I’m having, someone sent me a postgres command in DM earlier but it does seem to be a bit of a nuke/picking up ordinary users…

I could live without youtube for sure, I have more of a Reddit problem than a YouTube problem… but it seems they fixed that for me.

My lemmy instance :)

I used to self-host email with email and postfix, but I gave up with the amount of spam coming my way and moved to Proton

iamthatis (Apollo) even said he could do it with a bit more time after the initial shock, some negotiation etc, he was willing to try if Reddit would throw him anything at all so it was possible. But Reddit instead shut down all communication then lied about what happened