Bulk removal of inactive users?

GoldenTuna
New Contributor II

‎07-18-2022 07:10 AM

To make a long story short, through SCIM we accidentally provisioned 3,000+ users into our Databricks workspace who should not be there. We fixed the SCIM issue but now the workspaces tab is flooded with inactive user workspaces. Is there any way to bulk remove these vs. one at a time moving these user workspaces to trash?

Labels:
0 Kudos

AmanSehgal
Honored Contributor III

‎07-18-2022 06:52 PM

@David Kruetzkamp​  - are you a premium user?

You can use SCIM API and get all the users using following endpoint.

2.0/preview/scim/v2/Users

You can then delete the users by using the following endpoint:

2.0/preview/scim/v2/Users/{id}

Atanu
Databricks Employee
Databricks Employee

‎07-19-2022 06:30 AM

please get all inactive user by this https://docs.databricks.com/dev-tools/api/latest/scim/scim-users.html#filter-active-and-inactive-use...

and you, you can automate the deletion from above filtered id using https://docs.databricks.com/dev-tools/api/latest/scim/scim-users.html#delete-user-by-id

@David Kruetzkamp​ 

0 Kudos

Vidula
Databricks Partner

‎09-05-2022 03:19 AM

Hello @David Kruetzkamp​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

0 Kudos