Thank you for the response John. I guess I'm not seeing how the Capabilities table is supposed to connect to any other table. Is there a way it can connect to the Hist tables or do you know a way to determine Web Authoring in the Hist tables?
1 of 1 people found this helpful
No, "capabilities" only relates to the user's entitlements, specifically their Role. In my Server 9.1 testing, http_requests is the only place you'll catch it. The hist_* tables record the creation of new workbooks online as "Publish Workbook" (same as publish from desktop it seems). You can get the appropriate joins for the hist tables from Server workbook ...\Tableau\Tableau Server\9.1\wgserver\z5\WEB-INF\admin\tabbed_admin_view.twb
The joins I use to get user info) from http_requests are something like:
from http_requests h, sites s, system_users su, users u
where h.user_id = u.id
and u.system_user_id = su.id