Delete Inactive Users From Gallery

Hi all!

I am trying to delete a list of inactive users, users that haven't accessed to the gallery in the last year. I don't know which is the most effective way. I know that there is an API to delete the users but the idea is do it in a massive way and, in the future, maybe have a workflow that I can run and automatically delete a list of users.

Is there any recommendation on how to do that?

Thank you for your help! 😃

Gallery

Server

Optimization

Accepted answers

Gawa

@SSorianoA

If you are struggling with how to identify 'inactive' users, you can use Server API 'GET /v3/users'.

Here is snapshot of Swagger of GET /v3/users. In the API response, there is "lastloginDateTime" that has information when that user logged in Gallery at last. By using this information, you can identify inactive users with your own criteria.

Do not forget to explicitly set API parameter "view"="Full", otherwise "lastloginDateTime" are not included in the response.

When it comes to deleting users, as you said, you can use another API. As cautioned in Swagger, users who already have any assets cannot be deleted.

Instead of deleting users, it is also good option to change role of inactive users to "No Access" so you can make them revival gain any time.

This is helpful when you use Windows auth for gallery, and some users are already retired and does not exist but still persist as Alteryx Server users. In my understanding, for "No Access" users, Alteryx Server will not attempt to send LDAP query to Active Directory so less likely to have trouble due to non-existing users.

All comments

Gawa

@SSorianoA

If you are struggling with how to identify 'inactive' users, you can use Server API 'GET /v3/users'.

Do not forget to explicitly set API parameter "view"="Full", otherwise "lastloginDateTime" are not included in the response.

When it comes to deleting users, as you said, you can use another API. As cautioned in Swagger, users who already have any assets cannot be deleted.

Instead of deleting users, it is also good option to change role of inactive users to "No Access" so you can make them revival gain any time.

SSorianoA

Hi @gawa

Thanks for your help. Do you know if it is possible to pass a list of users using the API or does it have to be done one by one?

On the other hand, my intention was to delete them in order to free up space in the database, just those users that are inactive and don't have any workflows nor collections. That's why I wanted to delete them.

Thank you! 😃

Gawa

@SSorianoA OK, so you are concerning about bulk operation.

It depends on which platform you use to call Server API. If Alteryx Designer, you can create multiple rows of API request for each user, and feed to single Download tool. Then, API will be sent to Alteryx Server one by one for each row.(As a general practice, do recommend to throttle records in Download tool to avoid excess load on Server)

If Python or some programming language, you can use FOR loop to call API for each user.

I'm not sure Server API can accept list of json [{user1...},{user2...}] with single API call. If it works, it's easier than what I said above.(Sorry, could not confirm how it works actually)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703