Bulk removal of inactive users?

[GoldenTuna]

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?

[AmanSehgal]

@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]

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​ 

[Vidula]

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!