How do I find all pages and spaces a user is watching?

[David Tsen]

I removed a user from watching a space but he's still receiving email updates "Confluence changes in the last 24 hours". How do I list all the pages and spaces a user is watching or receiving updates for?

[Dario B]

Not sure whether you are using Server or Cloud, however, for server check below documentation:

- https://confluence.atlassian.com/confkb/how-to-get-list-of-space-and-page-watches-for-a-user-802167151.html

- https://confluence.atlassian.com/confkb/how-to-list-watchers-in-space-pages-blogposts-in-confluence-781200365.html

While for Cloud, you can use the REST API endpoint to get the list of all the pages and spaces watchers:

- https://developer.atlassian.com/cloud/confluence/rest/#api-content-id-notification-created-get

- https://developer.atlassian.com/cloud/confluence/rest/#api-content-id-notification-child-created-get

Another option would be to impersonate the users and see the list of all the pages/spaces they are watching.

[Igor M.]

Hey,

User should see if he is Watching any parent pages or existing ones from his profile.

He can just click on his profile picture in top right corner and choose Watches. From there, he should be able to stop watching any page that he no-longer wishes to receive notifications about.

You can also use a SQL query to get a list of all users watching a certain problematic page

SELECT user_mapping.username,content.title,spaces.spacename
FROM notifications,user_mapping,spaces,content
WHERE notifications.contenttype='page' AND notifications.contentID=content.contentID AND user_mapping.user_key=notifications.username AND content.spaceID=spaces.spaceID

See How to list watchers in space, pages, blogposts in Confluence for more info.

Let me know if you have more questions.

Regards,

Igor

[David Tsen]

What shows when Watches is selected is minimal:

• Space Watches: blank with message "To watch pages or blog posts in spaces click on 'Pages' or 'Blog' in the space sidebar.
• Page Watches: 2 small pages

When they (and all users) receive in the 'Confluence changes in the last 24 hours' email is the Space and several tickets that they've never worked on

We're going to try the SQL query, but the issue is they're receiving the email covering space and pages that they're never worked, or subscribed to

[Igor M.]

Hey,

Thank you for clarifying that. The email you are referring to is not of the pages that user is "watching" but just daily email that you referred to in your first comment

As per notes in Email Notifications:

• Batching window: System Administrators can change the batching window for changes and comments on the same page or blog post in the Send batched notifications scheduled job. Increase the time for fewer emails or reduce the time if more immediate notifications are essential in your site.
• Recommended updates email: Confluence Administrators can set the default options for the recommended updates notification. 
  Choose the cog icon, then choose General Configuration, Click Recommended Updates Email in the left-hand panel. See Configuring the Recommended Updates Email Notification. 

So, emails they are getting most likely related to Show Changed Content, and it is sent daily because of the above settings. You can try temporarily unsubscribe from Show Changed Content. A user should still receive a daily email, but not of all pages that changed.

Let me know how it goes

Regards,

Igor

[David Tsen]

Right - it's the daily email that users are complaining about that contains content irrelevant to them

How do we stop that daily email?

It's the emails that they intentionally watch, or are tagged (i.e. with the @) that they would like only

Thanks, David

[Igor M.]

Hey,

So it's not daily as in Subscribe to daily updates, it's Show changed content sent daily as per your email notifications settings. So if you want them to stop receiving unrelated content, unsubscribe from Show changed content email notifications, or change your global email settings from cog icon, then choose General Configuration, Click Recommended Updates Email in the left-hand panel.

Regards,

Igor

[David Tsen]

Thanks

The Recommended Updates Email  'Send by Default' checkbox looks unchecked so that doesn't look like the reason

I've sent them a note to uncheck Show Changed Content so I'll do a few tests with a single user (e.g. tag them in a page, update a page they're watching) to confirm notifications are working as expected by showing only related content

[David Tsen]

The users have these checked under Email Settings: Autowatch, Subscribe to new follower notifications, Show Changed content. NOT Subscribe to daily update.

Yet they still receive the daily 'Confluence changes in the last 24 hours' email. How do we remove them from that subscription?

[Juan Camilo Ortiz]

i dont think you're right.

[David Tsen]

Thanks Juan for you helpful feedback