How do I check which spaces have email accounts?
Purpose
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.
select SPACES.SPACENAME, SPACES.SPACEKEY, BANDANA.BANDANAKEY
from SPACES, BANDANA
where SPACES.SPACEKEY = BANDANA.BANDANACONTEXT AND BANDANA.BANDANAKEY='atlassian.confluence.space.mailaccounts';
RELATED TOPICS
Last modified on Feb 23, 2016
Powered by Confluence and Scroll Viewport.