Using ListUsers—Help | ArcGIS Desktop as my reference I'm trying to get a list of users connected to an eGDB that I can iterate through. The online help page suggests: # Set the admistrative workspace connection arcpy . env . workspace = "Database Connections/tenone@sde.sde" # Create a list of users ''' NOTE: When the arcpy.env.workspace environment is set, a workspace does not need to be provided to the function. ''' users = arcpy . ListUsers ( ) However, my attempt errors out: >> > arcpy . env . workspace = r 'I:\PathTo\SdeUserConnection\sde@My.sde' >> > users = arcpy . ListUsers ( ) Runtime error Traceback ( most recent call last ) : File " " , line 1 , in module > TypeError : ListUsers ( ) takes exactly 1 argument ( 0 given ) If I specify the workspace and output it to a variable name, I get a list of tuples, which is cool, but then I have to step through it and tease out what I want: ws = arcpy . env . workspace #set in line 1 above... users = arcpy . ListUsers ( ws ) >> > users [ user ( ClientName = u 'ad-trasmussen:10.5.1.7333' , ConnectionTime = datetime . datetime ( 2018 , 6 , 22 , 8 , 1 , 14 ) , ID = 388635 , IsDirectConnection = True , Name = u '"SLCOUNTY\\TARASMUSSEN"' ) , user ( ClientName = u 'AD-TBAIN-10:10.5.1.7333' , ConnectionTime = datetime . datetime ( 2018 , 6 , 22 , 8 , 6 , 13 ) , ID = 388636 , IsDirectConnection = True , Name = u '"SLCOUNTY\\TBAIN"' ) , user ( ClientName = u 'ad-trasmussen:10.5.1.7333' , ConnectionTime = datetime . datetime ( 2018 , 6 , 22 , 8 , 11 , 12 ) , ID = 388637 , IsDirectConnection = True , Name = u '"SLCOUNTY\\TARASMUSSEN"' ) , user ( ClientName = u 'AD-TBAIN-10:10.5.1.7333' , ConnectionTime = datetime . datetime ( 2018 , 6 , 22 , 8 , 11 , 32 ) , ID = 388638 , IsDirectConnection = True , Name = u '"SLCOUNTY\\TBAIN"' ) , user ( ClientName = u 'AD-BLECHEMINANT:10.5.1.7333' , ConnectionTime = datetime . datetime ( 2018 , 6 , 22 , 10 , 39 , 34 , 1 ) , ID = 388640 , IsDirectConnection = True , Name = u '"SLCOUNTY\\BLECHEMINANT"' ) , user ( ClientName = u 'is-jborgione-10:10.5.1.7333' , ConnectionTime = datetime . datetime ( 2018 , 6 , 22 , 11 , 30 , 20 ) , ID = 388641 , IsDirectConnection = True , Name = u 'SDE' ) ] for i in range ( len ( users ) ) : . . . print users [ i ] [ 4 ] #prints the user name But I'd rather not do that if I don't have to: I'd much rather use the list object/methods to step through so I can get user.name or user.ID What's the secret to get arcpy.ListUsers() to work as advertised?

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; } } }

arcpy.ListUsers()

JoeBorgione

Using ListUsers—Help | ArcGIS Desktop as my reference I'm trying to get a list of users connected to an eGDB that I can iterate through.

The online help page suggests:

<SPAN class="comment token"># Set the admistrative workspace connection</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/tenone@sde.sde"</SPAN>

<SPAN class="comment token"># Create a list of users</SPAN>
<SPAN class="string token">'''
NOTE: When the arcpy.env.workspace environment is set, a workspace
does not need to be provided to the function.
'''</SPAN>
users <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListUsers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

However, my attempt errors out:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'I:\PathTo\SdeUserConnection\sde@My.sde'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> users <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListUsers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
Runtime error 
Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"<string>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
TypeError<SPAN class="punctuation token">:</SPAN> ListUsers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> takes exactly <SPAN class="number token">1</SPAN> argument <SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN> given<SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

If I specify the workspace and output it to a variable name, I get a list of tuples, which is cool, but then I have to step through it and tease out what I want:

ws <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace&nbsp; <SPAN class="comment token">#set in line 1 above...</SPAN>
users <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListUsers<SPAN class="punctuation token">(</SPAN>ws<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> users
<SPAN class="punctuation token">[</SPAN>user<SPAN class="punctuation token">(</SPAN>ClientName<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'ad-trasmussen:10.5.1.7333'</SPAN><SPAN class="punctuation token">,</SPAN> ConnectionTime<SPAN class="operator token">=</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> ID<SPAN class="operator token">=</SPAN><SPAN class="number token">388635</SPAN><SPAN class="punctuation token">,</SPAN> IsDirectConnection<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> Name<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'"SLCOUNTY\\TARASMUSSEN"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">(</SPAN>ClientName<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'AD-TBAIN-10:10.5.1.7333'</SPAN><SPAN class="punctuation token">,</SPAN> ConnectionTime<SPAN class="operator token">=</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">13</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> ID<SPAN class="operator token">=</SPAN><SPAN class="number token">388636</SPAN><SPAN class="punctuation token">,</SPAN> IsDirectConnection<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> Name<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'"SLCOUNTY\\TBAIN"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">(</SPAN>ClientName<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'ad-trasmussen:10.5.1.7333'</SPAN><SPAN class="punctuation token">,</SPAN> ConnectionTime<SPAN class="operator token">=</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> ID<SPAN class="operator token">=</SPAN><SPAN class="number token">388637</SPAN><SPAN class="punctuation token">,</SPAN> IsDirectConnection<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> Name<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'"SLCOUNTY\\TARASMUSSEN"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">(</SPAN>ClientName<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'AD-TBAIN-10:10.5.1.7333'</SPAN><SPAN class="punctuation token">,</SPAN> ConnectionTime<SPAN class="operator token">=</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">32</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> ID<SPAN class="operator token">=</SPAN><SPAN class="number token">388638</SPAN><SPAN class="punctuation token">,</SPAN> IsDirectConnection<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> Name<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'"SLCOUNTY\\TBAIN"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">(</SPAN>ClientName<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'AD-BLECHEMINANT:10.5.1.7333'</SPAN><SPAN class="punctuation token">,</SPAN> ConnectionTime<SPAN class="operator token">=</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">39</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> ID<SPAN class="operator token">=</SPAN><SPAN class="number token">388640</SPAN><SPAN class="punctuation token">,</SPAN> IsDirectConnection<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> Name<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'"SLCOUNTY\\BLECHEMINANT"'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> user<SPAN class="punctuation token">(</SPAN>ClientName<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'is-jborgione-10:10.5.1.7333'</SPAN><SPAN class="punctuation token">,</SPAN> ConnectionTime<SPAN class="operator token">=</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> ID<SPAN class="operator token">=</SPAN><SPAN class="number token">388641</SPAN><SPAN class="punctuation token">,</SPAN> IsDirectConnection<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">,</SPAN> Name<SPAN class="operator token">=</SPAN>u<SPAN class="string token">'SDE'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>users<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> users<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">#prints the user name</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

But I'd rather not do that if I don't have to: I'd much rather use the list object/methods to step through so I can get user.name or user.ID

What's the secret to get arcpy.ListUsers() to work as advertised?

Encontre mais publicações marcadas com

Accepted answers

All comments

JoeBorgione

I think I may have come up with a solid solution: you need to be logged in as SDE user AND your'll need an advance license....

DanPatterson_Retired

hmmmm have you asked to have you admin level elevated to 'omnipotent'?

JoeBorgione

Never did...

DanPatterson_Retired

Joe... Resolved?

JoeBorgione

The ListUsers() function has to be run with the privleges that the SDE user has; not sure why it's set up that way, but I'm running it as the SDE user. If you run it as a non-admin it scolds you that your permissions are not up to snuff.

I add the workspace arg and write the output to a list and step through it with a for loop and get what I want; just an extra step or two than what the help suggests. Seems like the other list type functions I've used have always worked as one expects. This one is flakey, at least for me... (Using arcgis 10.5.1, python 2.x. Looking back at earlier and even the Pro help, they all are the same...)

DanPatterson_Retired

As suggested from the code samples, it seems to be an admin permissions thing... one example uses () and the other doesn't depending on the admin level... I don't work in that environment, so I thought you might know... unless it is a python ArcMap vs PRO … Python 2.7 vs 3.6 thing

JoeBorgione

That's what I did Dan: my line 2 is the same as your line 4. It errors out complaining that I didn't provide it with the args it's looking for.[My line 6: TypeError: ListUsers() takes exactly 1 argument (0 given)]

I don't get what's up with that....

DanPatterson_Retired

ListUsers—ArcPy Functions | ArcGIS Desktop

returns a tuple as advertised

The second example uses the object method, and it assumes that you are the administrator for the connection though... don't know if that is the issue but look at it and give it a whirl

<SPAN class="comment token">#......</SPAN>
<SPAN class="comment token"># import stuff clipped</SPAN>

users <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListUsers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create a list of SDE ID's.</SPAN>
<SPAN class="comment token"># Use a list comprehension to get the ID values in a new list.</SPAN>

id_users <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>user<SPAN class="punctuation token">.</SPAN>ID <SPAN class="keyword token">for</SPAN> user <SPAN class="keyword token">in</SPAN> users<SPAN class="punctuation token">]</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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