Getting individual users details of each space in confluence

[Mugilan Sukumar]

Hi All,

 I want to know my each space individual users details in entire confluence. There is any easy way to get this data instead checking each space one by one?

Thanks in advance 

[Kishan Sharma]

Welcome to the Atlassian Community @Mugilan Sukumar If you have access to the database, you can get the details easily. Refer this link for more details on the SQL queries.

[Mugilan Sukumar]

Hi Kishan

Thanks for your response, This document is help to find for particular user mapped to different space, page etc.

But my query is want to know the space name which have individual users.

[Kishan Sharma]

Hi Mugilan, the second query on the page gives you the space keys if you provide the individual user names in the query.

[Mugilan Sukumar]

Yes, but i want vise versa, if i provide space key, it could give all the individual users of that space or individual user counts we need.