How to Get all the users in Portal (more than 10,000)

Question

Hi There, I am trying to build a script that searches all the users and their last login in our portal environment (10.9.1). The code snippet below works fine but it has a limit of 10000.  I found that  advanced_search allows returns all the users but I am not able to get the right syntax. Just wanted to check the proper syntax for a search that brings all the users.

search = gis.content.advanced_search(query='', max_items=100)

users = arcgis.gis.UserManager(gis)
allUsers = users.search(query = '*', max_users = 10000)

for user in allUsers:
            if user.lastLogin != -1:
                last_accessed = time.localtime(user.lastLogin/1000)

NicolasGIS · Answer

Hello ,

Thanks for sharing @HenryLindemann.

I am facing the same issue. Need to run a routine over all my users and I now have 12000. I tested your sample and on my side running:

users_count = user_manager.advanced_search(query=f"{portal_id} AND !_esri", return_count=True)

returns: 10000... So the hard limit remains.

I am thinking about iterating through the alphabet 'a*', 'b*', ... 'z*':

users = user_manager.advanced_search(query=f"{portal_id} AND !_esri AND username:a*")

Any other (cleverer) idea by any chance ?

Sunnywaygis · Answer

Thanks HenryLindemann for the code snippet. I will give this a try and this working. We still wont know until we cross 10,000 user limit.

Thanks again for your help.

Sunnywaygis · Answer

Thanks jcarlson for your suggestion. We dont have 10,000 users at this time, I dont have a way to test this but I wanted to script to accommodate for this scenario.

PREVIEW