-
1. Re: Export Users from a Specific Site
Akram Ebrahim Jul 10, 2017 7:04 AM (in response to jyoti thakar)Hi Jyothi,
I believe there is no direct option to export tableau users from a particular site. Please refer this article which has a workaround to get those user names though
-
2. Re: Export Users from a Specific Site
Jeff StraussJul 10, 2017 7:43 AM (in response to jyoti thakar)
we export users from a specific site by creating a Tableau report that connects up to the internal PG database and joins _users to _sites via the site_id. And then we filter down to the site that we're interested, and then we use tabcmd to export. Is this what you're looking for?
-
3. Re: Export Users from a Specific Site
jyoti thakar Jul 10, 2017 9:01 AM (in response to Jeff Strauss)Hi Jeff
thats exactly what I am looking for
-
4. Re: Export Users from a Specific Site
Jeff StraussJul 10, 2017 9:31 AM (in response to jyoti thakar)
1 of 1 people found this helpfulcheck out the attached workbook. You need to edit the connection to point at your Tableau PG instance. And then you can change the filter to the site and domain that you are interested. It joins _users and _sites.
Then you can use tabcmd to export. Here are a few lines.
tabcmd login --server http://localhost --username abc_username --password abc_password --timeout 1800
tabcmd export "/Admin_export_user_list_for_a_site?:refresh=yes" -f "g:\site_users.csv --csv
tabcmd logout