You could try getting into the Postgre SQL and doing an update statement on the system_users table? it isn't able to be shown by default and probably isn't support, so make sure you take a backup before attempting to do an update statement.
I also use Alteryx extensively and am considering an In-Database workflow to correct the entries. However, I'm gun shy on this as I can't afford to mess this up with the number of users in our deployment.
If you have the ability to set up a test cluster/machine, you can restore a backup to that and try it, or take a snapshot if its virtualized before doing the deed.
You read my mind. Was actually researching that here right now. Sincerely appreciate the feedback.
I am also going to post this in the Alteryx Community to see if any of those gurus can talk me through whether or not this would work using the Alteryx In-Database tool set.
Glad to help, you've got to love the old Iowa school domain names.
Update on this--
We submitted this to Tableau Support and there is no mechanism supported by Tableau allowing for the updating of a user's email address in Tableau Server, let alone 4,000 of them. They're only suggestion was to do it via the REST API, but I wouldn't even know how to start.
If anyone is willing to help us out, that would be great. Otherwise, I'll just chalk this up to being outta luck.
I haven't fully implemented the api, but the basics aren't too bad. Take a look at the link below for how to send the API call, I'm sure if there are programmers on staff, they could help to implement this, but alteryx may also be able to this for you.
Basically you need to log in and get your authorization token, then you use that token with any further calls to authenticate.
You will then need to get your users on a site, change what you need, then repost with update user.
1 of 1 people found this helpful
TabCmd can do this pretty easily.
This video helped me a lot. It walks you through all of this.
You’ll have to install tabcmd (or do this from the tableau sever.)
You’ll need a .csv file that has the people you need to modify. You MUST follow the csv guidelines here. https://onlinehelp.tableau.com/current/server/en-us/csvguidelines.htm Leave the password column blank.
The createusers command actually modifies existing users. I just checked and confirmed this.
So you’ll run CMD.exe as an administrator.
You’ll change the directory to wherever tabcmd is.
cd C:\Program Files\[location]
You’ll log into the server.
tabcmd login -s http://tableau.site.com -u jsmith -p password
You’ll run the create users command
tabcmd createusers "c:\location\folder\users.csv"
I'm going to check all of this out and see where I land. Will be back to Mark as Solved, I hope!