-
1. Re: Determine user's browser when accessing view
Jeff Strauss
Feb 8, 2017 8:10 AM
3 of 3 people found this helpfulif you really care about this, you can try accessing internal Postgres table http_requests.
Here is a sample that I ran for today.
-
2. Re: Determine user's browser when accessing view
Awesome. Thanks Jeff!
We're planning to reboot server tomorrow to enable 'readonly' user. I'll look to this table then!
-
3. Re: Determine user's browser when accessing view
Reporting on that info is pretty useful to detect old browsers, compatibility modes, TABCMD & Desktop versions etc. See useragent lookups like http://www.useragentstring.com/index.php or https://browscap.org/ua-lookup
Hacky caclulation to clean up the data a bit.
if CONTAINS([http_user_agent], 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1' ) then 'IE7 or IE8/9/10/11 in compatability mode'
elseif CONTAINS([http_user_agent], 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko') then 'IE11'
elseif CONTAINS([http_user_agent], 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)') then 'IE9'
elseif CONTAINS([http_user_agent],'Firefox' ) then right ([http_user_agent], len([http_user_agent]) - find([http_user_agent],'Firefox')+1)
elseif CONTAINS([http_user_agent],'Chrome' ) then left(right ([http_user_agent], len([http_user_agent]) -find([http_user_agent],'Chrome')+1), find(right ([http_user_agent], len([http_user_agent]) -find([http_user_agent],'Chrome')+1), ' '))
elseif CONTAINS([http_user_agent], 'Tableau 82') then 'Tableau Desktop 8.2'
elseif CONTAINS([http_user_agent], 'Tableau Desktop 83') then 'Tableau Desktop 8.3'
elseif CONTAINS([http_user_agent], 'Tableau Safari') then 'Tableau publish preview?'
else [http_user_agent]
end
-
4. Re: Determine user's browser when accessing view
I recently did some work to analyze this http user agent data with the help of an external Python library. See Adventures in Tableau Server device type analysis.
