Tableau Get Inactive User for the Last 30 Days

Question

How can we get a list of users who has not accessed Tableau for the last 30 days? I tried using the rebuild report (site_status) but It is not listing the users. Can we query the tables or is there any dashboard that gives this information, please?

Thanks,

Solution

You can connect to Tableau Server's internal Postgres database and pull a variety of usage data. Work with your server admin to enable and grant you permissions.

https://help.tableau.com/current/server/en-us/perf_collect_server_repo.htm

Once you have that, there's a Users table with a login_at field that will contain the most recent login of users. https://tableau.github.io/tableau-data-dictionary/2019.4/data_dictionary.htm#users_anchor

Comments

[DanBig]

What is the host CPU config, and how many vCPUS have you assigned to the guest? It's not a 1-to-1 comparison when assigning vCPU against host physical hardware.

[Zoredache]

You image link seems to be broken. Can you please re-upload that on imgur.com?

[Jozef]

HI, probably redirected URL, here valid one : picasaweb.google.com/lh/photo/…

[Jozef]

CONFIG : Physical machine Dell poweredge 2950 : 2x CPU Xeon 3ghz quadcore, 32Gb RAM, RAID10 4xSAS 15K + 2xSSD for OS and MSSQL. Application Virtual machine : assigned from total : 6 cores, 25GB, RAID for data, 1xSAS for OS MSSQL machine : assigned :1 core, 4Gb RAM.

[StackzOfZtuff]

@Jozef: Did you manage to solve this? (Also Image-Links are dead.)

[Jozef]

Hi, thank you, I will give it a try. great!!! Do you think running this tool on host and guest will show correct-the same results ?

[magicandre1981]

try it on the host and look if the CPU usage is now displayed correctly.

[Jozef]

HI, seems my OS is not supported... :-( SERVER 2008R2, SP1

[magicandre1981]

maybe it only works with Server 2012.

[Jozef]

hi, I see that, but both my OS (guest and host) are Server 2008R2, any tools for this?

[magicandre1981]

Ask the support of the tool if they can make it 2008R2 compatible.

[Kiran]

Hi Bernardo, thanks for the reply. Yes, I have received access to the Tableau repository, I'm looking at the tables.