View all users who watching Confluence Space's blog

HI ,
I would like to know is there any way (script/sql) from which we can get list of users who all are watching spaces blog or only watching blog or have registered for watching for new blog post in the space .
https://confluence.atlassian.com/confkb/how-to-list-watchers-in-space-pages-blogposts-in-confluence-781200365.html
I have found this way but it doesnt give me details for all the three types of watcher of a space .

Hi @neetubhatt
we adapted the given SQL statement slighty by also taking into regard “CONTENTID IS NULL”. Having this, seems to be the number of Watchers of a Blog per Space.

SELECT
  s.SPACEKEY AS 'Space',
  s.SPACENAME,
  u.username
FROM dbo.NOTIFICATIONS AS n
LEFT JOIN dbo.SPACES AS s ON n.SPACEID = s.SPACEID
LEFT JOIN dbo.user_mapping AS u ON n.USERNAME = u.user_key
WHERE n.CONTENTTYPE = 'blogpost' AND **n.CONTENTID IS NULL**
GROUP BY s.SPACEKEY, s.SPACENAME, u.username

Regards, Benjamin

1 Like