topic Bulk removal of inactive users? in Data Engineering

Bulk removal of inactive users?

GoldenTuna — Mon, 18 Jul 2022 14:10:32 GMT

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?

Re: Bulk removal of inactive users?

AmanSehgal — Tue, 19 Jul 2022 01:52:27 GMT

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

Re: Bulk removal of inactive users?

Atanu — Tue, 19 Jul 2022 13:30:16 GMT

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

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

Re: Bulk removal of inactive users?

Vidula — Mon, 05 Sep 2022 10:19:47 GMT

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!