Go to your Tableau Server and in the folder ...\Tableau Server\9.1\wgserver\z5\WEB-INF\admin will be the Server admin reports. COPY the one you want and save it somewhere else. This way when you make a mistake it won't affect the original because what you are doing is unsupported
Once you have the newly saved report(s) you can open them and adjust however you wish. You will need to establish your custom admin views, of course.
thanks for that information but already reach that point.
I was able to modify the Audit_table connections to restrict the informaiton to specific projects.
Now the challenge is to rescrict the data for the tables I mentionned so I can provide custom admin views to specific users but only for their project
1 of 1 people found this helpful
Hi Sylvain. You'll want to join _http_requests to _views on currentsheet = view_url and site_id = site_id. From there, join _views to _workbooks on workbook_id to id. Project Name is a field in the _workbooks view. Let me know if that doesn't work.
To restrict the data to the user in question, you're going to need to set up some user filters on your data. You may already know how to do this, but in case you don't:
I found the same as Matt ^
This is a bit tricky because there isn't a native column in http_requests
You'd need to use a string calc to pull only part of the value from the currentsheet column
for example, I have a workbook named "Regional"
the column in http_requests shows "Regional/Economy" for currentsheet
so i'd need to get just "Regional"
then relate it to the workbooks table on the name column
after I have that match, I can use the project_id column in workbooks to relate to the project table and pull it in.
For background tasks, you can use the Title column to relate to the Extracts table/view, from here you can join either the workbook_id or datasource_id to their respective tables for the project_id
Note that using Title in background_tasks is imprecise--if a workbook/datasource has the same name, you can't distinguish them in that table. So you can get small amounts of duplicate data. It's worse with subscriptions in the background tasks table, because then you've only got a Subject to go on. What's really needed is a set of foreign keys that we could use to link back to the tables representing content on Tableau Server...