How to get a list of users that has "Subscribe to all blog posts" option checked
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
目的
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
ソリューション
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.