Initially I thought about some special SQL request through GitHub - discourse/discourse-data-explorer: SQL Queries for admins in Discourse · GitHub but I havent played with it yet. From a first guess the data explorer is more useful for information about overall user activity statistics, but not for getting the content (or links to the content) itself.
And I assume that any SQL request still does not solve the functionality that I would need some kind of formatted output (content and/or links to the “real messages/threads”).