Hello, I want to list all users and their groups. Actually, the script looks like this: user_accounts = gis . users . search ( ) for user in user_accounts : print ( user . firstName , ";" , user . email , ";" , user . groups ) The output should look like this: user1 ; user1@email.com ; group1, group2, group3 Without "user.groups" the skript is working. When querying "user.groups", a error appers. How do I query the groups for each user? Thank you in advance!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query groups per user

MichaelMarz

Hello,

I want to list all users and their groups. Actually, the script looks like this:

user_accounts <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>users<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> user <SPAN class="keyword token">in</SPAN> user_accounts<SPAN class="punctuation token">:</SPAN>
   <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>user<SPAN class="punctuation token">.</SPAN>firstName<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">";"</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">.</SPAN>email<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">";"</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">.</SPAN>groups<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The output should look like this:

user1 ; user1@email.com ; group1, group2, group3

Without "user.groups" the skript is working. When querying "user.groups", a error appers.

How do I query the groups for each user?

Thank you in advance!

Find more posts tagged with

Accepted answers

MichaelMarz

The issue was, that this approach needs a Level 2 Named User.

Even if a level 1 named user has the rights to see all groups and members, it is not the same with the python api.

I tested the lines with a level 2 named user and it worked. The groups are returned as array.

All comments

MichaelMarz

Hello,

thank you for this script. It worked well, but my approach needs an array per group-membership. 🙂 So it helps, but my issue was a wrong user level.

MichaelMarz

The issue was, that this approach needs a Level 2 Named User.

Even if a level 1 named user has the rights to see all groups and members, it is not the same with the python api.

I tested the lines with a level 2 named user and it worked. The groups are returned as array.

Egge-Jan_Pollé

Hi Michael Marz,

You may want to have a look at a script which I have published on GeoNet recently:

https://community.esri.com/people/EPolle_TensingInternational/blog/2019/03/21/a-quick-overview-of-group-membership-in-your-agol-organization

The script uses the ArcGIS API for Python - with groups.search() and users.search() - to get an overview of group membership within an organization. It creates a matrix - users along the y-axis and groups along the x-axis - with a 1 or a 0 to indicate wether the user is a member of the group or not. This matrix is being written to a CSV file and can be imported to an Excel spreadsheet for further analysis.

Does this serve your needs?

BR,

Egge-Jan

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.