Thanks for responding. The licensing_role_name field only contains unlicensed, guest, viewer and interactor info from licensed_role table.
But I am looking for link info from the roles table which contains viewer, editor, interactor, administrator, ...10 different roles value.
1 of 1 people found this helpful
ah, the role is a much longer path I believe as I think this is tied to specific content by permissions.
this is how envision it, though I don't have time to test it out until Monday. If you want, ping me on Monday.
the roles table joins to capability_roles
the capability_roles joins to capabilities
the capabilities joins to next_gen_permissions
the next_gen_permissions ties to content (i.e. workbooks, datasources)
Tainyule wu from what I have seen this isn't possible to do with a Postgres DB query. However it is possible to extract this data from the API. Take a look at this Powershell script. If this is helpful, please mark this post as such.
Thank you Luke.
Sr. Database Analyst