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

How to query and sort on ArcGIS Portal users based on date?

AllenGuan2

I want to retrieve our on-premise Portal or AGOL users based on a query on the lastLogin, for example the users who last logins between two dates, or since a date, or in the last 2 hours, How would I do that? Also I want to sort the results based on lastLogin using the below statement, it does not sort as expected.

users = gis.users.search("*",sort_field="lastLogin",sort_order="desc",max_users=1000).

Finde mehr Beiträge mit dem Tag

Accepted answers

JoshuaBixby

I should have caught this earlier. See UserManager documentation:

search(query=None, sort_field='username', sort_order='asc', max_users=100, outside_org=False, exclude_system=False)
... ...
sort_field Optional string. Valid values can be username (the default) or created.
... ...

Last login is not a valid sort field. Interestingly enough, the ArcGIS REST API User Search documentation states fullname and modified are also valid sort fields.

All comments

JoshuaBixby

You say "does not sort as expected," what do you expect and what are you getting? Examples are very helpful to community members.

AllenGuan2

Here is the code. I would think the results will be ordered in desc by lastlogin_str column, but they are not.

import pandas as pd
import time
tbl = []
users = gis.users.search("*",sort_field="lastLogin",sort_order="desc",max_users=500)
for user in users:
    grps = ""
    for grp in user.groups:
        try:
            grps += grp.title + ","
        except:
            print("\n")
    grps = grps[:-1]
    created_str = time.strftime('%Y-%m-%d', time.gmtime(user.created/1000.0))
    modified_str = time.strftime('%Y-%m-%d', time.gmtime(user.modified/1000.0))
    lastlogin_str = time.strftime('%Y-%m-%d', time.gmtime(user.lastLogin/1000.0))
    num_items = 0
    #root items
    #print("Items under root:")
    for item in user.items():
        #print("\t" + item.title + " - " + item.type)
        num_items += 1
    # folder items
    for folder in user.folders:
        #print("Items under " + folder['title'] + ":")
        for item in user.items(folder=folder['title']):
            #print("\t" + item.title + " - " + item.type)
            num_items += 1

tbl.append([user.username,user.fullName,user.role,user.level,user.email,created_str,modified_str,lastlogin_str,grps,str(num_items),str(user.disabled),user.idpUsername,user.userType,user.assignedCredits,user.availableCredits])
#print(user.username + "\t" + str(user.role) + "\t" + created + "\t" + lastlogin + "\t" + grps)

columns_all = ['User','fullName','Role','Level','Email','Created','lastModified','lastLogin','Groups','Items','Disabled','idpUsername','userType','assignedCredits','availableCredits']
df = pd.DataFrame(data = tbl,columns = columns_all)
columns_show = columns_all
df[columns_show]

JoshuaBixby

I should have caught this earlier. See UserManager documentation:

search(query=None, sort_field='username', sort_order='asc', max_users=100, outside_org=False, exclude_system=False)
... ...
sort_field Optional string. Valid values can be username (the default) or created.
... ...

Last login is not a valid sort field. Interestingly enough, the ArcGIS REST API User Search documentation states fullname and modified are also valid sort fields.

JohnYaist1

Hi Allen Guan,

You can return a list of users sorted by the created or modified attributes as mentioned above like:

org_users <SPAN class="operator token">=</SPAN> g<SPAN class="punctuation token">.</SPAN>users<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN>query<SPAN class="operator token">=</SPAN><SPAN class="string token">"NOT fullName: esri*"</SPAN><SPAN class="punctuation token">,</SPAN> sort_field<SPAN class="operator token">=</SPAN><SPAN class="string token">"modified"</SPAN><SPAN class="punctuation token">,</SPAN> sort_order<SPAN class="operator token">=</SPAN><SPAN class="string token">"desc"</SPAN><SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

You can then use Python's datetime and calendar modules to inspect lastLogin based on various time values:

<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> datetime<SPAN class="punctuation token">,</SPAN> timedelta

<SPAN class="comment token"># create a datetime object for right now</SPAN>
now <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># create a datetime object for 2 hours ago</SPAN>
dt_2hrs_ago <SPAN class="operator token">=</SPAN> now <SPAN class="operator token">-</SPAN> timedelta<SPAN class="punctuation token">(</SPAN>hours<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># convert the datetime object from 2 hrs ago into Unix epoch time in seconds</SPAN>
etime_2hrs_ago <SPAN class="operator token">=</SPAN> calendar<SPAN class="punctuation token">.</SPAN>timegm<SPAN class="punctuation token">(</SPAN>dt_2hrs_ago<SPAN class="punctuation token">.</SPAN>timetuple<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># use a list comprehension to get list of users who have logged in within the last 2 hrs</SPAN>
usr_within_2hrs <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>usr <SPAN class="keyword token">for</SPAN> usr <SPAN class="keyword token">in</SPAN> org_users <SPAN class="keyword token">if</SPAN> usr<SPAN class="punctuation token">.</SPAN>lastLogin<SPAN class="operator token">/</SPAN><SPAN class="number token">1000</SPAN> <SPAN class="operator token">></SPAN> etime_2hrs_ago<SPAN class="punctuation token">]</SPAN>
usr_within_2hrs
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

This approach will struggle with larger number of users. My organization has 8,000+ AGOL users, retrieving all of them to sort by lastLogin isn't practical.

Unlike User Search—ArcGIS REST API: Users, groups, and content | ArcGIS for Developers under the Community URL, Users—ArcGIS REST API: Users, groups, and content | ArcGIS for Developers under the Portal URL does support using lastLogin as a sort field.

What would be handy, and may exist but I just haven't found it, is to have part of the Python API for ArcGIS generate the following type of REST call:

https://org.maps.arcgis.com/sharing/rest/portals/self/users?sortField=lastlogin&sortOrder=desc&num=5&f=pjson<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

AllenGuan2

yes, verified created sort is correct. Why not make lastlogin sortable? It is more useful than created.

AllenGuan2

yes, thanks.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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