1 Reply Latest reply on May 31, 2017 12:30 PM by Toby Erkson

    Workgroup database: Workbooks Connected to Tableau Data Sources

    Jack Meussdorffer

      Hi, I'm working on a query that lists all tableau data sources owned by a server user. Now I want to expand this to include all workbooks that are connected to this data source (similar to clicking from data source -> connected workbooks)

       

      The following is my query for data source ownership, but I'm stuck because I cant seem to find any commonality between data sources and workbooks.

       

      SELECT *

      FROM _datasources

      LEFT JOIN (

        SELECT DISTINCT

        Friendly_Name,

        System_User_Id AS System_User_Id_FK

       

       

        FROM _users

      ) AS users

      ON _datasources.System_User_Id = users.System_User_Id_FK

       

       

      Thanks.