How to get a list of users that has "Subscribe to all blog posts" option checked
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
In Confluence, users are able to set preference to Subscribe to all blog posts in their Notification Settings: Email Notifications
This documentation provides SQL query to get a list of all users in Confluence that has this option marked
Solution
SELECT user_mapping.username FROM notifications
JOIN user_mapping ON user_mapping.user_key = notifications.username
WHERE contentid IS NULL AND spaceid IS NULL AND contenttype = 'blogpost';
Last modified on Mar 7, 2019
Powered by Confluence and Scroll Viewport.