Find user-owned spaces

[Ferdi D]

Hello dear community, 

I have just recently taken over administration of our Atlassian-products, hence my inexperienced question. 
Just recently we verified our domain. Now I was in the process of clearing old/unused accounts. While deactivating, for 3 accounts I got the message that these accounts are the last owners/members of a space. 

Now I already looked this up but I cannot SQL for the spaces as we use Confluence Cloud. 
As the accounts had already been deactivated once, I also seem to be unable to log in as the respective users to check that way. 

Is there any other way in which I could find all the spaces a user is owner/member of?

Thanks in advance and have a great day!

[Luis Pellacani [Atlassian Support] · Accepted solution]

Hey @Ferdi D 

Welcome to Atlassian Community.

On top of @Andrii Maliuta suggestion, you can generate a Space Report, which will include all your spaces and their creators (displaying Atlassian Account ID and Name), on a CSV format. You can generate a report by following the steps below:

1. Navigate to Confluence administration by clicking on the settings wheel in the top right of the top nav bar
2. Once in Confluence administration, under the Data Management section, find the Space Reports option within the left nav
3. Once in the Space Reports feature, click on the Create Reports button in the top righthand corner, wait for your report to be created, and then click download once it's ready

You can access the space reports section directly using the URL below (just change your site name in the beggining):

• https://<YOUR-SITE>.atlassian.net/wiki/admin/space-reports

I hope this helps.

Cheers,

Luis Pellacani

[Ferdi D]

Hey @Luis Pellacani [Atlassian Support] 
This was exactly what I was looking for!
Thank you so much for your help! 

Have a great rest of your week!

[Luis Pellacani [Atlassian Support]]

Hey @Ferdi D 

It was a pleasure.

Have a wonderful week ahead.

Cheers,

Luis Pellacani

[Andrii Maliuta]

Hello @Ferdi D ,

TO find the creators of the spaces you can use Advanced search and select type = SPACE and creator = {USER};

You can try to use Script Runner (https://marketplace.atlassian.com/apps/1215215/scriptrunner-for-confluence?hosting=cloud&tab=overview) and use API to get the spaces and its owners/creators.

[Ferdi D]

Hello @Andrii Maliuta
Does this also work for already deactivated accounts?

All the best
Ferdi