@echo off

::SETUP VARS

set usr=<tableau service account>
set pwd="<tableau service account password in quotes>"
set svr=https://<your tableau server url>
set log=c:\tasks\Tableau_ADSync_Log.txt

::go to tabcmd home, change this to wherever you have tableau server installed

cd "C:\Program Files (x86)\Tableau\Tableau Server\7.0\bin"


::LOGIN TO THE SERVER
echo ******AD Synch STARTING %date%:%time%****** >> %log% && echo. >> %log%

echo ***logging in to DEFAULT site*** >> %log% && echo. >> %log%
tabcmd login -u %usr% -p %pwd% -s %svr% >> %log% && echo. >> %log%


::SYNC GROUPS on uncertified site, COPY THESE FOR EVERY GROUP YOU WISH TO SYNC

echo ***syncing groups on UNCERTIFIED site*** >> %log% && echo. >> %log%

tabcmd syncgroup "Tableau - Publishers" --license Interactor --publisher --username %usr% --server %svr% --password %pwd% >> %log% && echo. >> %log%
tabcmd syncgroup "Tableau - Users" --license Interactor --username %usr% --server %svr% --password %pwd% >> %log% && echo. >> %log%
tabcmd syncgroup "Tableau - System Admins" --license Interactor --administrator system --username %usr% --server %svr% --password %pwd% >> %log% && echo. >> %log%


echo ***finished syncing groups on DEFAULT site*** >> %log% && echo. >> %log%
tabcmd logout >> %log% && echo. >> %log%


echo ******AD Synch FINISHING %date%:%time%****** >> %log% && echo. >> %log%