Is there a way to see all users that viewed a topic? Just curious who is viewing and not replying. if there is a way, can it be locked to a certain security group?

This data is in the database but there is no UI to view it.

Since this is not an ability to use via the UI. Should this topic be moved over to the suggestions category? Thanks for replying, awesome support. Very much appreciate everyone here. Its crazy how awesome support is compared to all other companies, this is what sets Discourse apart from others on top of the forum itself. great , great, great!!!

We are looking at this for personal messages, specifically, where staff can check to see who has seen important messages.

I see there’s be no message traffic on this post for some time. And, there is still no ability to see who has viewed posts. I can understand why this might be a bit unwieldy is lots of people viewed a particular topic, but if the list was small, it would be good a moderator to be able to see who looked and did nothing more. IMHO.

I don’t know how much work, if any, has gone into making this a feature. But if you use the Data Explorer plugin you can query the topic_users table to find out who has seen a topic. Maybe JOIN with the posts table to see who has visited the topic and who has posted a reply in it?

Hi，Jeff， Someway，how can we see what topic some user have viewed？ thank you

Yes, you can do this with the Data Explorer Plugin; which means, only staff can do it.

thanks，it helps me。:smiley:

[image] tophee: Yes, you can do this with the Data Explorer Plugin I’ve got a Data Explorer query for this (which shows username to enable csv / groups / pms stuff): -- Who viewed this topic? https://meta.discourse.org/t/see-who-viewed-topic/29277/11 -- [params] -- int :topic_id SELECT tu.user_id, u.username, total_msecs_viewed/1000 AS seconds_viewed FROM topic_users tu JOIN users u ON tu.user_id = u.id WHERE tu.topic_id = :topic_id AND total_msecs_viewed > 0 GROUP BY tu.user_id, u.username, tu.total_msecs_viewed ORDER BY tu.total_msecs_viewed desc If it is okay in your context to reveal email addresses, then I suggest this one instead: -- Who viewed this topic? With emails. https://meta.discourse.org/t/see-who-viewed-topic/29277/11 -- [params] -- int :topic_id SELECT tu.user_id, email, total_msecs_viewed/1000 AS seconds_viewed FROM topic_users tu JOIN user_emails ue ON tu.user_id = ue.user_id WHERE tu.topic_id = :topic_id AND total_msecs_viewed > 0 GROUP BY tu.user_id, ue.email, tu.total_msecs_viewed ORDER BY tu.total_msecs_viewed desc

See who viewed topic

Community Building Data & reporting

downey (Michael Downey) May 26, 2015, 8:46pm 3

This could be a nice item for the admin/wrench menu some day…

Topic		Replies	Views
Can I see who viewed a specific topic in Discourse? Data & reporting	3	273	July 8, 2025
For one topic, how do I see who read it and see the location of the users? Product Support	1	348	February 22, 2024
Is it possible to see the topics a user has viewed? Data & reporting sql-query	3	1880	June 21, 2020
Reading Confirmations Feature	3	259	November 12, 2024
See who is watching a topic Data & reporting sql-query	3	941	February 13, 2023

See who viewed topic

Related topics