For the info that you're looking for (i.e. what user is running what viz), this information exists within the internal audit tables on Postgres. Have you tried tapping into this yet? Workgroups Database The one I generally start with is historical_events.
Hi, thanks. I see what you mean but I believe it is still a problem. How do I get the *current* data about the user's session?
I.e. SELECT data FROM [Workgroups].[Sessions] WHERE session_id=@CurrentSessionID
Where @CurrentSessionID would be a built-in Tableau server variable.
Also, I would question whether the data gets into the [Workgroups] tables in time for my query, as I am reading this upon entry/execution of a visualization.
Let me know what you think.
there is no ability to track real time by the session userid. Can you explain what you are trying to do at execution of the viz? Not adding up for me yet...
Sure. I have several ideas in mind, but one would be...
A visualization that shows the past 30 day user activity of the PC you are on.
So if I could tie a built-in server variable of the remote/calling users IP address to the back-end query that pulls the PC and usage data from our custom internal data for that IP Address, the visualization would be fully dynamic for the user calling it.
I see. There is nothing within the historical_events that identifies the IP. However, if you have a look at http_requests, it does have remote_ip within here, and then you may be able to pass the IP in here via a data integration type method (i.e. blend, cross database join, pass parm to custom sql).
Thanks. I see what your saying but I am not sure how I would get the correct record for the "current" user/session.