Posts From February, 2016

Tableau Server 'All Users' missing users

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.
Gravatar
Copyright© Brad Earle
Site Map | Printable View | © 2008 - 2021 KB Earle Associates LLC | |