How do you query Crowd for list of groups and their members?

[Jim Groff]

I'm new to Crowd so I don't even know how to connect to the DB to run the queries?  Does this have to be done on the server or is there a remote connector?  If someone could give me a simple step by step on how to connect, I can bang out the query I believe from this information.  I just don't know how to go about connecting to the DB from a Windows box. Please pardon my ignorance.

https://confluence.atlassian.com/crowdkb/how-do-i-generate-a-csv-export-of-users-and-memberships-from-a-specific-directory-in-crowd-442271568.html

The Crowd CLI has been discontinued, I assume I could have done it from there before.  We are on 2.8

https://bobswift.atlassian.net/wiki/display/CRDCLI/Crowd+Command+Line+Interface

[Steven F Behnke · Accepted solution]

If you are trying to connect to the database directly, you need access to the database server and whatever credentials you can get that will let you run those queries. 

A better alternative would be to use the REST apis – https://developer.atlassian.com/display/CROWDDEV/Crowd+REST+APIs

[Jim Groff]

Thank you Steven.  I was able to use the following query using the rest APIs and obtained a list of users in each group.

http://mycrowdserver:8095/crowd/rest/usermanagement/latest/group/membership

It returned the group and username which was very helpful.  Is there a way to obtain all of the user information, not just the username with the query?  I could not seem to find a way to do so here:

https://docs.atlassian.com/atlassian-crowd/latest/REST/#usermanagement/1/

[Steven F Behnke]

Sorry, what user information specifically?

[Jim Groff]

The fields from the View User>Details tab in the crowd console.

Username, Directory, Email address, Active or Not, First Name, Last Name.

Thanks again Steven.

Jim

[Globallink Techops]

Super late but i use this:

/crowd/rest/usermanagement/1/group/user/direct?groupname=$group&expand=user

gives me all the user details for members of the group in the $group variable

[tiendungitd]

Hi @Globallink Techops

This command cannot output data via json?

[Marcelo L. Filho]

User in the header:

[{"key":"Accept","value":"application/json","description":""}]

[Marcelo L. Filho]

@tiendungitd my answer above...