Tableau Server 'All Users' missing users 

Tuesday, February 23, 2016 11:22:23 AM

In an interesting twist, the system generated 'All Users' local group didn't have all the users that are listed in the Users tab for a site.  From running this SQL against the Postgres tables/views, confirmed that the users table and the group_users table were not aligned:

 
select case allusergrpmember when 1 then 'In All Users' else 'Not in All Users' end as GroupMembership, count(*) as ID_Count
from
(
select  _users.id, friendly_name, name, sum(case group_id when 2 then 1 else 0 end) as AllUserGrpMember from _users
 left join group_users gu on gu.user_id = _users.id
  where site_id = 1 
 group by 
 _users.id, friendly_name, name
 -- having sum(case group_id when 2 then 1 else 0 end) = 0
 order by friendly_name
 ) t
 group by allusergrpmember
 
So, the intermediate fix was to create a second 'All Other Users' local group to add the missing members.  Tableau was notified of the issue.
Copyright© Brad Earle
Comments are closed on this post.
Site Map | Printable View | © 2008 - 2020 KB Earle Associates LLC | |