1 answer
Hi @Srinivasa Rao Digudadi
Have you tried looking at different blogs for ideas?
WarningCustom Admin Views was archived. To reactivate, contact the group owner Rain Ortega.
Featured group
Custom Admin Views
Hello everyone.
I'm trying to get calculated field formula from the repository. We can parse the xml and get this data. But is there any way to get it from the Tableau Repository Database.
I have used recommendations schema to get the fields but the calculation fields formula is not available. I have created column lineage using recommendation schema.
I see Synonyms, column_assets but these are empty. Can we get this from blob in repository. Any help is much appreciated. Alation is one more useful tool, how good is it for getting these?
Hi, I'm looking for a sample workbook that I can play around with -- since I can't use data from my clients. I've asked Tableau, but they don't have anything. Appreciate any help / ideas / leads ...
1 answer
Old stuff, but may serve your needs: New Views for Tableau Server Administrators — BI on BI https://www.tableau.com/about/blog/2015/1/tableau-tableau-36123
And don't forget Mark Jackson's posts, which can be found here: http://ugamarkj.blogspot.com/2014/08/custom-tableau-server-admin-views.html?q=server
1. need to know all the datasources published on server namer, how many, and details
2. how many datasourses connected to redshift prod and uat and others
3. duplicate datasources- one to many
4. list of datasources not connected to redshift
5. list of users logged in for last 6 months and not logged in for last 6 months
1 answer
Please refer to this blog post from a few years ago - https://community.tableau.com/s/question/0D54T00000G53g9SAB/custom-tableau-server-admin-views the attached workbooks in this post should be able to provide the information you're looking for - I use them on my instance(s) and find them extremely useful
Does anyone know how I would reproduce the load times figures in Postgres?
Is that just a matter of taking the started and completiondate from 'http_requests' for a specific session ID?
5 answers
Alex,
If you are using server v9+, load time report is built-in to the product. Just go to Server > Status > Stats for Load times. You can also download the workbook for both v8 and v9 at Server Admin View Workbooks.
Cheers,
John
I have many data sources that are being published to our server using the Tableau API or data connector but they do not show up as jobs. I only see them on the server if they publish successfully.
I can't find them in the admin data. Looking specifically at TS Web Requests and TS Background Events and TS Events.
I updated my TS Content data source, but I am having issues updating the others. Not sure if that would really help.
Have any of you figured out how to find them in the Admin data sources?
1 answer
Hi Mary,
My initial thoughts are to reverse-engineer the question. If you know which data sources are published via every other means, this reduces your dataset to just the ones that must be via the API or data connector.
HTH
Peter
Is there a way we can identify the workbooks which are using Row Level Security Feature using Metadata API or any other methods
2 answers
I haven't used the Metadata API, however, the documentation states that it can find whether a calculated field uses one of the user functions (https://help.tableau.com/current/api/metadata_api/en-us/reference/calculatedfield.doc.html) -- hasuserreference. Returning True would indicate the field does incorporate a user function, which is one of the methods to enable row level security. Obtaining a list of workbooks with a user function calculated field is the first step. The second step would be to determine where that calculated field is used as a filter condition (sheets, dashboards, or datasources). Perhaps this gets you headed in a direction towards a more complete answer meeting your interests.
Custom portal view for admins and end users
I am trying to create a custom portal for end users and also Admins to see what users have permissions to access what workbooks and I am finding hard to do so. I have access to Content, Events and Users, but each of them shows different workbook or projects that I have access to..
Hi All
I like to remove the user is the user didn't sign in for a month, therefore I need the following info to do it along with other user detail
1. user log in datetime
2.user create datetime
3.user remove datetime
4.user AD name
which tables and how to join them can give me the details I need?
thanks in advance
mike
1 answer
Hi @Mike Cheng Here are a few links that might be helpful -
https://tableau.github.io/tableau-data-dictionary/2022.3/data_dictionary.htm
Thanks!
A while back someone had given me a workbook with permissioning that works really great but requires extracts due to the enormous size of the data and load on the Server. While the attached doesn't provide the rich data it does provide essential data that's good enough and much more quickly!
I've taken the code generously provided by David Mannering, added some additional [borrowed] code to it for getting System and Site Administrator indicators, and wrapped it up nicely into a workbook with a basic viz ready to go (v9.1). Everyone, make sure you edit the data connection for your specific Tableau Server.
I created this as a discussion because I can see the need for this to grow -- thus allowing others to contribute their workbooks and code -- and that there may be additional questions. Please read the attached document and play with the report. There are a couple additional fields, like the ones that end with "_id", that are included to help with data blending.
Please go here for the documents: Getting permission settings from the Tableau Server
Message was edited by: Toby Erkson Attachments removed to avoid duplicity and confusion. Added link to document that contains the necessary files.
9 answers
posted a file.