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 (



        System_User_Id AS System_User_Id_FK



        FROM _users

      ) AS users

      ON _datasources.System_User_Id = users.System_User_Id_FK