deeejay

Tableau - Query Tableau Server Users

Aug 8th, 2016
457
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT users.name AS user_name, users.friendly_name AS user_friendly_name, users.licensing_role_name, users.domain_name, sites.name AS site_name
  2. FROM _users users
  3. INNER JOIN _sites sites
  4. ON users.site_id = sites.id
  5. WHERE domain_name = 'add domain name here'
  6. AND users.licensing_role_name = 'Interactor'
  7. ORDER BY users.name ASC;
Advertisement
Add Comment
Please, Sign In to add comment