What you could do is create a local user called "testuser". Make sure this user is not part that does not have permission to any space. Then run this SQL query.
FROM SPACEPERMISSIONS sp
JOIN SPACES s ON s.SPACEID = sp.SPACEID
JOIN user_mapping um ON um.user_key = sp.PERMUSERNAME
WHERE um.lower_username = 'testuser'
GROUP BY s.SPACEKEY
ORDER BY s.SPACEKEY;
I am sure there is a better way but.
SQL query is copied and modified from this page.
Hi my Community friends! For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs