If you connect to the _users table in the Repository you will see the list of users, their site roles, the sites they have access to, and when they last logged in.
This should give you everything you need
All the best
Hey Arun Yadav here is a Powershell script you can run to export the roles of all users:
If this comment is helpful please mark it as such.
Here is a query I use. It flags as inactive after 1 year which is quite conservative so change 365 based on your policy.
su.name as user
,s.name as site_name
,s.url_namespace as site_id
,max(u.login_at) as last_login
,current_Date - max(u.login_at) as days_since_login
from users u
left join system_users su
on u.system_user_id = su.id
left join sites s
on u.site_id = s.id
--where su.admin_level != 10 10 == admin
group by su.name,s.name,login_at,u.luid, u.created_at,su.admin_level,s.url_namespace
having max(u.login_at) <= current_date - 365
order by u.login_at
You can use the TS Users data source from Shareable Data Sources for Tableau Server . Just point it to your repository database, and filter for the activity levels you care about. All the info you need should be there.
Thank you. I had same issue and this helped to identify inactive users!!