Hi. I will trade you your Powershell script for my combination of scripts that do this on a daily basis. Essentially I compare the users that are already within Tableau with the list of all active users on AD, and then if they don't exist on Tableau, the script goes and adds them.
Jeffery, how many users are do you have in AD / Tableau? I just did another test today and successfully imported 6000 users. Full testing this weekend with all 75,000 users.
I have 1500 internal (active employee) users.
I will package up my script and post it for review by everyone after this weekend.
Some things you can do with it by changing the parameters of the script.
- Specify an OU to query, the OU I use contains only active user accounts.
- Pick number of days to query based on user id creation date.
- Define the properties to pull from AD
- Defined columns for username, password, full name, license, admin, publisher, email
- Specify the paths and file names for each input file.
- There are different input files for adding users and adding users to group based on tableau requirements.
- Specify an input file size for each consecutive run. Keeps CPU usage low.
- Specify the default group for users.
- Specify tableau server
- Add default and optional tabcmd parameters for createuser and adduser.
I currently have this as a scheduled task. Run time for 6000 users was 40 minutes and included 15 input files.
If you have any questions let me know.