Finding list of shared links

feature
1

Hi all,

Is there a feature/report I’m unaware of that would allow me to easily see all the outbound links included in posts on my Discourse?

Thanks!

1 Like
2

If you have data explorer, something like this might work:

SELECT topic_id, post_id, user_id, url, clicks, created_at
from topic_links
where user_id > 1
and url like 'http%'
and URL not like '%myforum.com%'
order by created_at desc
4 Likes
3

You can use the value of the internal field to check for external links.

SELECT topic_id, post_id, user_id, url, created_at
FROM topic_links
WHERE internal = false
    AND user_id > 0
6 Likes