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!
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!
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
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