User export from groups

[Deleted user]

Hello,
how could we export users from groups in a list like excel?

Thanks, René

[Fabio Racobaldo _Herzum_]

Hi @[deleted] ,

welcome to the Atlassian community!

You have two different options to do that :

1. Use third part app https://marketplace.atlassian.com/apps/1221278/confluence-user-export?tab=overview&hosting=server
2. Perfom an export through a DB query

Hope this helps,

Fabio

[Srinatha Tondihal]

Hi @[deleted] , Adding to @Fabio Racobaldo _Herzum_  point above. The query to extract the users from the database is as follows. 

copy cwd_user(id, user_name, lower_first_name, lower_last_name) to '/tmp/confusers.csv' delimiters',' CSV HEADER;

I hope the above info helps. 

Thanks,

Srinath T

[Deleted user]

Hello Srinath, 

I am just a user with a little more privileges. 
Where can I enter your query?

cheers René

[Fabio Racobaldo _Herzum_]

@[deleted] this is a query that should be run at DB level. You need to speak about that with a database owner.