After the bot attacks I’ve cleaned up and implemented some additional measures thanks to some helpful users, but I’d also like to monitor the situation in case someone from my server decides to go on a spam rampage…

Is there a way to:

  1. Easily get a list of comments from all my users locally and across the 'verse?
  2. If I purge/ban these users, is there a protocol for letting other Lemmy admins know? I assume I have no power to delete things from their instances (just my copy of their instance?)
  • coffeeisnotlatte@latte.isnot.coffeeOP
    2·
    1 year ago

    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