4 Replies Latest reply on Apr 29, 2017 10:37 PM by Ben Newell

    Subscriptions by Datasource

    Ben Newell

      Good morning!

       

      I am looking for a Tableau Server Admin workbook which will connect Scheduled Subscriptions to the Data Sources for that particular view/workbook. We would like to be able to view every server/data base and tell when that server is being hit. We are able to connect the dots for extracts, but unable to tie the subscriptions all the way back to the data_connections table.

       

      Help!

       

       

      I currently have the following:

       

      select

      schedules.id as "schedules_id"

      ,schedules.name as "schedules_name"

      ,schedules.active

      ,schedules.priority

      ,schedules.schedule_type

      --,schedules.day_of_week_mask

      --,schedules.day_of_month_mask

      ,schedules.start_at_minute

      --,schedules.minute_interval

      --,schedules.end_at_minute

      --,schedules.end_schedule_at

      ,schedules.run_next_at

      ,schedules.created_at

      ,schedules.updated_at

      ,schedules.hidden

      --,schedules.serial_collection_id

      --,schedules.lock_version

      ,schedules.scheduled_action

      --,schedules.luid

       

       

      ,subscriptions.id as "subscriptions_id"

      ,subscriptions.subject

      --,subscriptions.user_id

      --,subscriptions.schedule_id

      ,subscriptions.last_sent

       

       

      ,subscriptions_views.id as "sub_views_id"

      ,subscriptions_views.subscription_id as "sub_views_subscription_id"

      ,subscriptions_views.repository_url as "sub_views_repository_url"

       

       

      ,subscriptions_workbooks.id as "sub_wb_id"

      ,subscriptions_workbooks.subscription_id as "sub_wb_subscription_id"

      ,subscriptions_workbooks.repository_url as "sub_wb_repository_url"

      ,subscriptions_workbooks.site_id as "sub_wb_site_id"

       

       

      ,views.site_id

      ,sites.name as "site_name"

      --,users.id

      --,users.login_at

      ,users.licensing_role_id

      --,users.nonce

      --,users.row_limit

      --,users.storage_limit

      --,users.created_at

      --,users.extracts_required

      --,users.updated_at

      ,users.admin_level

      --,users.publisher_tristate

      --,users.raw_data_suppressor_tristate

      --,users.site_id

      --,users.system_user_id

      --,users.system_admin_auto

      --,users.luid

      --,system_users.id

      ,system_users.name as "logon_id"

      ,system_users.email

      --,system_users.hashed_password

      --,system_users.salt

      --,system_users.sys

      --,system_users.keychain

      --,system_users.domain_id

      ,system_users.friendly_name

      --,system_users.custom_display_name

      --,system_users.activation_code

      --,system_users.activated_at

      --,system_users.state

      --,system_users.admin_level

      --,system_users.created_at

      --,system_users.updated_at

      --,system_users.deleted_at

      --,system_users.auth_user_id

      --,system_users.asset_key_id

      --,extracts.id

      --,extracts.workbook_id

      --,extracts.descriptor

      --,extracts.created_at

      --,extracts.updated_at

      --,extracts.datasource_id

       

      from schedules

      left join subscriptions on subscriptions.schedule_id=schedules.id

      left join subscriptions_views on subscriptions.id=subscriptions_views.subscription_id

      left join subscriptions_workbooks on subscriptions.id=subscriptions_workbooks.subscription_id

      left join users on subscriptions.user_id=users.id

      left join system_users on users.system_user_id=system_users.id

      left join sites on sites.id=subscriptions_workbooks.site_id

      left join views on views.id=subscriptions_views.id

      order by schedules.id