<_.fcp.VConnDownstreamExtractsWithWarnings.true...VConnDownstreamExtractsWithWarnings /> The timezone to display dates in. Note that functionally, this is simply an integer value representing the number of hours to offset from UTC, which dates in the Tableau Server Repository are stored in. This means that it will not necessarily be accurate for timezones with Daylight Savings in place. The name of the Tableau Server instance the datasource is published to. Used to calculate hyperlinks to content. >:-| ON s.id = s2.id LEFT JOIN tasks t ON s.id = t.obj_id AND t.type = 'SingleSubscriptionTask' LEFT JOIN views s_v ON s.view_url = REPLACE(s_v.repository_url, 'sheets/','') AND s.site_id = s_v.site_id LEFT JOIN workbooks sv_w ON s_v.workbook_id = sv_w.id LEFT JOIN projects_contents sv_w_pc ON sv_w.id = sv_w_pc.content_id AND sv_w.site_id = sv_w_pc.site_id AND sv_w_pc.content_type = 'workbook' LEFT JOIN workbooks s_w ON s.workbook_url = s_w.repository_url AND s.site_id = s_w.site_id LEFT JOIN projects_contents s_w_pc ON s_w.id = s_w_pc.content_id AND s_w.site_id = s_w_pc.site_id AND s_w_pc.content_type = 'workbook' ) AS sub ON bj.correlation_id = COALESCE(sub.task_id, sub.id) -- Sorry, I know this is crappy. It allows for an annoying data change change between 10.3 and subsequent versions. AND bj.job_name = 'Subscription Notifications' -- flows LEFT JOIN flow_run_specs frs ON (t.obj_id = frs.id AND t.obj_type = 'FlowRunSpec') LEFT JOIN flows f ON frs.flow_id = f.id LEFT JOIN projects_contents f_pc ON f.id = f_pc.content_id AND f.site_id = f_pc.site_id AND f_pc.content_type = 'flow' LEFT JOIN flows m_f --missing flows ON t.id IS NULL AND bj.subtitle = 'Flow' AND bj.title = m_f.name AND bj.site_id = m_f.site_id LEFT JOIN projects_contents m_f_pc ON m_f.id = m_f_pc.content_id AND m_f.site_id = m_f_pc.site_id AND m_f_pc.content_type = 'flow' -- datasources LEFT JOIN datasources d ON (t.obj_id = d.id AND t.obj_type = 'Datasource') LEFT JOIN projects_contents d_pc ON d.id = d_pc.content_id AND d.site_id = d_pc.site_id AND d_pc.content_type = 'datasource' LEFT JOIN datasources m_d --missing datasources ON t.id IS NULL AND bj.subtitle = 'Datasource' AND m_d.id = CAST(NULLIF(SUBSTRING(bj.args from '---\n-\s[a-zA-Z]*\n-\s([0-9]*)'), '') AS INT) --AND bj.title = m_d.name AND bj.site_id = m_d.site_id AND m_d.connectable = true LEFT JOIN projects_contents m_d_pc ON m_d.id = m_d_pc.content_id AND m_d.site_id = m_d_pc.site_id AND m_d_pc.content_type = 'datasource' LEFT JOIN ( -- used just to get the proper ID value for published datasource hyperlinks SELECT MIN(dc.id) AS "id", dc.datasource_id FROM data_connections AS dc INNER JOIN datasources AS dc_d ON dc.datasource_id = dc_d.id AND dc_d.connectable = true GROUP BY dc.datasource_id ) AS data_connections ON d.id = data_connections.datasource_id -- data alerts LEFT JOIN data_alerts da ON (bj.job_name = 'Check If Data Alert Condition Is True' AND da.id = CAST(NULLIF(SUBSTRING(bj.args from '---\n-\s[a-zA-Z]*\n-\s([0-9]*)'), '') AS INT) ) -- this is the only place the ID is stored >>:-| LEFT JOIN _customized_views da_cv ON da.customized_view_id = da_cv.id LEFT JOIN views da_v ON da.view_id = da_v.id LEFT JOIN workbooks da_w ON da.workbook_id = da_w.id LEFT JOIN projects_contents da_w_pc ON da_w.id = da_w_pc.content_id AND da_w.site_id = da_w_pc.site_id AND da_w_pc.content_type = 'workbook' -- workbooks LEFT JOIN workbooks w ON (t.obj_id = w.id AND t.obj_type = 'Workbook') OR w.id = sub.workbook_subscription_id LEFT JOIN projects_contents w_pc ON w.id = w_pc.content_id AND w.site_id = w_pc.site_id AND w_pc.content_type = 'workbook' LEFT JOIN workbooks m_w --missing workbooks ON t.id IS NULL AND bj.subtitle = 'Workbook' AND m_w.id = CAST(NULLIF(SUBSTRING(bj.args from '---\n-\s[a-zA-Z]*\n-\s([0-9]*)'), '') AS INT) --AND bj.title = m_w.name AND bj.site_id = m_w.site_id LEFT JOIN projects_contents m_w_pc ON m_w.id = m_w_pc.content_id AND m_w.site_id = m_w_pc.site_id AND m_w_pc.content_type = 'workbook' -- OPTIONAL: If the data source is too slow, add an integer parameter, then edit the name below and remove the "--" from the line. This will filter the data to just that many days ago. --WHERE age(bj.created_at) <<= INTERVAL '<<[Parameters.Your Parameter Name]>> days' -- this parameter filter exists only for efficiency]]> SELECT MIN(dc.id) AS "data_connection_id", CAST('Data Source' AS TEXT) AS "item_type", dc.datasource_id FROM data_connections AS dc INNER JOIN datasources AS dc_d ON dc.datasource_id = dc_d.id AND dc_d.connectable = true GROUP BY dc.datasource_id --This subquery obtains the users granted Project Leader permissions for each project and returns all of their usernames in the "project_leaders_string" field -- This is used for row-level security SELECT project_permissions.project_id AS project_id , ';' || string_agg(DISTINCT su.name || ';', '') AS project_leaders_string FROM public.system_users su INNER JOIN public.users u ON su.id = u.system_user_id INNER JOIN ( -- users granted project leader rights via individual assignment SELECT ngp.grantee_id AS user_id , ngp.authorizable_id AS project_id FROM public.users u INNER JOIN public.next_gen_permissions ngp ON u.id = ngp.grantee_id AND ngp.capability_id = 19 -- Project Leader permissions AND ngp.grantee_type = 'User' AND ngp.permission = 3 -- Granted to user AND ngp.authorizable_type = 'Project' UNION -- users granted project leader rights via group membership SELECT gu.user_id AS user_id , ngp.authorizable_id AS project_id FROM public.group_users gu INNER JOIN public.groups g ON gu.group_id = g.id INNER JOIN public.next_gen_permissions ngp ON gu.group_id = ngp.grantee_id AND ngp.capability_id = 19 -- Project Leader permissions AND ngp.grantee_type = 'Group' AND ngp.permission = 1 -- Granted to group AND ngp.authorizable_type = 'Project' ) AS project_permissions ON u.id = project_permissions.user_id INNER JOIN public.projects p ON project_permissions.project_id = p.id GROUP BY project_permissions.project_id ORDER BY project_permissions.project_id --This subquery obtains the users granted Server Admin privileges the entire Tableau Server instance and returns all of their usernames in the "server_admins_string" field --This is used for row-level security SELECT 1 AS dummy_join_field , ';' || string_agg(DISTINCT su.name || ';', '') AS server_admins_string FROM users u INNER JOIN system_users su ON u.system_user_id = su.id WHERE su.admin_level = 10 --This subquery obtains the users granted Site Admin privileges the entire Tableau Server Site and returns all of their usernames in the "site_admins_string" field --This is used for row-level security SELECT u.site_id , ';' || string_agg(DISTINCT su.name || ';', '') AS site_admins_string FROM users u INNER JOIN system_users su ON u.system_user_id = su.id INNER JOIN site_roles sr ON u.site_role_id = sr.id WHERE sr.name LIKE '%SiteAdmin%' GROUP BY u.site_id Job Id 3 [Job Id] [TS Background Tasks Query] Job Id 1 integer Sum 10 true [Migrated Data] Job LUID 72 [Job LUID] [TS Background Tasks Query] Job LUID 2 string Count 2147483647 true [Migrated Data] Job Name 129 [Job Name] [TS Background Tasks Query] Job Name 3 string Count 255 true "true" [Migrated Data] Progress 3 [Progress] [TS Background Tasks Query] Progress 4 integer Sum 10 true [Migrated Data] Finish Code 3 [Finish Code] [TS Background Tasks Query] Finish Code 5 integer Sum 10 true [Migrated Data] Priority 3 [Priority] [TS Background Tasks Query] Priority 6 integer Sum 10 true [Migrated Data] Notes 129 [Notes] [TS Background Tasks Query] Notes 7 string Count 2147483647 true true "true" [Migrated Data] Created At 135 [Created At] [TS Background Tasks Query] Created At 8 datetime Year true [Migrated Data] Started At 135 [Started At] [TS Background Tasks Query] Started At 9 datetime Year true [Migrated Data] Completed At 135 [Completed At] [TS Background Tasks Query] Completed At 10 datetime Year true [Migrated Data] Increment Date 135 [Increment Date] [TS Background Tasks Query] Increment Date 11 datetime Year true [Migrated Data] Current Datetime 135 [Current Datetime] [TS Background Tasks Query] Current Datetime 12 datetime Year true [Migrated Data] Site Id 3 [Site Id] [TS Background Tasks Query] Site Id 13 integer Sum 10 true [Migrated Data] Backgrounder Id 129 [Backgrounder Id] [TS Background Tasks Query] Backgrounder Id 14 string Count 255 true "true" [Migrated Data] Created On Worker 129 [Created On Worker] [TS Background Tasks Query] Created On Worker 15 string Count 255 true "true" [Migrated Data] Processed On Worker 129 [Processed On Worker] [TS Background Tasks Query] Processed On Worker 16 string Count 255 true "true" [Migrated Data] Correlation Id 3 [Correlation Id] [TS Background Tasks Query] Correlation Id 17 integer Sum 10 true [Migrated Data] Creator Id 3 [Creator Id] [TS Background Tasks Query] Creator Id 18 integer Sum 10 true [Migrated Data] Run Now 11 [Run Now] [TS Background Tasks Query] Run Now 19 boolean Count true [Migrated Data] Task Id 3 [Task Id] [TS Background Tasks Query] Task Id 20 integer Sum 10 true [Migrated Data] Consecutive Failure Count 3 [Consecutive Failure Count] [TS Background Tasks Query] Consecutive Failure Count 21 integer Sum 10 true [Migrated Data] Task State (orig) 3 [Task State (orig)] [TS Background Tasks Query] Task State (orig) 22 integer Sum 10 true [Migrated Data] Subscription Id 3 [Subscription Id] [TS Background Tasks Query] Subscription Id 23 integer Sum 10 true [Migrated Data] Item Repository Url 129 [Item Repository Url] [TS Background Tasks Query] Item Repository Url 24 string Count 2147483647 true true "true" [Migrated Data] Item Project Id 3 [Item Project Id] [TS Background Tasks Query] Item Project Id 25 integer Sum 10 true [Migrated Data] Item Owner Id 3 [Item Owner Id] [TS Background Tasks Query] Item Owner Id 26 integer Sum 10 true [Migrated Data] Item Id 3 [Item Id] [TS Background Tasks Query] Item Id 27 integer Sum 10 true [Migrated Data] Item LUID 72 [Item LUID] [TS Background Tasks Query] Item LUID 28 string Count 2147483647 true [Migrated Data] Item Name 129 [Item Name] [TS Background Tasks Query] Item Name 29 string Count 2147483647 true "true" [Migrated Data] Item Type 129 [Item Type] [TS Background Tasks Query] Item Type 30 string Count 2147483647 true true "true" [Migrated Data] Item Is Certified 11 [Item Is Certified] [TS Background Tasks Query] Item Is Certified 31 boolean Count true [Migrated Data] Data Connection Id 3 [Data Connection Id] [TS Background Tasks Query] Data Connection Id 32 integer Sum 10 true [Migrated Data] Subscriber Id 3 [Subscriber Id] [TS Background Tasks Query] Subscriber Id 33 integer Sum 10 true [Migrated Data] Subscriber Sysname 129 [Subscriber Sysname] [TS Background Tasks Query] Subscriber Sysname 34 string Count 255 true "true" [Migrated Data] Subscription Subject 129 [Subscription Subject] [TS Background Tasks Query] Subscription Subject 35 string Count 256 true "true" [Migrated Data] Subscription Workbook Id 3 [Subscription Workbook Id] [TS Background Tasks Query] Subscription Workbook Id 36 integer Sum 10 true [Migrated Data] Subscription Workbook Name 129 [Subscription Workbook Name] [TS Background Tasks Query] Subscription Workbook Name 37 string Count 255 true "true" [Migrated Data] Subscription Schedule Id 3 [Subscription Schedule Id] [TS Background Tasks Query] Subscription Schedule Id 38 integer Sum 10 true [Migrated Data] Subscribed to Custom View 11 [Subscribed to Custom View] [TS Background Tasks Query] Subscribed to Custom View 39 boolean Count true [Migrated Data] Data Alert Notification Interval (minutes) 3 [Data Alert Notification Interval (minutes)] [TS Background Tasks Query] Data Alert Notification Interval (minutes) 40 integer Sum 10 true [Migrated Data] Data Alert Last Checked At 135 [Data Alert Last Checked At] [TS Background Tasks Query] Data Alert Last Checked At 41 datetime Year true [Migrated Data] id 3 [id (sites)] [sites] id 43 integer Sum 10 true [Migrated Data] name 129 [name (sites)] [sites] name 44 string Count 255 true "true" [Migrated Data] url_namespace 129 [url_namespace] [sites] url_namespace 45 string Count 255 true "true" [Migrated Data] status 129 [status] [sites] status 46 string Count 255 true "true" [Migrated Data] created_at 135 [created_at] [sites] created_at 47 datetime Year true [Migrated Data] updated_at 135 [updated_at] [sites] updated_at 48 datetime Year true [Migrated Data] user_quota 3 [user_quota] [sites] user_quota 49 integer Sum 10 true [Migrated Data] content_admin_mode 3 [content_admin_mode] [sites] content_admin_mode 50 integer Sum 10 true [Migrated Data] storage_quota 20 [storage_quota] [sites] storage_quota 51 integer Sum 19 true [Migrated Data] metrics_level 2 [metrics_level] [sites] metrics_level 52 integer Sum 5 true [Migrated Data] status_reason 129 [status_reason] [sites] status_reason 53 string Count 255 true "true" [Migrated Data] subscriptions_enabled 11 [subscriptions_enabled] [sites] subscriptions_enabled 54 boolean Count true [Migrated Data] custom_subscription_footer 129 [custom_subscription_footer] [sites] custom_subscription_footer 55 string Count 2147483647 true true "true" [Migrated Data] custom_subscription_email 129 [custom_subscription_email] [sites] custom_subscription_email 56 string Count 2147483647 true true "true" [Migrated Data] luid 72 [luid] [sites] luid 57 string Count 2147483647 true [Migrated Data] query_limit 3 [query_limit] [sites] query_limit 58 integer Sum 10 true [Migrated Data] authoring_disabled 11 [authoring_disabled] [sites] authoring_disabled 59 boolean Count true [Migrated Data] sheet_image_enabled 11 [sheet_image_enabled] [sites] sheet_image_enabled 60 boolean Count true [Migrated Data] refresh_token_setting 3 [refresh_token_setting] [sites] refresh_token_setting 61 integer Sum 10 true [Migrated Data] version_history_enabled 11 [version_history_enabled] [sites] version_history_enabled 62 boolean Count true [Migrated Data] notification_enabled 11 [notification_enabled] [sites] notification_enabled 63 boolean Count true [Migrated Data] content_version_limit 3 [content_version_limit] [sites] content_version_limit 64 integer Sum 10 true [Migrated Data] subscribe_others_enabled 11 [subscribe_others_enabled] [sites] subscribe_others_enabled 65 boolean Count true [Migrated Data] lock_version 3 [lock_version] [sites] lock_version 66 integer Sum 10 true [Migrated Data] guest_access_enabled 11 [guest_access_enabled] [sites] guest_access_enabled 67 boolean Count true [Migrated Data] support_access_enabled 11 [support_access_enabled] [sites] support_access_enabled 68 boolean Count true [Migrated Data] cache_warmup_enabled 11 [cache_warmup_enabled] [sites] cache_warmup_enabled 69 boolean Count true [Migrated Data] cache_warmup_threshold 2 [cache_warmup_threshold] [sites] cache_warmup_threshold 70 integer Sum 5 true [Migrated Data] data_alerts_enabled 11 [data_alerts_enabled] [sites] data_alerts_enabled 71 boolean Count true [Migrated Data] allow_live_query_sync 11 [allow_live_query_sync] [sites] allow_live_query_sync 72 boolean Count true [Migrated Data] commenting_enabled 11 [commenting_enabled] [sites] commenting_enabled 73 boolean Count true [Migrated Data] self_service_schedules_enabled 11 [self_service_schedules_enabled] [sites] self_service_schedules_enabled 74 boolean Count true [Migrated Data] tier_interactor_capacity 3 [tier_interactor_capacity] [sites] tier_interactor_capacity 75 integer Sum 10 true [Migrated Data] tier_basic_user_capacity 3 [tier_basic_user_capacity] [sites] tier_basic_user_capacity 76 integer Sum 10 true [Migrated Data] tier_author_capacity 3 [tier_author_capacity] [sites] tier_author_capacity 77 integer Sum 10 true [Migrated Data] viz_in_tooltip_enabled 11 [viz_in_tooltip_enabled] [sites] viz_in_tooltip_enabled 78 boolean Count true [Migrated Data] protocol_cache_lifetime 3 [protocol_cache_lifetime] [sites] protocol_cache_lifetime 79 integer Sum 10 true [Migrated Data] protocol_group_size_limit 3 [protocol_group_size_limit] [sites] protocol_group_size_limit 80 integer Sum 10 true [Migrated Data] commenting_mentions_enabled 11 [commenting_mentions_enabled] [sites] commenting_mentions_enabled 81 boolean Count true [Migrated Data] mixed_content_enabled 11 [mixed_content_enabled] [sites] mixed_content_enabled 82 boolean Count true [Migrated Data] site_invite_notification_enabled 11 [site_invite_notification_enabled] [sites] site_invite_notification_enabled 83 boolean Count true [Migrated Data] extract_encryption_mode 2 [extract_encryption_mode] [sites] extract_encryption_mode 84 integer Sum 5 true [Migrated Data] flows_enabled 11 [flows_enabled] [sites] flows_enabled 85 boolean Count true [Migrated Data] materialized_views_enabled 11 [materialized_views_enabled] [sites] materialized_views_enabled 86 boolean Count true [Migrated Data] allow_subscriptions_attach_pdf 11 [allow_subscriptions_attach_pdf] [sites] allow_subscriptions_attach_pdf 87 boolean Count true [Migrated Data] materialized_views_mode 2 [materialized_views_mode] [sites] materialized_views_mode 88 integer Sum 5 true [Migrated Data] start_page_uri 129 [start_page_uri] [sites] start_page_uri 89 string Count 2147483647 true true "true" [Migrated Data] afe_enabled 11 [afe_enabled] [sites] afe_enabled 90 boolean Count true [Migrated Data] sandbox_enabled 11 [sandbox_enabled] [sites] sandbox_enabled 91 boolean Count true [Migrated Data] viz_recs_enabled 11 [viz_recs_enabled] [sites] viz_recs_enabled 92 boolean Count true [Migrated Data] biometrics_mobile_enabled 11 [biometrics_mobile_enabled] [sites] biometrics_mobile_enabled 93 boolean Count true [Migrated Data] iba_enabled 11 [iba_enabled] [sites] iba_enabled 94 boolean Count true [Migrated Data] named_sharing_enabled 11 [named_sharing_enabled] [sites] named_sharing_enabled 95 boolean Count true [Migrated Data] sandbox_storage_quota 20 [sandbox_storage_quota] [sites] sandbox_storage_quota 96 integer Sum 19 true [Migrated Data] sandbox_datasources_enabled 11 [sandbox_datasources_enabled] [sites] sandbox_datasources_enabled 97 boolean Count true [Migrated Data] sandbox_flows_enabled 11 [sandbox_flows_enabled] [sites] sandbox_flows_enabled 98 boolean Count true [Migrated Data] cataloging_enabled 11 [cataloging_enabled] [sites] cataloging_enabled 99 boolean Count true [Migrated Data] derived_permissions_enabled 11 [derived_permissions_enabled] [sites] derived_permissions_enabled 100 boolean Count true [Migrated Data] viz_recs_username_enabled 11 [viz_recs_username_enabled] [sites] viz_recs_username_enabled 101 boolean Count true [Migrated Data] user_visibility 3 [user_visibility] [sites] user_visibility 102 integer Sum 10 true [Migrated Data] request_access 3 [request_access] [sites] request_access 103 integer Sum 10 true [Migrated Data] ask_data_mode 129 [ask_data_mode] [sites] ask_data_mode 104 string Count 2147483647 true true "true" [Migrated Data] run_now_enabled 11 [run_now_enabled] [sites] run_now_enabled 105 boolean Count true [Migrated Data] web_extraction_enabled 2 [web_extraction_enabled] [sites] web_extraction_enabled 106 integer Sum 5 true [Migrated Data] metrics_enabled 11 [metrics_enabled] [sites] metrics_enabled 107 boolean Count true [Migrated Data] web_editing_enabled 11 [web_editing_enabled] [sites] web_editing_enabled 108 boolean Count true [Migrated Data] notify_site_admins_on_throttle 11 [notify_site_admins_on_throttle] [sites] notify_site_admins_on_throttle 109 boolean Count true [Migrated Data] obfuscation_enabled 11 [obfuscation_enabled] [sites] obfuscation_enabled 110 boolean Count true [Migrated Data] flow_auto_save_enabled 11 [flow_auto_save_enabled] [sites] flow_auto_save_enabled 111 boolean Count true [Migrated Data] time_zone 129 [time_zone] [sites] time_zone 112 string Count 2147483647 true true "true" [Migrated Data] public_collections_enabled 11 [public_collections_enabled] [sites] public_collections_enabled 113 boolean Count true [Migrated Data] self_service_schedule_for_refresh_enabled 11 [self_service_schedule_for_refresh_enabled] [sites] self_service_schedule_for_refresh_enabled 114 boolean Count true [Migrated Data] self_service_schedule_for_flow_enabled 11 [self_service_schedule_for_flow_enabled] [sites] self_service_schedule_for_flow_enabled 115 boolean Count true [Migrated Data] auto_suspend_refresh_enabled 11 [auto_suspend_refresh_enabled] [sites] auto_suspend_refresh_enabled 116 boolean Count true [Migrated Data] auto_suspend_refresh_inactivity_window 3 [auto_suspend_refresh_inactivity_window] [sites] auto_suspend_refresh_inactivity_window 117 integer Sum 10 true [Migrated Data] web_zone_content_enabled 11 [web_zone_content_enabled] [sites] web_zone_content_enabled 118 boolean Count true [Migrated Data] personal_space_enabled 11 [personal_space_enabled] [sites] personal_space_enabled 119 boolean Count true [Migrated Data] personal_space_storage_quota 20 [personal_space_storage_quota] [sites] personal_space_storage_quota 120 integer Sum 19 true [Migrated Data] tag_limit 3 [tag_limit] [sites] tag_limit 121 integer Sum 10 true [Migrated Data] einstein_in_flow_enabled 11 [einstein_in_flow_enabled] [sites] einstein_in_flow_enabled 122 boolean Count true [Migrated Data] explain_data_enabled 11 [explain_data_enabled] [sites] explain_data_enabled 123 boolean Count true [Migrated Data] linked_tasks_enabled 11 [linked_tasks_enabled] [sites] linked_tasks_enabled 124 boolean Count true [Migrated Data] linked_tasks_run_now_enabled 11 [linked_tasks_run_now_enabled] [sites] linked_tasks_run_now_enabled 125 boolean Count true [Migrated Data] dqw_subscriptions_enabled 11 [dqw_subscriptions_enabled] [sites] dqw_subscriptions_enabled 126 boolean Count true [Migrated Data] flow_output_subscriptions_enabled 11 [flow_output_subscriptions_enabled] [sites] flow_output_subscriptions_enabled 127 boolean Count true [Migrated Data] flow_output_subscriptions_data_in_email_body_enabled 11 [flow_output_subscriptions_data_in_email_body_enabled] [sites] flow_output_subscriptions_data_in_email_body_enabled 128 boolean Count true [Migrated Data] flow_output_subscriptions_data_as_email_attachment_enabled 11 [flow_output_subscriptions_data_as_email_attachment_enabled] [sites] flow_output_subscriptions_data_as_email_attachment_enabled 129 boolean Count true [Migrated Data] flow_parameters_enabled 11 [flow_parameters_enabled] [sites] flow_parameters_enabled 130 boolean Count true [Migrated Data] flow_parameters_any_type_enabled 11 [flow_parameters_any_type_enabled] [sites] flow_parameters_any_type_enabled 131 boolean Count true [Migrated Data] admin_insights_publish_frequency 3 [admin_insights_publish_frequency] [sites] admin_insights_publish_frequency 132 integer Sum 10 true [Migrated Data] backgrounder_governance_default_limit_enabled 11 [backgrounder_governance_default_limit_enabled] [sites] backgrounder_governance_default_limit_enabled 133 boolean Count true [Migrated Data] id 3 [id (projects)] [projects] id 135 integer Sum 10 true [Migrated Data] name 129 [name (projects)] [projects] name 136 string Count 255 true "true" [Migrated Data] owner_id 3 [owner_id] [projects] owner_id 137 integer Sum 10 true [Migrated Data] created_at 135 [created_at (projects)] [projects] created_at 138 datetime Year true [Migrated Data] updated_at 135 [updated_at (projects)] [projects] updated_at 139 datetime Year true [Migrated Data] state 129 [state] [projects] state 140 string Count 32 true "true" [Migrated Data] description 129 [description] [projects] description 141 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (projects)] [projects] site_id 142 integer Sum 10 true [Migrated Data] special 3 [special] [projects] special 143 integer Sum 10 true [Migrated Data] luid 72 [luid (projects)] [projects] luid 144 string Count 2147483647 true [Migrated Data] controlled_permissions_enabled 11 [controlled_permissions_enabled] [projects] controlled_permissions_enabled 145 boolean Count true [Migrated Data] parent_project_id 3 [parent_project_id] [projects] parent_project_id 146 integer Sum 10 true [Migrated Data] admin_insights_enabled 11 [admin_insights_enabled] [projects] admin_insights_enabled 147 boolean Count true [Migrated Data] nested_projects_permissions_included 11 [nested_projects_permissions_included] [projects] nested_projects_permissions_included 148 boolean Count true [Migrated Data] controlling_permissions_project_id 3 [controlling_permissions_project_id] [projects] controlling_permissions_project_id 149 integer Sum 10 true [Migrated Data] lower_name 129 [lower_name] [projects] lower_name 150 string Count 255 true "true" [Migrated Data] data_connection_id 3 [data_connection_id] [Data Connection Ids] data_connection_id 152 integer Sum 10 true [Migrated Data] item_type 129 [item_type] [Data Connection Ids] item_type 153 string Count 2147483647 true true "true" [Migrated Data] datasource_id 3 [datasource_id] [Data Connection Ids] datasource_id 154 integer Sum 10 true [Migrated Data] id 3 [id (tasks)] [tasks] id 156 integer Sum 10 true [Migrated Data] schedule_id 3 [schedule_id] [tasks] schedule_id 157 integer Sum 10 true [Migrated Data] type 129 [type] [tasks] type 158 string Count 255 true "true" [Migrated Data] priority 3 [priority] [tasks] priority 159 integer Sum 10 true [Migrated Data] obj_id 3 [obj_id] [tasks] obj_id 160 integer Sum 10 true [Migrated Data] created_at 135 [created_at (tasks)] [tasks] created_at 161 datetime Year true [Migrated Data] updated_at 135 [updated_at (tasks)] [tasks] updated_at 162 datetime Year true [Migrated Data] site_id 3 [site_id (tasks)] [tasks] site_id 163 integer Sum 10 true [Migrated Data] obj_type 129 [obj_type] [tasks] obj_type 164 string Count 255 true "true" [Migrated Data] luid 72 [luid (tasks)] [tasks] luid 165 string Count 2147483647 true [Migrated Data] consecutive_failure_count 3 [consecutive_failure_count] [tasks] consecutive_failure_count 166 integer Sum 10 true [Migrated Data] active 11 [active] [tasks] active 167 boolean Count true [Migrated Data] args 129 [args] [tasks] args 168 string Count 2147483647 true true "true" [Migrated Data] title 129 [title] [tasks] title 169 string Count 2147483647 true true "true" [Migrated Data] subtitle 129 [subtitle] [tasks] subtitle 170 string Count 2147483647 true true "true" [Migrated Data] historical_run_time 3 [historical_run_time] [tasks] historical_run_time 171 integer Sum 10 true [Migrated Data] historical_queue_time 3 [historical_queue_time] [tasks] historical_queue_time 172 integer Sum 10 true [Migrated Data] run_count 3 [run_count] [tasks] run_count 173 integer Sum 10 true [Migrated Data] state 3 [state (tasks)] [tasks] state 174 integer Sum 10 true [Migrated Data] last_success_completed_at 135 [last_success_completed_at] [tasks] last_success_completed_at 175 datetime Year true [Migrated Data] creator_id 3 [creator_id] [tasks] creator_id 176 integer Sum 10 true [Migrated Data] id 3 [id (schedules)] [schedules] id 178 integer Sum 10 true [Migrated Data] name 129 [name (schedules)] [schedules] name 179 string Count 255 true "true" [Migrated Data] active 11 [active (schedules)] [schedules] active 180 boolean Count true [Migrated Data] priority 3 [priority (schedules)] [schedules] priority 181 integer Sum 10 true [Migrated Data] schedule_type 3 [schedule_type] [schedules] schedule_type 182 integer Sum 10 true [Migrated Data] day_of_week_mask 3 [day_of_week_mask] [schedules] day_of_week_mask 183 integer Sum 10 true [Migrated Data] day_of_month_mask 3 [day_of_month_mask] [schedules] day_of_month_mask 184 integer Sum 10 true [Migrated Data] start_at_minute 3 [start_at_minute] [schedules] start_at_minute 185 integer Sum 10 true [Migrated Data] minute_interval 3 [minute_interval] [schedules] minute_interval 186 integer Sum 10 true [Migrated Data] end_at_minute 3 [end_at_minute] [schedules] end_at_minute 187 integer Sum 10 true [Migrated Data] end_schedule_at 135 [end_schedule_at] [schedules] end_schedule_at 188 datetime Year true [Migrated Data] run_next_at 135 [run_next_at] [schedules] run_next_at 189 datetime Year true [Migrated Data] created_at 135 [created_at (schedules)] [schedules] created_at 190 datetime Year true [Migrated Data] updated_at 135 [updated_at (schedules)] [schedules] updated_at 191 datetime Year true [Migrated Data] hidden 11 [hidden] [schedules] hidden 192 boolean Count true [Migrated Data] serial_collection_id 3 [serial_collection_id] [schedules] serial_collection_id 193 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (schedules)] [schedules] lock_version 194 integer Sum 10 true [Migrated Data] scheduled_action 3 [scheduled_action] [schedules] scheduled_action 195 integer Sum 10 true [Migrated Data] luid 72 [luid (schedules)] [schedules] luid 196 string Count 2147483647 true [Migrated Data] defined_by 3 [defined_by] [schedules] defined_by 197 integer Sum 10 true [Migrated Data] timezoneid 129 [timezoneid] [schedules] timezoneid 198 string Count 2147483647 true true "true" [Migrated Data] actionable 11 [actionable] [schedules] actionable 199 boolean Count true [Migrated Data] linked_task_enabled 11 [linked_task_enabled] [schedules] linked_task_enabled 200 boolean Count true [Migrated Data] id 3 [id (schedules1)] [schedules (subscriptions)] id 202 integer Sum 10 true [Migrated Data] name 129 [name (schedules1)] [schedules (subscriptions)] name 203 string Count 255 true "true" [Migrated Data] active 11 [active (schedules1)] [schedules (subscriptions)] active 204 boolean Count true [Migrated Data] priority 3 [priority (schedules1)] [schedules (subscriptions)] priority 205 integer Sum 10 true [Migrated Data] schedule_type 3 [schedule_type (schedules1)] [schedules (subscriptions)] schedule_type 206 integer Sum 10 true [Migrated Data] day_of_week_mask 3 [day_of_week_mask (schedules1)] [schedules (subscriptions)] day_of_week_mask 207 integer Sum 10 true [Migrated Data] day_of_month_mask 3 [day_of_month_mask (schedules1)] [schedules (subscriptions)] day_of_month_mask 208 integer Sum 10 true [Migrated Data] start_at_minute 3 [start_at_minute (schedules1)] [schedules (subscriptions)] start_at_minute 209 integer Sum 10 true [Migrated Data] minute_interval 3 [minute_interval (schedules1)] [schedules (subscriptions)] minute_interval 210 integer Sum 10 true [Migrated Data] end_at_minute 3 [end_at_minute (schedules1)] [schedules (subscriptions)] end_at_minute 211 integer Sum 10 true [Migrated Data] end_schedule_at 135 [end_schedule_at (schedules1)] [schedules (subscriptions)] end_schedule_at 212 datetime Year true [Migrated Data] run_next_at 135 [run_next_at (schedules1)] [schedules (subscriptions)] run_next_at 213 datetime Year true [Migrated Data] created_at 135 [created_at (schedules1)] [schedules (subscriptions)] created_at 214 datetime Year true [Migrated Data] updated_at 135 [updated_at (schedules1)] [schedules (subscriptions)] updated_at 215 datetime Year true [Migrated Data] hidden 11 [hidden (schedules1)] [schedules (subscriptions)] hidden 216 boolean Count true [Migrated Data] serial_collection_id 3 [serial_collection_id (schedules1)] [schedules (subscriptions)] serial_collection_id 217 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (schedules1)] [schedules (subscriptions)] lock_version 218 integer Sum 10 true [Migrated Data] scheduled_action 3 [scheduled_action (schedules1)] [schedules (subscriptions)] scheduled_action 219 integer Sum 10 true [Migrated Data] luid 72 [luid (schedules1)] [schedules (subscriptions)] luid 220 string Count 2147483647 true [Migrated Data] defined_by 3 [defined_by (schedules1)] [schedules (subscriptions)] defined_by 221 integer Sum 10 true [Migrated Data] timezoneid 129 [timezoneid (schedules1)] [schedules (subscriptions)] timezoneid 222 string Count 2147483647 true true "true" [Migrated Data] actionable 11 [actionable (schedules (subscriptions))] [schedules (subscriptions)] actionable 223 boolean Count true [Migrated Data] linked_task_enabled 11 [linked_task_enabled (schedules (subscriptions))] [schedules (subscriptions)] linked_task_enabled 224 boolean Count true [Migrated Data] id 3 [id (users)] [users] id 226 integer Sum 10 true [Migrated Data] login_at 135 [login_at (users)] [users] login_at 227 datetime Year true [Migrated Data] nonce 129 [nonce] [users] nonce 228 string Count 32 true "true" [Migrated Data] row_limit 3 [row_limit] [users] row_limit 229 integer Sum 10 true [Migrated Data] storage_limit 3 [storage_limit] [users] storage_limit 230 integer Sum 10 true [Migrated Data] created_at 135 [created_at (users)] [users] created_at 231 datetime Year true [Migrated Data] extracts_required 11 [extracts_required] [users] extracts_required 232 boolean Count true [Migrated Data] updated_at 135 [updated_at (users)] [users] updated_at 233 datetime Year true [Migrated Data] raw_data_suppressor_tristate 3 [raw_data_suppressor_tristate] [users] raw_data_suppressor_tristate 234 integer Sum 10 true [Migrated Data] site_id 3 [site_id (users)] [users] site_id 235 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id (users)] [users] system_user_id 236 integer Sum 10 true [Migrated Data] system_admin_auto 11 [system_admin_auto] [users] system_admin_auto 237 boolean Count true [Migrated Data] luid 72 [luid (users)] [users] luid 238 string Count 2147483647 true [Migrated Data] lock_version 3 [lock_version (users)] [users] lock_version 239 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id] [users] site_role_id 240 integer Sum 10 true [Migrated Data] id 3 [id (system_users)] [system_users] id 242 integer Sum 10 true [Migrated Data] name 129 [name] [system_users] name 243 string Count 255 true "true" [Migrated Data] email 129 [email] [system_users] email 244 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password] [system_users] hashed_password 245 string Count 255 true "true" [Migrated Data] salt 129 [salt] [system_users] salt 246 string Count 255 true "true" [Migrated Data] sys 11 [sys] [system_users] sys 247 boolean Count true [Migrated Data] keychain 129 [keychain] [system_users] keychain 248 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id] [system_users] domain_id 249 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name] [system_users] friendly_name 250 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name] [system_users] custom_display_name 251 boolean Count true [Migrated Data] activation_code 129 [activation_code] [system_users] activation_code 252 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at] [system_users] activated_at 253 datetime Year true [Migrated Data] state 129 [state (system_users)] [system_users] state 254 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level (system_users)] [system_users] admin_level 255 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users)] [system_users] created_at 256 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users)] [system_users] updated_at 257 datetime Year true [Migrated Data] deleted_at 135 [deleted_at] [system_users] deleted_at 258 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id] [system_users] auth_user_id 259 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id] [system_users] asset_key_id 260 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (system_users)] [system_users] lock_version 261 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update] [system_users] last_password_update 262 datetime Year true [Migrated Data] force_password_update 11 [force_password_update] [system_users] force_password_update 263 boolean Count true [Migrated Data] protected_password 129 [protected_password] [system_users] protected_password 264 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login] [system_users] last_failed_login 265 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts] [system_users] failed_login_attempts 266 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format] [system_users] protected_password_bad_format 267 boolean Count true [Migrated Data] project_id 3 [project_id] [Project Leader Permissions] project_id 269 integer Sum 10 true [Migrated Data] project_leaders_string 129 [project_leaders_string] [Project Leader Permissions] project_leaders_string 270 string Count 2147483647 true true "true" [Migrated Data] id 3 [id] [Project Owner Users] id 272 integer Sum 10 true [Migrated Data] login_at 135 [login_at] [Project Owner Users] login_at 273 datetime Year true [Migrated Data] nonce 129 [nonce (users1)] [Project Owner Users] nonce 274 string Count 32 true "true" [Migrated Data] row_limit 3 [row_limit (users1)] [Project Owner Users] row_limit 275 integer Sum 10 true [Migrated Data] storage_limit 3 [storage_limit (users1)] [Project Owner Users] storage_limit 276 integer Sum 10 true [Migrated Data] created_at 135 [created_at (users1)] [Project Owner Users] created_at 277 datetime Year true [Migrated Data] extracts_required 11 [extracts_required (users1)] [Project Owner Users] extracts_required 278 boolean Count true [Migrated Data] updated_at 135 [updated_at (users1)] [Project Owner Users] updated_at 279 datetime Year true [Migrated Data] raw_data_suppressor_tristate 3 [raw_data_suppressor_tristate (users1)] [Project Owner Users] raw_data_suppressor_tristate 280 integer Sum 10 true [Migrated Data] site_id 3 [site_id] [Project Owner Users] site_id 281 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id] [Project Owner Users] system_user_id 282 integer Sum 10 true [Migrated Data] system_admin_auto 11 [system_admin_auto (users1)] [Project Owner Users] system_admin_auto 283 boolean Count true [Migrated Data] luid 72 [luid (users1)] [Project Owner Users] luid 284 string Count 2147483647 true [Migrated Data] lock_version 3 [lock_version (users1)] [Project Owner Users] lock_version 285 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id (users1)] [Project Owner Users] site_role_id 286 integer Sum 10 true [Migrated Data] id 3 [id (system_users1)] [Project Owner System Users] id 288 integer Sum 10 true [Migrated Data] name 129 [name (system_users1)] [Project Owner System Users] name 289 string Count 255 true "true" [Migrated Data] email 129 [email (system_users1)] [Project Owner System Users] email 290 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password (system_users1)] [Project Owner System Users] hashed_password 291 string Count 255 true "true" [Migrated Data] salt 129 [salt (system_users1)] [Project Owner System Users] salt 292 string Count 255 true "true" [Migrated Data] sys 11 [sys (system_users1)] [Project Owner System Users] sys 293 boolean Count true [Migrated Data] keychain 129 [keychain (system_users1)] [Project Owner System Users] keychain 294 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id (system_users1)] [Project Owner System Users] domain_id 295 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name (system_users1)] [Project Owner System Users] friendly_name 296 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name (system_users1)] [Project Owner System Users] custom_display_name 297 boolean Count true [Migrated Data] activation_code 129 [activation_code (system_users1)] [Project Owner System Users] activation_code 298 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at (system_users1)] [Project Owner System Users] activated_at 299 datetime Year true [Migrated Data] state 129 [state (system_users1)] [Project Owner System Users] state 300 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level] [Project Owner System Users] admin_level 301 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users1)] [Project Owner System Users] created_at 302 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users1)] [Project Owner System Users] updated_at 303 datetime Year true [Migrated Data] deleted_at 135 [deleted_at (system_users1)] [Project Owner System Users] deleted_at 304 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id (system_users1)] [Project Owner System Users] auth_user_id 305 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id (system_users1)] [Project Owner System Users] asset_key_id 306 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (system_users1)] [Project Owner System Users] lock_version 307 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update (system_users1)] [Project Owner System Users] last_password_update 308 datetime Year true [Migrated Data] force_password_update 11 [force_password_update (system_users1)] [Project Owner System Users] force_password_update 309 boolean Count true [Migrated Data] protected_password 129 [protected_password (Project Owner System Users)] [Project Owner System Users] protected_password 310 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login (system_users1)] [Project Owner System Users] last_failed_login 311 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts (system_users1)] [Project Owner System Users] failed_login_attempts 312 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format (Project Owner System Users)] [Project Owner System Users] protected_password_bad_format 313 boolean Count true [Migrated Data] dummy_join_field 3 [dummy_join_field] [Server Admin Permissions] dummy_join_field 315 integer Sum 10 true [Migrated Data] server_admins_string 129 [server_admins_string] [Server Admin Permissions] server_admins_string 316 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (Custom SQL Query)] [Site Admin Permissions] site_id 318 integer Sum 10 true [Migrated Data] site_admins_string 129 [site_admins_string] [Site Admin Permissions] site_admins_string 319 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (_users)] [Job Creator Users] id 321 integer Sum 10 true [Migrated Data] name 129 [name (_users)] [Job Creator Users] name 322 string Count 255 true "true" [Migrated Data] login_at 135 [login_at (_users)] [Job Creator Users] login_at 323 datetime Year true [Migrated Data] friendly_name 129 [friendly_name (_users)] [Job Creator Users] friendly_name 324 string Count 255 true "true" [Migrated Data] licensing_role_id 3 [licensing_role_id] [Job Creator Users] licensing_role_id 325 integer Sum 10 true [Migrated Data] licensing_role_name 129 [licensing_role_name] [Job Creator Users] licensing_role_name 326 string Count 255 true "true" [Migrated Data] domain_id 3 [domain_id (_users)] [Job Creator Users] domain_id 327 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id (_users)] [Job Creator Users] system_user_id 328 integer Sum 10 true [Migrated Data] domain_name 129 [domain_name] [Job Creator Users] domain_name 329 string Count 255 true "true" [Migrated Data] domain_short_name 129 [domain_short_name] [Job Creator Users] domain_short_name 330 string Count 80 true "true" [Migrated Data] site_id 3 [site_id (_users)] [Job Creator Users] site_id 331 integer Sum 10 true [Migrated Data] id 3 [id (site_roles)] [site_roles] id 333 integer Sum 10 true [Migrated Data] name 129 [name (site_roles)] [site_roles] name 334 string Count 255 true "true" [Migrated Data] licensing_rank 3 [licensing_rank] [site_roles] licensing_rank 335 integer Sum 10 true [Migrated Data] display_name 129 [display_name] [site_roles] display_name 336 string Count 255 true "true" [Migrated Data] The host name of the Tableau Server worker that this background task was processed on. The worker number of the Tableau Server worker that this background task was processed on. The process number on the Tableau Server worker that this background task was processed on. The site role for the user who owns the item. This calc isn't used for anything, it's just here to keep the version of the data source, e.g. "02.01" (version set [dot] iteration). The state of the scheduled task responsible for initiating this background job. For extract refresh jobs, this is the LUID of the datasource or workbook being refreshed. For subscriptions, this is the LUID of the view or workbook subscribed to. LUIDS are primarily useful for referencing content in the Tableau Server API. Date the background task completed, in UTC offset by the parameter "TS Extract Jobs Timezone Offset (Hours)". Caveats: -Does not account for daylight savings time -Relative date filters should not use this field, or they will not work correctly Denotes the current state of the background task: In Progress Succeeded Failed Date the background task was created, in UTC offset by the parameter "TS Extract Jobs Timezone Offset (Hours)". Caveats: -Does not account for daylight savings time -Relative date filters should not use this field, or they will not work correctly Duration of the background task in seconds Flag used to test whether the current Server user should have access to the current row This calc isn't used for anything, it's just here to keep the parameters with the data source when you publish it. See http://kb.tableau.com/articles/issue/parameters-not-retained-in-Published-Data-Sources Date the background task started, in UTC offset by the parameter "TS Extract Jobs Timezone Offset (Hours)". Caveats: -Does not account for daylight savings time -Relative date filters should not use this field, or they will not work correctly Describes whether the Schedule that this background task is associated with is currently disabled. Note that due to data structure issues in Tableau Server, this information is not always available. The name of the Schedule that this background task is associated with. Note that due to data structure issues in Tableau Server, this information is not always available. The id of the Schedule that this background task is associated with. Note that due to data structure issues in Tableau Server, this information is not always available. The priority setting for the Schedule that this background task is associated with. Note that due to data structure issues in Tableau Server, this information is not always available. Date the background task completed, in UTC The number of times this task has failed. Used to link background_tasks records to other tables containing information on what items were acted on. Primarily this is a Task Id or Subscription Id. However, should those tasks or subscriptions be removed, these Ids end up pointing at nothing, as there's no historical preservation of the original items. Date the background task was created, in UTC The last time at which the the alert was checked. The interval in minutes in which to send no more than one alert. This is the Id of the connection for a data source. Note that this is only used to construct URLs to published data sources (Tableau Server does uses the connection Id rather than the data source Id). Denotes the success or failure of a background task 0 = Success 1 = Failed Full URL to download the item from Tableau Server. Full URL to view the run history page for the item on Tableau Server. Full URL to the extract refresh or flow run schedules page for the item on Tableau Server. Full URL to view the Details page for the item on Tableau Server. Full URL to view the item on Tableau Server. Full URL to the Subscriptions page for the workbook of the item on Tableau Server. For extract refresh jobs, this is the Id of the datasource or workbook being refreshed. For subscriptions, this is the Id of the view or workbook subscribed to. Denotes whether the item is certified or not. For extract refreshes, this is the name of the datasource or workbook. For subscriptions, it is the subject entered by the user when they created their subscription. For everything else, it's the "subtitle" used in the background_jobs table. User Id of the owner of the datasource or workbook. Note that for subscriptions, this is still the owner of the item subscribed to--not the subscriber themselves (though they could be the same person) URL-compatible name used by Tableau Server to uniquely identify a workbook / datasource. Denotes whether the Item is a datasource or a workbook, or what kind of subscription it is. Duration of the background task in minutes Job ID of the background task. This can be looked up in searches through the Tableau Server backgrounder logs when troubleshooting. The LUID of this background task. LUIDs are primarily useful for referencing content using the Tableau Server API. Name of the background job (could also be described as the "type" of background job, e.g. "Increment Extracts" or "Vacuum Database") Details operational info or failure information for the background task User LUID of the owner of the datasource or workbook. Note that for subscriptions, this is still the owner of the item subscribed to--not the subscriber themselves (though they could be the same person) LUIDs are primarily useful in referencing content with the Tableau Server API. Priority level the background task was executed under (derived from the schedule priority) Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. LUID of the Project that the item lives in. LUIDs are primarily useful for referencing content with the Tableau Server API. Indicates if the job was triggered by run now The LUID of the Schedule that this background task is associated with. LUIDs are primarily useful for referencing content using the Tableau Server API. Note that due to data structure issues in Tableau Server, this information is not always available. The frequency of the Schedule that this background task is associated with. Possibilities: -Hourly -Daily -Weekly -Monthly Note that due to data structure issues in Tableau Server, this information is not always available. The type of Schedule that this background task is associated with, either Extract or Subscription. Æ Note that due to data structure issues in Tableau Server, this information is not always available. Site ID of the site for the datasource or workbook as assigned by the PostgreSQL database LUID of the Site that the item lives in. LUIDs are primarily useful for referencing content with the Tableau Server API. Date the background task started, in UTC Was the subscription created against a customized view? User Id of the user whose subscription this is. System name of the user whose subscription this is. Id of the subscription run during this background task (if it was processing a subscription) Full URL to the extract refresh or flow run schedules page for the item on Tableau Server. Full URL to view the item on Tableau Server. The timezone to display dates in. Note that functionally, this is simply an integer value representing the number of hours to offset from UTC, which dates in the Tableau Server Repository are stored in. This means that it will not necessarily be accurate for timezones with Daylight Savings in place. Date the background task started, in UTC offset by the parameter "TS Extract Jobs Timezone Offset (Hours)". Caveats: -Does not account for daylight savings time -Relative date filters should not use this field, or they will not work correctly Date the background task completed, in UTC Duration of the background task in minutes Name of the background job (could also be described as the "type" of background job, e.g. "Increment Extracts" or "Vacuum Database") Date the background task started, in UTC [TS Background Tasks 2019.1 (1) (lokale Kopie)].[sum:Number of Records:qk][TS Background Tasks 2019.1 (1) (lokale Kopie)].[thr:Started At:qk] The timezone to display dates in. Note that functionally, this is simply an integer value representing the number of hours to offset from UTC, which dates in the Tableau Server Repository are stored in. This means that it will not necessarily be accurate for timezones with Daylight Savings in place. The name of the Tableau Server instance the datasource is published to. Used to calculate hyperlinks to content. For extract refresh jobs, this is the LUID of the datasource or workbook being refreshed. For subscriptions, this is the LUID of the view or workbook subscribed to. LUIDS are primarily useful for referencing content in the Tableau Server API. Denotes the current state of the background task: In Progress Succeeded Failed Date the background task started, in UTC offset by the parameter "TS Extract Jobs Timezone Offset (Hours)". Caveats: -Does not account for daylight savings time -Relative date filters should not use this field, or they will not work correctly Date the background task completed, in UTC This is the Id of the connection for a data source. Note that this is only used to construct URLs to published data sources (Tableau Server does uses the connection Id rather than the data source Id). Denotes the success or failure of a background task 0 = Success 1 = Failed Full URL to view the item on Tableau Server. For extract refresh jobs, this is the Id of the datasource or workbook being refreshed. For subscriptions, this is the Id of the view or workbook subscribed to. For extract refreshes, this is the name of the datasource or workbook. For subscriptions, it is the subject entered by the user when they created their subscription. For everything else, it's the "subtitle" used in the background_jobs table. URL-compatible name used by Tableau Server to uniquely identify a workbook / datasource. Denotes whether the Item is a datasource or a workbook, or what kind of subscription it is. Duration of the background task in minutes Name of the background job (could also be described as the "type" of background job, e.g. "Increment Extracts" or "Vacuum Database") Details operational info or failure information for the background task Date the background task started, in UTC Workbook Id that the subscription was against. This is populated for subscriptions to both individual views and entire workbooks, primarily so it can be used in hyperlinks. Duration of the background task in Days (useful for Gantt charts) The unique URL name of the site the item exists on. [TS Background Tasks 2019.1 (1) (lokale Kopie)].[none:Job Name:nk] [TS Background Tasks 2019.1 (1) (lokale Kopie)].[none:Started At:qk] [TS Background Tasks 2019.1 (1) (lokale Kopie)].[none:Notes:nk] Job Status: ]]> Started At (Local): ]]> Item Name: ]]> Duration: minutes]]> Failure Notes: ]]> [TS Background Tasks 2019.1 (1) (lokale Kopie)].[none:Item Name:nk][TS Background Tasks 2019.1 (1) (lokale Kopie)].[none:Calculation_7300619133441268:qk]