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?
thats exactly what I am looking for
1 of 1 people found this helpful
check 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