Thursday, 10 March 2016

Groups and User Creation using TABCMD




Using TABCMD
·      Create four additional groups: Billing Users, Billing Manager, Facilities Users, and Facilities Manager.
·      Create all of the Billing and Facilities users using the “BILLFAC” CSV file.
·      Assign the Billing users to the Billing Users group using the “BILLUSERS” CSV file.
·      Assign the Billing manager to the Billing Manager group using the “BILLMGR” CSV file.
·      Assign the Facilities users to the Facilities Users group using the “FACUSERS” CSV file.
·      Assign the Facilities manager to the Facilities Manager group using the “FACMGR” CSV file.
·      You can find the files by following the directory path: C:\Program Files\Tableau
·      Link to the list of available Tabcmd Commands: http://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm



Solution:-
·      Create Billing Users Group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Billing Users"

·      Create Billing Manager Group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Billing Manager"

·      Create Facilities Users Group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Facilities Users"

·      Create Facilities Manager Group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Facilities Manager"

·      Create all of the Billing and Facilities users:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" createusers "c:\Program Files\Tableau\USERS\BILLFAC.csv"

·      Assign the Billing users to the Billing Users group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Billing Users" --users "c:\Program Files\Tableau\USERS\BILLUSERS.csv"

·      Assign the Billing manager to the Billing Manager group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Billing Manager" --users "c:\Program Files\Tableau\USERS\BILLMGR.csv"

·      Assign the Facilities users to the Facilities Users group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Facilities Users" --users "c:\Program Files\Tableau\USERS\FACUSERS.csv"

·      Assign the Facilities manager to the Facilities Manager group:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Facilities Manager" --users "c:\Program Files\Tableau\USERS\FACMGR.csv"

FULL SCRIPT:
"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" login -s http://localhost:80 -u admin -p admin > installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Billing Users"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Billing Manager"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Facilities Users"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" creategroup "Facilities Manager"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" createusers "c:\Program Files\Tableau\USERS\BILLFAC.csv"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Billing Users" --users "c:\Program Files\Tableau\USERS\BILLUSERS.csv"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Billing Manager" --users "c:\Program Files\Tableau\USERS\BILLMGR.csv"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Facilities Users" --users "c:\Program Files\Tableau\USERS\FACUSERS.csv"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" addusers "Facilities Manager" --users "c:\Program Files\Tableau\USERS\FACMGR.csv"

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" logout >> installLog.txt

Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks