User export from groups

Question

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

Thanks, René

Fabio Racobaldo _Catworkx_ · Answer

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

unknown · Answer

Hello Srinath,

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

cheers René

Srinatha Tondihal · Answer

Hi @[deleted], Adding to @Fabio Racobaldo _Catworkx_  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