Howdy all!
We have a situation where users are being added to a Tableau user group that is not for everyone.
Is it possible via Tableau Server to see who is adding these users so we can keep track in the future when someone is mis-placing others?
Thanks!
3 answers
Here's a short example query:
SELECT he.created_at, hu1.name as AddedBy, hu2.name as UserAdded, hg.name as GroupName
FROM public.historical_events he
LEFT JOIN public.hist_users hu1 ON he.hist_actor_user_id = hu1.id
LEFT JOIN public.hist_users hu2 ON he.hist_target_user_id = hu2.id
LEFT JOIN public.hist_groups hg ON he.hist_group_id = hg.id
WHERE historical_event_type_id=42;
Please note the workgroup database only retains 6 months worth of data!
