-
1. Re: How to view status report for who is Downloading Summary Data & Full Data
Patrick Van Der Hyde Dec 27, 2017 1:18 PM (in response to Paulina Lawson)The underlying full data download is not a monitored event. There is a Tableau Idea here - https://community.tableau.com/ideas/6692 that I suggest voting on. I found an older thread on this topic - Monitoring Tableau Server Full Data Download as well that may be helpful.
Patrick
-
2. Re: How to view status report for who is Downloading Summary Data & Full Data
Toby ErksonDec 31, 2017 5:05 PM (in response to Paulina Lawson)
1 of 1 people found this helpfulI know nothing about this so I ran a test and here's what I found out...
The http_req table is the one where the information can be found.
You want to look in the ACTION column where the value is "vud".
The CURRENTSHEET column is the workbook/sheet name in the database format, not in the human-readable format! For example, I used the workbook "tabbed admin views" and the sheet "Traffic to Views", thus the CURRENTSHEET value for me was "tabbedadminviews/TraffictoViews".
The column HTTP_REQUEST_URI tells you the request made and it's the last values that tell you if it's a summary or detail download:
~ if the field ends with "csv=true&summary=true" then the user downloaded the data in summary form
~ if the field ends with "csv=true" then the user downloaded the data in detailed form.
Here's what it looks like when I filtered the data for today only and only looking at my IP address (filtered on REMOTE_IP):
Read from the bottom and work your way up.
(1) is the call for Summary download
(2) is the call for Detailed download
You want to know the SITE_ID so you don't get workbooks confused if you have more than one Site. However, this isn't a guarantee that you'll know the exact workbook if Users duplicate workbook and/or sheet names (this is NOT uncommon ) so you can parse the HTTP_REFERER field to pull out that data. Here's an example of that column from my data:
If you study the data in the field you'll find:
~ the Site: /t/area51
~ the Workbook: /w/tabbedadminviews
~ the Sheet (a.k.a. View): /v/TraffictoViews
This is the hard part and will get you started. This is not a guarantee that this is 100% accurate and it has not been thoroughly vetted.
-
3. Re: How to view status report for who is Downloading Summary Data & Full Data
Paulina Lawson Dec 27, 2017 3:04 PM (in response to Patrick Van Der Hyde)Hi Patrick,
Thank you so much for your reply!
-
4. Re: How to view status report for who is Downloading Summary Data & Full Data
Paulina Lawson Dec 27, 2017 3:09 PM (in response to Toby Erkson)Hi Toby,
Thanks for taking time and replying me. I'll check it out.
Thank you!
-
5. Re: How to view status report for who is Downloading Summary Data & Full Data
Patrick Van Der Hyde Dec 28, 2017 12:31 PM (in response to Toby Erkson)Thank you for the detailed investigation Toby. A remarkable Ambassador!!!
Patrick
-
6. Re: How to view status report for who is Downloading Summary Data & Full Data
Toby ErksonJan 9, 2018 8:14 AM (in response to Toby Erkson)
Just a short follow-up (reading from the bottom up): I opened a workbook, went to a sheet, downloaded it as a PDF (opened in Adobe Reader) and then immediately downloaded it as a Tableau workbook (opened in Tableau Desktop). This shows what the ACTION, CONTROLLER, and HTTP_REQUEST_URI fields look like.
(1) Downloading a viz as a PDF.
(2) Downloading a viz as a Tableau workbook.
-
7. Re: How to view status report for who is Downloading Summary Data & Full Data
Manikanta pothuri Jul 22, 2018 1:41 AM (in response to Toby Erkson)Hi Toby,
Could you please provide SQL query to get the detail table to track users details who are requested for downloading data i just want to track this info.
i just want to create a report on tracking user cations on downloading data
I have tried to join _http_req to _user Table based n user id in _HTTTP_REQ and ID column is in _User
i have trouble getting these table together to show which user requested for the Cross data download, CSV file to a server and want to identify his name, id and time
Thanks
-
8. Re: How to view status report for who is Downloading Summary Data & Full Data
Toby ErksonJul 23, 2018 8:35 AM (in response to Manikanta pothuri)
This can get you started:
SELECT http.*, use.*, sys.* FROM public.http_requests http LEFT OUTER JOIN public.users use ON http.user_id=use.id, public.system_users sys WHERE use.system_user_id=sys.id AND http.controller like '%cross%'
-
9. Re: How to view status report for who is Downloading Summary Data & Full Data
Paul Rowles Jul 30, 2019 6:54 AM (in response to Paulina Lawson)Hi
Is there anyway of finding this out on Tableau Online?
Thanks
Paul
-
10. Re: How to view status report for who is Downloading Summary Data & Full Data
Hilary Hastings Nov 13, 2019 3:37 AM (in response to Toby Erkson)This is ace thanks. I put wildcard searches in for HTTP_REQUEST_URI contains "%csv=true%", "%maxrows%" and action - "vud", created a date filter. Used the [Current Sheet] column to name the workbook. Thanks so much, very helpful.