How to get a list of all the active and inactive(disabled users) Personal Spaces
This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Compare Atlassian cloud vs server, the contents of this article cannot be applied to Atlassian Cloud applications.
Purpose
To get a list of all personal spaces bound to active and inactive(disabled) users.
Solution
This can be done by running the following SQL query directly against the database:
Personal Spaces for Active Users
SELECT DISTINCT s.spaceid,
c.user_name,
s.spacename,
s.spacekey,
c.active
FROM SPACES AS s
JOIN user_mapping AS u ON s.creator = u.user_key
JOIN cwd_user AS c ON c.lower_user_name = u.lower_username
WHERE spacetype = 'personal'
AND c.active = 'T';
Personal Spaces for Inactive(Disabled) Users
SELECT DISTINCT s.spaceid,
c.user_name,
s.spacename,
s.spacekey,
c.active
FROM SPACES AS s
JOIN user_mapping AS u ON s.creator = u.user_key
JOIN cwd_user AS c ON c.lower_user_name = u.lower_username
WHERE spacetype = 'personal'
AND c.active = 'F';
Last modified on Apr 24, 2023
Powered by Confluence and Scroll Viewport.