How do I check which spaces have email accounts?
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Summary
To check which spaces have a mail setting in Confluence.
Solution
This database query can be run to get the spaces that have a mail setting.
1
2
3
select SPACES.SPACENAME, SPACES.SPACEKEY, BANDANA.BANDANAKEY
from SPACES, BANDANA
where SPACES.SPACEKEY = BANDANA.BANDANACONTEXT AND BANDANA.BANDANAKEY='atlassian.confluence.space.mailaccounts';
RELATED TOPICS
Updated on April 15, 2025
Was this helpful?
Still need help?
The Atlassian Community is here for you.