User Management -> Sync tool Configuration

[Banakshi-01]

What should be the file format in terms of what columns should be included if i am trying to sync using excel.
Do i have maintain the file name as standard "ts_auth_sync_users" ?

My end goal is to remove users in Bulk.
My excel list has the list of usernames i wish to keep

Attaching a screenshot for reference.

[boonhapus]

Hey @Banakshi-01 , I'm about to write a tool specifically for deleting users. The tool you're using here is wrapping the user/sync API , whose purpose is to replace the users and groups settings in ThoughtSpot from somewhere external (LDAP, a database table, etc). As part of that API, ThoughtSpot allows you to delete users.

.. but it's a bit of a shotgun approach. And shotguns are scary tools.

I've got some time blocked off on Friday US hours to write a user delete tool, which will take a list of users to remove from the platform.

We can also use the Searchable tool to extract the current users (along with a bunch of extra data). If you want to see this data now, you can use the following command.

cs_tools tools searchable metadata --syncer csv://directory=. --config yourConfigName

Your users are in a file called ts_user.csv.

[Banakshi-01]

Hey Team, That sounds great. Looking forward to the delete utility tool in that case. 😊 Internal Use - Confidential From: SN ***@***.***> Sent: Thursday, October 10, 2024 6:27 PM To: thoughtspot/cs_tools ***@***.***> Cc: Baruah, Banakshi ***@***.***>; Mention ***@***.***> Subject: Re: [thoughtspot/cs_tools] User Management -> Sync tool Configuration (Discussion #175) [EXTERNAL EMAIL] Hey @Banakshi-01 [github.com]<https://urldefense.com/v3/__https:/github.com/Banakshi-01__;!!LpKI!iYQbuYquebfKUN_xAONB95zTrfHwJs0brh5L7g1PRsU-FA_QhITxsTGplOhGjGUz27xB3p1HJE4rJz4Xppyk9-4vVIE$> , I'm about to write a tool specifically for deleting users. The tool you're using here is wrapping the user/sync API [developers.thoughtspot.com]<https://urldefense.com/v3/__https:/developers.thoughtspot.com/docs/user-api*user-sync__;Iw!!LpKI!iYQbuYquebfKUN_xAONB95zTrfHwJs0brh5L7g1PRsU-FA_QhITxsTGplOhGjGUz27xB3p1HJE4rJz4Xppyk0A-FyJM$> , whose purpose is to replace the users and groups settings in ThoughtSpot from somewhere external (LDAP, a database table, etc). As part of that API, ThoughtSpot allows you to delete users. .. but it's a bit of a shotgun approach. And shotguns are scary tools. I've got some time blocked off on Friday US hours to write a user delete tool, which will take a list of users to remove from the platform. We can also use the Searchable tool to extract the current users (along with a bunch of extra data). If you want to see this data now, you can use the following command. cs_tools tools searchable metadata --syncer csv://directory=. --config yourConfigName Your users are in a file called ts_user.csv. — Reply to this email directly, view it on GitHub [github.com]<https://urldefense.com/v3/__https:/github.com/thoughtspot/cs_tools/discussions/175*discussioncomment-10904007__;Iw!!LpKI!iYQbuYquebfKUN_xAONB95zTrfHwJs0brh5L7g1PRsU-FA_QhITxsTGplOhGjGUz27xB3p1HJE4rJz4XppykAh-XNd0$>, or unsubscribe [github.com]<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/BLMNG6TWU4M7VK6KQFYOMUDZ2Z2R3AVCNFSM6AAAAABPV7DELGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTAOJQGQYDANY__;!!LpKI!iYQbuYquebfKUN_xAONB95zTrfHwJs0brh5L7g1PRsU-FA_QhITxsTGplOhGjGUz27xB3p1HJE4rJz4XppykDQ6hs50$>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

[Banakshi-01]

Hi @boonhapus : Have you had any luck with the utility tool to be able to delete bulk user in TS ?

[boonhapus]

Hey @Banakshi-01 , this was released in 1.5.11 !

All you need is at least 1 column which the name username as input. So if you ran searchable with a csv syncer and kept only the users you want to delete, then you can use that as input to this command.

---

cs_tools tools searchable metadata --syncer csv://directory=.

Open the ts_user.csv file and REMOVE all users you want to KEEP.

cs_tools tools user-management delete --syncer csv://directory=. --deletion ts_user