I have a requirement where I need to pull list of users for a particular group from Tableau Repository i.e. workgroup database.
It seems to be straight forward task , but somehow group_users & users table are not giving the desired output.
Any pointers in this direction would be highly appreciated.
what does your SQL look like? This one seems to work for me...
select b.name, c.*, d.* from group_users a,
groups b, users c, system_users d
where a.group_id = b.id and a.user_id = c.id
and c.system_user_id = d.id
and b.name = 'group_name'