I don't know what category this fits in very well, but I picked one.
Here is my situation:
1. Active Directory SSO is enabled and required by my org
2. The REST API is disabled as required by my org's security team (don't ask)
3. The AD Sync is not a sync, but an add only, so I have 100's of unlicensed users (30,327 total users)
4. Manually removing the unlicensed users via the GUI is ridiculous because I can't select all and delete
I am considering attempting to enable read / write account for the users table within tableau and running a powershell script to query and delete any unlicensed users. I don't know if enabling read write on a particular table in the DB is possible and searching that hasn't given me any specific information on it.
Hi Justin,
This might gain more attention in the Server Administration area.
I do not believe there is a 'supported' way to have write access to the PostGres Repository on Tableau Server. You are able to have read access though, build a query against it, and then write a tabcmd command to remove the users.
*There is a yml file with the superuser tblwgadmin account which is explained here but it is not supported: null
You could export the list though from Tableau PostGres to a csv and use the 'tabcmd deleteusers "user.csv" ' which is referenced here: tabcmd Commands
One other note, you will not be able to remove users that currently are listed as owners so you would need to get a list of users that are attached to content on the server. You can also get this information from the PostGres repository though. If you run the deleteusers command and a user still has content it will leave them as 'unlicensed'
If you haven't enabled access to the PostGres Repository, here is a link:Collect Data with the Tableau Server Repository
Andrew
