The name of the Tableau Server instance the datasource is published to. Used to calculate hyperlinks to content. The web protocol (http / https) used in the Item Hyperlink calculations. Set for whatever your Tableau Server uses. > '' THEN SPLIT_PART(currentsheet, '/', 3) ELSE NULL END AS customized_view_owner , CASE WHEN COALESCE(currentsheet, '') <<>> '' THEN SPLIT_PART(currentsheet, '/', 4) ELSE NULL END AS customized_view_name FROM http_requests AS h LEFT JOIN sites AS s ON h.site_id = s.id]]> -- Views SELECT v.id AS item_id , v.luid AS item_luid , REPLACE(hv.repository_url, '/sheets', '') AS repository_url, COALESCE ( v.name , hv.view_name ) AS item_name , 'View' AS item_type , v.owner_id , v.site_id , w.id AS workbook_id , w_pc.project_id FROM ( SELECT repository_url , MAX(view_id) AS view_id , MAX(view_name) AS view_name FROM ( SELECT repository_url , view_id , FIRST_VALUE(name) OVER (PARTITION BY view_id ORDER BY id DESC) AS view_name FROM hist_views ) as hv GROUP BY repository_url UNION -- why is this query needed? Because for some reason, not all views records have a hist_views record. SELECT v.repository_url , v.id AS view_id , v.name AS view_name FROM views v ) AS hv LEFT JOIN views v ON hv.view_id = v.id LEFT JOIN workbooks w ON v.workbook_id = w.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' UNION ALL -- Workbooks SELECT w.id AS item_id , w.luid AS item_luid , REPLACE(hw.repository_url, '/sheets', '') AS repository_url , COALESCE ( w.name , hw.workbook_name ) AS item_name , 'Workbook' AS item_type , w.owner_id , w.site_id , w.id AS workbook_id , w_pc.project_id FROM ( SELECT repository_url , MAX(workbook_id) AS workbook_id , MAX(workbook_name) AS workbook_name FROM ( SELECT repository_url , workbook_id , FIRST_VALUE(name) OVER (PARTITION BY workbook_id ORDER BY id DESC) AS workbook_name FROM hist_workbooks ) as hw GROUP BY repository_url UNION -- why is this query needed? Because for some reason, not all workbooks records have a hist_workbooks record. SELECT w.repository_url , w.id AS workbook_id , w.name AS workbook_name FROM workbooks w ) AS hw LEFT JOIN workbooks w ON hw.workbook_id = w.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' UNION ALL -- Data Sources SELECT d.id AS item_id , d.luid AS item_luid , REPLACE(hd.repository_url, '/sheets', '') AS repository_url , COALESCE ( d.name , hd.datasource_name ) AS item_name , 'Data Source' AS item_type , d.owner_id , d.site_id , NULL AS workbook_id , d_pc.project_id FROM ( SELECT repository_url , MAX(datasource_id) AS datasource_id , MAX(datasource_name) AS datasource_name FROM ( SELECT repository_url , datasource_id , FIRST_VALUE(name) OVER (PARTITION BY datasource_id ORDER BY id DESC) AS datasource_name FROM hist_datasources ) as hd GROUP BY repository_url UNION -- why is this query needed? Because for some reason, not all datasources records have a hist_datasources record. SELECT d.repository_url , d.id AS datasource_id , d.name FROM datasources d WHERE d.connectable = True ) AS hd LEFT JOIN datasources d ON hd.datasource_id = d.id 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' --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 --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 action 129 [action] [HTTP Requests] action 1 string Count 255 true "true" [Migrated Data] completed_at 135 [completed_at] [HTTP Requests] completed_at 2 datetime Year true [Migrated Data] controller 129 [controller] [HTTP Requests] controller 3 string Count 255 true "true" [Migrated Data] created_at 135 [created_at] [HTTP Requests] created_at 4 datetime Year true [Migrated Data] currentsheet 129 [currentsheet] [HTTP Requests] currentsheet 5 string Count 255 true "true" [Migrated Data] http_referer 129 [http_referer] [HTTP Requests] http_referer 6 string Count 255 true "true" [Migrated Data] http_user_agent 129 [http_user_agent] [HTTP Requests] http_user_agent 7 string Count 255 true "true" [Migrated Data] http_request_uri 129 [http_request_uri] [HTTP Requests] http_request_uri 8 string Count 2147483647 true true "true" [Migrated Data] remote_ip 129 [remote_ip] [HTTP Requests] remote_ip 9 string Count 255 true "true" [Migrated Data] session_id 129 [session_id] [HTTP Requests] session_id 10 string Count 255 true "true" [Migrated Data] user_cookie 129 [user_cookie] [HTTP Requests] user_cookie 11 string Count 255 true "true" [Migrated Data] user_ip 129 [user_ip] [HTTP Requests] user_ip 12 string Count 255 true "true" [Migrated Data] vizql_session 129 [vizql_session] [HTTP Requests] vizql_session 13 string Count 2147483647 true true "true" [Migrated Data] worker 129 [worker] [HTTP Requests] worker 14 string Count 255 true "true" [Migrated Data] id 20 [id] [HTTP Requests] id 15 integer Sum 19 true [Migrated Data] port 3 [port] [HTTP Requests] port 16 integer Sum 10 true [Migrated Data] site_id 3 [site_id] [HTTP Requests] site_id 17 integer Sum 10 true [Migrated Data] status 3 [status] [HTTP Requests] status 18 integer Sum 10 true [Migrated Data] user_id_imputed 3 [user_id_imputed] [HTTP Requests] user_id_imputed 19 integer Sum 10 true [Migrated Data] user_id 3 [user_id] [HTTP Requests] user_id 20 integer Sum 10 true [Migrated Data] user_id_imputation_method 129 [user_id_imputation_method] [HTTP Requests] user_id_imputation_method 21 string Count 2147483647 true true "true" [Migrated Data] item_repository_url 129 [item_repository_url] [HTTP Requests] item_repository_url 22 string Count 2147483647 true true "true" [Migrated Data] item_type 129 [item_type] [HTTP Requests] item_type 23 string Count 2147483647 true true "true" [Migrated Data] customized_view_owner 129 [customized_view_owner] [HTTP Requests] customized_view_owner 24 string Count 2147483647 true true "true" [Migrated Data] customized_view_name 129 [customized_view_name] [HTTP Requests] customized_view_name 25 string Count 2147483647 true true "true" [Migrated Data] item_id 3 [item_id] [Content] item_id 27 integer Sum 10 true [Migrated Data] item_luid 72 [item_luid] [Content] item_luid 28 string Count 2147483647 true [Migrated Data] repository_url 129 [repository_url] [Content] repository_url 29 string Count 2147483647 true true "true" [Migrated Data] item_name 129 [item_name] [Content] item_name 30 string Count 2147483647 true "true" [Migrated Data] item_type 129 [item_type (Custom SQL Query)] [Content] item_type 31 string Count 2147483647 true true "true" [Migrated Data] owner_id 3 [owner_id] [Content] owner_id 32 integer Sum 10 true [Migrated Data] site_id 3 [site_id (Custom SQL Query)] [Content] site_id 33 integer Sum 10 true [Migrated Data] workbook_id 3 [workbook_id] [Content] workbook_id 34 integer Sum 10 true [Migrated Data] project_id 3 [project_id] [Content] project_id 35 integer Sum 10 true [Migrated Data] id 3 [id (projects)] [projects] id 37 integer Sum 10 true [Migrated Data] name 129 [name] [projects] name 38 string Count 255 true "true" [Migrated Data] owner_id 3 [owner_id (projects)] [projects] owner_id 39 integer Sum 10 true [Migrated Data] created_at 135 [created_at (projects)] [projects] created_at 40 datetime Year true [Migrated Data] updated_at 135 [updated_at] [projects] updated_at 41 datetime Year true [Migrated Data] state 129 [state] [projects] state 42 string Count 32 true "true" [Migrated Data] description 129 [description] [projects] description 43 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (projects)] [projects] site_id 44 integer Sum 10 true [Migrated Data] special 3 [special] [projects] special 45 integer Sum 10 true [Migrated Data] luid 72 [luid] [projects] luid 46 string Count 2147483647 true [Migrated Data] controlled_permissions_enabled 11 [controlled_permissions_enabled] [projects] controlled_permissions_enabled 47 boolean Count true [Migrated Data] parent_project_id 3 [parent_project_id] [projects] parent_project_id 48 integer Sum 10 true [Migrated Data] admin_insights_enabled 11 [admin_insights_enabled] [projects] admin_insights_enabled 49 boolean Count true [Migrated Data] nested_projects_permissions_included 11 [nested_projects_permissions_included] [projects] nested_projects_permissions_included 50 boolean Count true [Migrated Data] controlling_permissions_project_id 3 [controlling_permissions_project_id] [projects] controlling_permissions_project_id 51 integer Sum 10 true [Migrated Data] lower_name 129 [lower_name] [projects] lower_name 52 string Count 255 true "true" [Migrated Data] id 3 [id (users)] [users (Project Owner)] id 54 integer Sum 10 true [Migrated Data] login_at 135 [login_at] [users (Project Owner)] login_at 55 datetime Year true [Migrated Data] nonce 129 [nonce] [users (Project Owner)] nonce 56 string Count 32 true "true" [Migrated Data] row_limit 3 [row_limit] [users (Project Owner)] row_limit 57 integer Sum 10 true [Migrated Data] storage_limit 3 [storage_limit] [users (Project Owner)] storage_limit 58 integer Sum 10 true [Migrated Data] created_at 135 [created_at (users)] [users (Project Owner)] created_at 59 datetime Year true [Migrated Data] extracts_required 11 [extracts_required] [users (Project Owner)] extracts_required 60 boolean Count true [Migrated Data] updated_at 135 [updated_at (users)] [users (Project Owner)] updated_at 61 datetime Year true [Migrated Data] raw_data_suppressor_tristate 3 [raw_data_suppressor_tristate] [users (Project Owner)] raw_data_suppressor_tristate 62 integer Sum 10 true [Migrated Data] site_id 3 [site_id (users)] [users (Project Owner)] site_id 63 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id] [users (Project Owner)] system_user_id 64 integer Sum 10 true [Migrated Data] system_admin_auto 11 [system_admin_auto] [users (Project Owner)] system_admin_auto 65 boolean Count true [Migrated Data] luid 72 [luid (users)] [users (Project Owner)] luid 66 string Count 2147483647 true [Migrated Data] lock_version 3 [lock_version] [users (Project Owner)] lock_version 67 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id] [users (Project Owner)] site_role_id 68 integer Sum 10 true [Migrated Data] id 3 [id (system_users)] [system_users (Project Owner)] id 70 integer Sum 10 true [Migrated Data] name 129 [name (system_users)] [system_users (Project Owner)] name 71 string Count 255 true "true" [Migrated Data] email 129 [email] [system_users (Project Owner)] email 72 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password] [system_users (Project Owner)] hashed_password 73 string Count 255 true "true" [Migrated Data] salt 129 [salt] [system_users (Project Owner)] salt 74 string Count 255 true "true" [Migrated Data] sys 11 [sys] [system_users (Project Owner)] sys 75 boolean Count true [Migrated Data] keychain 129 [keychain] [system_users (Project Owner)] keychain 76 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id] [system_users (Project Owner)] domain_id 77 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name] [system_users (Project Owner)] friendly_name 78 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name] [system_users (Project Owner)] custom_display_name 79 boolean Count true [Migrated Data] activation_code 129 [activation_code] [system_users (Project Owner)] activation_code 80 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at] [system_users (Project Owner)] activated_at 81 datetime Year true [Migrated Data] state 129 [state (system_users)] [system_users (Project Owner)] state 82 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level] [system_users (Project Owner)] admin_level 83 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users)] [system_users (Project Owner)] created_at 84 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users)] [system_users (Project Owner)] updated_at 85 datetime Year true [Migrated Data] deleted_at 135 [deleted_at] [system_users (Project Owner)] deleted_at 86 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id] [system_users (Project Owner)] auth_user_id 87 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id] [system_users (Project Owner)] asset_key_id 88 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (system_users)] [system_users (Project Owner)] lock_version 89 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update] [system_users (Project Owner)] last_password_update 90 datetime Year true [Migrated Data] force_password_update 11 [force_password_update] [system_users (Project Owner)] force_password_update 91 boolean Count true [Migrated Data] protected_password 129 [protected_password] [system_users (Project Owner)] protected_password 92 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login] [system_users (Project Owner)] last_failed_login 93 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts] [system_users (Project Owner)] failed_login_attempts 94 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format] [system_users (Project Owner)] protected_password_bad_format 95 boolean Count true [Migrated Data] id 3 [id (users) #1] [users (Actor)] id 97 integer Sum 10 true [Migrated Data] login_at 135 [login_at (users)] [users (Actor)] login_at 98 datetime Year true [Migrated Data] nonce 129 [nonce (users)] [users (Actor)] nonce 99 string Count 32 true "true" [Migrated Data] row_limit 3 [row_limit (users)] [users (Actor)] row_limit 100 integer Sum 10 true [Migrated Data] storage_limit 3 [storage_limit (users)] [users (Actor)] storage_limit 101 integer Sum 10 true [Migrated Data] created_at 135 [created_at (users) #1] [users (Actor)] created_at 102 datetime Year true [Migrated Data] extracts_required 11 [extracts_required (users)] [users (Actor)] extracts_required 103 boolean Count true [Migrated Data] updated_at 135 [updated_at (users) #1] [users (Actor)] updated_at 104 datetime Year true [Migrated Data] raw_data_suppressor_tristate 3 [raw_data_suppressor_tristate (users)] [users (Actor)] raw_data_suppressor_tristate 105 integer Sum 10 true [Migrated Data] site_id 3 [site_id (users) #1] [users (Actor)] site_id 106 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id (users)] [users (Actor)] system_user_id 107 integer Sum 10 true [Migrated Data] system_admin_auto 11 [system_admin_auto (users)] [users (Actor)] system_admin_auto 108 boolean Count true [Migrated Data] luid 72 [luid (users) #1] [users (Actor)] luid 109 string Count 2147483647 true [Migrated Data] lock_version 3 [lock_version (users)] [users (Actor)] lock_version 110 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id (users (Actor))] [users (Actor)] site_role_id 111 integer Sum 10 true [Migrated Data] id 3 [id (system_users) #1] [system_users (Actor)] id 113 integer Sum 10 true [Migrated Data] name 129 [name (system_users) #1] [system_users (Actor)] name 114 string Count 255 true "true" [Migrated Data] email 129 [email (system_users)] [system_users (Actor)] email 115 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password (system_users)] [system_users (Actor)] hashed_password 116 string Count 255 true "true" [Migrated Data] salt 129 [salt (system_users)] [system_users (Actor)] salt 117 string Count 255 true "true" [Migrated Data] sys 11 [sys (system_users)] [system_users (Actor)] sys 118 boolean Count true [Migrated Data] keychain 129 [keychain (system_users)] [system_users (Actor)] keychain 119 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id (system_users)] [system_users (Actor)] domain_id 120 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name (system_users)] [system_users (Actor)] friendly_name 121 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name (system_users)] [system_users (Actor)] custom_display_name 122 boolean Count true [Migrated Data] activation_code 129 [activation_code (system_users)] [system_users (Actor)] activation_code 123 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at (system_users)] [system_users (Actor)] activated_at 124 datetime Year true [Migrated Data] state 129 [state (system_users) #1] [system_users (Actor)] state 125 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level (system_users)] [system_users (Actor)] admin_level 126 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users) #1] [system_users (Actor)] created_at 127 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users) #1] [system_users (Actor)] updated_at 128 datetime Year true [Migrated Data] deleted_at 135 [deleted_at (system_users)] [system_users (Actor)] deleted_at 129 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id (system_users)] [system_users (Actor)] auth_user_id 130 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id (system_users)] [system_users (Actor)] asset_key_id 131 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (system_users) #1] [system_users (Actor)] lock_version 132 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update (system_users (Actor))] [system_users (Actor)] last_password_update 133 datetime Year true [Migrated Data] force_password_update 11 [force_password_update (system_users (Actor))] [system_users (Actor)] force_password_update 134 boolean Count true [Migrated Data] protected_password 129 [protected_password (system_users (Actor))] [system_users (Actor)] protected_password 135 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login (system_users (Actor))] [system_users (Actor)] last_failed_login 136 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts (system_users (Actor))] [system_users (Actor)] failed_login_attempts 137 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format (system_users (Actor))] [system_users (Actor)] protected_password_bad_format 138 boolean Count true [Migrated Data] id 3 [id (sites)] [sites] id 140 integer Sum 10 true [Migrated Data] name 129 [name (sites)] [sites] name 141 string Count 255 true "true" [Migrated Data] url_namespace 129 [url_namespace] [sites] url_namespace 142 string Count 255 true "true" [Migrated Data] status 129 [status (sites)] [sites] status 143 string Count 255 true "true" [Migrated Data] created_at 135 [created_at (sites)] [sites] created_at 144 datetime Year true [Migrated Data] updated_at 135 [updated_at (sites)] [sites] updated_at 145 datetime Year true [Migrated Data] user_quota 3 [user_quota] [sites] user_quota 146 integer Sum 10 true [Migrated Data] content_admin_mode 3 [content_admin_mode] [sites] content_admin_mode 147 integer Sum 10 true [Migrated Data] storage_quota 20 [storage_quota] [sites] storage_quota 148 integer Sum 19 true [Migrated Data] metrics_level 2 [metrics_level] [sites] metrics_level 149 integer Sum 5 true [Migrated Data] status_reason 129 [status_reason] [sites] status_reason 150 string Count 255 true "true" [Migrated Data] subscriptions_enabled 11 [subscriptions_enabled] [sites] subscriptions_enabled 151 boolean Count true [Migrated Data] custom_subscription_footer 129 [custom_subscription_footer] [sites] custom_subscription_footer 152 string Count 2147483647 true true "true" [Migrated Data] custom_subscription_email 129 [custom_subscription_email] [sites] custom_subscription_email 153 string Count 2147483647 true true "true" [Migrated Data] luid 72 [luid (sites)] [sites] luid 154 string Count 2147483647 true [Migrated Data] query_limit 3 [query_limit] [sites] query_limit 155 integer Sum 10 true [Migrated Data] authoring_disabled 11 [authoring_disabled] [sites] authoring_disabled 156 boolean Count true [Migrated Data] sheet_image_enabled 11 [sheet_image_enabled] [sites] sheet_image_enabled 157 boolean Count true [Migrated Data] refresh_token_setting 3 [refresh_token_setting] [sites] refresh_token_setting 158 integer Sum 10 true [Migrated Data] version_history_enabled 11 [version_history_enabled] [sites] version_history_enabled 159 boolean Count true [Migrated Data] notification_enabled 11 [notification_enabled] [sites] notification_enabled 160 boolean Count true [Migrated Data] content_version_limit 3 [content_version_limit] [sites] content_version_limit 161 integer Sum 10 true [Migrated Data] subscribe_others_enabled 11 [subscribe_others_enabled] [sites] subscribe_others_enabled 162 boolean Count true [Migrated Data] lock_version 3 [lock_version (sites)] [sites] lock_version 163 integer Sum 10 true [Migrated Data] guest_access_enabled 11 [guest_access_enabled] [sites] guest_access_enabled 164 boolean Count true [Migrated Data] support_access_enabled 11 [support_access_enabled] [sites] support_access_enabled 165 boolean Count true [Migrated Data] cache_warmup_enabled 11 [cache_warmup_enabled] [sites] cache_warmup_enabled 166 boolean Count true [Migrated Data] cache_warmup_threshold 2 [cache_warmup_threshold] [sites] cache_warmup_threshold 167 integer Sum 5 true [Migrated Data] data_alerts_enabled 11 [data_alerts_enabled] [sites] data_alerts_enabled 168 boolean Count true [Migrated Data] allow_live_query_sync 11 [allow_live_query_sync] [sites] allow_live_query_sync 169 boolean Count true [Migrated Data] commenting_enabled 11 [commenting_enabled] [sites] commenting_enabled 170 boolean Count true [Migrated Data] self_service_schedules_enabled 11 [self_service_schedules_enabled] [sites] self_service_schedules_enabled 171 boolean Count true [Migrated Data] tier_interactor_capacity 3 [tier_interactor_capacity] [sites] tier_interactor_capacity 172 integer Sum 10 true [Migrated Data] tier_basic_user_capacity 3 [tier_basic_user_capacity] [sites] tier_basic_user_capacity 173 integer Sum 10 true [Migrated Data] tier_author_capacity 3 [tier_author_capacity] [sites] tier_author_capacity 174 integer Sum 10 true [Migrated Data] viz_in_tooltip_enabled 11 [viz_in_tooltip_enabled] [sites] viz_in_tooltip_enabled 175 boolean Count true [Migrated Data] protocol_cache_lifetime 3 [protocol_cache_lifetime] [sites] protocol_cache_lifetime 176 integer Sum 10 true [Migrated Data] protocol_group_size_limit 3 [protocol_group_size_limit] [sites] protocol_group_size_limit 177 integer Sum 10 true [Migrated Data] commenting_mentions_enabled 11 [commenting_mentions_enabled] [sites] commenting_mentions_enabled 178 boolean Count true [Migrated Data] mixed_content_enabled 11 [mixed_content_enabled] [sites] mixed_content_enabled 179 boolean Count true [Migrated Data] site_invite_notification_enabled 11 [site_invite_notification_enabled] [sites] site_invite_notification_enabled 180 boolean Count true [Migrated Data] extract_encryption_mode 2 [extract_encryption_mode] [sites] extract_encryption_mode 181 integer Sum 5 true [Migrated Data] flows_enabled 11 [flows_enabled] [sites] flows_enabled 182 boolean Count true [Migrated Data] materialized_views_enabled 11 [materialized_views_enabled] [sites] materialized_views_enabled 183 boolean Count true [Migrated Data] allow_subscriptions_attach_pdf 11 [allow_subscriptions_attach_pdf] [sites] allow_subscriptions_attach_pdf 184 boolean Count true [Migrated Data] materialized_views_mode 2 [materialized_views_mode] [sites] materialized_views_mode 185 integer Sum 5 true [Migrated Data] start_page_uri 129 [start_page_uri] [sites] start_page_uri 186 string Count 2147483647 true true "true" [Migrated Data] afe_enabled 11 [afe_enabled] [sites] afe_enabled 187 boolean Count true [Migrated Data] sandbox_enabled 11 [sandbox_enabled] [sites] sandbox_enabled 188 boolean Count true [Migrated Data] viz_recs_enabled 11 [viz_recs_enabled] [sites] viz_recs_enabled 189 boolean Count true [Migrated Data] biometrics_mobile_enabled 11 [biometrics_mobile_enabled] [sites] biometrics_mobile_enabled 190 boolean Count true [Migrated Data] iba_enabled 11 [iba_enabled] [sites] iba_enabled 191 boolean Count true [Migrated Data] named_sharing_enabled 11 [named_sharing_enabled] [sites] named_sharing_enabled 192 boolean Count true [Migrated Data] sandbox_storage_quota 20 [sandbox_storage_quota] [sites] sandbox_storage_quota 193 integer Sum 19 true [Migrated Data] sandbox_datasources_enabled 11 [sandbox_datasources_enabled] [sites] sandbox_datasources_enabled 194 boolean Count true [Migrated Data] sandbox_flows_enabled 11 [sandbox_flows_enabled] [sites] sandbox_flows_enabled 195 boolean Count true [Migrated Data] cataloging_enabled 11 [cataloging_enabled] [sites] cataloging_enabled 196 boolean Count true [Migrated Data] derived_permissions_enabled 11 [derived_permissions_enabled] [sites] derived_permissions_enabled 197 boolean Count true [Migrated Data] viz_recs_username_enabled 11 [viz_recs_username_enabled] [sites] viz_recs_username_enabled 198 boolean Count true [Migrated Data] user_visibility 3 [user_visibility] [sites] user_visibility 199 integer Sum 10 true [Migrated Data] request_access 3 [request_access] [sites] request_access 200 integer Sum 10 true [Migrated Data] ask_data_mode 129 [ask_data_mode] [sites] ask_data_mode 201 string Count 2147483647 true true "true" [Migrated Data] run_now_enabled 11 [run_now_enabled] [sites] run_now_enabled 202 boolean Count true [Migrated Data] web_extraction_enabled 2 [web_extraction_enabled] [sites] web_extraction_enabled 203 integer Sum 5 true [Migrated Data] metrics_enabled 11 [metrics_enabled] [sites] metrics_enabled 204 boolean Count true [Migrated Data] web_editing_enabled 11 [web_editing_enabled] [sites] web_editing_enabled 205 boolean Count true [Migrated Data] notify_site_admins_on_throttle 11 [notify_site_admins_on_throttle] [sites] notify_site_admins_on_throttle 206 boolean Count true [Migrated Data] obfuscation_enabled 11 [obfuscation_enabled] [sites] obfuscation_enabled 207 boolean Count true [Migrated Data] flow_auto_save_enabled 11 [flow_auto_save_enabled] [sites] flow_auto_save_enabled 208 boolean Count true [Migrated Data] time_zone 129 [time_zone] [sites] time_zone 209 string Count 2147483647 true true "true" [Migrated Data] public_collections_enabled 11 [public_collections_enabled] [sites] public_collections_enabled 210 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 211 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 212 boolean Count true [Migrated Data] auto_suspend_refresh_enabled 11 [auto_suspend_refresh_enabled] [sites] auto_suspend_refresh_enabled 213 boolean Count true [Migrated Data] auto_suspend_refresh_inactivity_window 3 [auto_suspend_refresh_inactivity_window] [sites] auto_suspend_refresh_inactivity_window 214 integer Sum 10 true [Migrated Data] web_zone_content_enabled 11 [web_zone_content_enabled] [sites] web_zone_content_enabled 215 boolean Count true [Migrated Data] personal_space_enabled 11 [personal_space_enabled] [sites] personal_space_enabled 216 boolean Count true [Migrated Data] personal_space_storage_quota 20 [personal_space_storage_quota] [sites] personal_space_storage_quota 217 integer Sum 19 true [Migrated Data] tag_limit 3 [tag_limit] [sites] tag_limit 218 integer Sum 10 true [Migrated Data] einstein_in_flow_enabled 11 [einstein_in_flow_enabled] [sites] einstein_in_flow_enabled 219 boolean Count true [Migrated Data] explain_data_enabled 11 [explain_data_enabled] [sites] explain_data_enabled 220 boolean Count true [Migrated Data] linked_tasks_enabled 11 [linked_tasks_enabled] [sites] linked_tasks_enabled 221 boolean Count true [Migrated Data] linked_tasks_run_now_enabled 11 [linked_tasks_run_now_enabled] [sites] linked_tasks_run_now_enabled 222 boolean Count true [Migrated Data] dqw_subscriptions_enabled 11 [dqw_subscriptions_enabled] [sites] dqw_subscriptions_enabled 223 boolean Count true [Migrated Data] flow_output_subscriptions_enabled 11 [flow_output_subscriptions_enabled] [sites] flow_output_subscriptions_enabled 224 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 225 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 226 boolean Count true [Migrated Data] flow_parameters_enabled 11 [flow_parameters_enabled] [sites] flow_parameters_enabled 227 boolean Count true [Migrated Data] flow_parameters_any_type_enabled 11 [flow_parameters_any_type_enabled] [sites] flow_parameters_any_type_enabled 228 boolean Count true [Migrated Data] admin_insights_publish_frequency 3 [admin_insights_publish_frequency] [sites] admin_insights_publish_frequency 229 integer Sum 10 true [Migrated Data] backgrounder_governance_default_limit_enabled 11 [backgrounder_governance_default_limit_enabled] [sites] backgrounder_governance_default_limit_enabled 230 boolean Count true [Migrated Data] id 3 [id (users) #2] [users (Item Owner)] id 232 integer Sum 10 true [Migrated Data] login_at 135 [login_at (users) #1] [users (Item Owner)] login_at 233 datetime Year true [Migrated Data] nonce 129 [nonce (users) #1] [users (Item Owner)] nonce 234 string Count 32 true "true" [Migrated Data] row_limit 3 [row_limit (users) #1] [users (Item Owner)] row_limit 235 integer Sum 10 true [Migrated Data] storage_limit 3 [storage_limit (users) #1] [users (Item Owner)] storage_limit 236 integer Sum 10 true [Migrated Data] created_at 135 [created_at (users) #2] [users (Item Owner)] created_at 237 datetime Year true [Migrated Data] extracts_required 11 [extracts_required (users) #1] [users (Item Owner)] extracts_required 238 boolean Count true [Migrated Data] updated_at 135 [updated_at (users) #2] [users (Item Owner)] updated_at 239 datetime Year true [Migrated Data] raw_data_suppressor_tristate 3 [raw_data_suppressor_tristate (users) #1] [users (Item Owner)] raw_data_suppressor_tristate 240 integer Sum 10 true [Migrated Data] site_id 3 [site_id (users) #2] [users (Item Owner)] site_id 241 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id (users) #1] [users (Item Owner)] system_user_id 242 integer Sum 10 true [Migrated Data] system_admin_auto 11 [system_admin_auto (users) #1] [users (Item Owner)] system_admin_auto 243 boolean Count true [Migrated Data] luid 72 [luid (users) #2] [users (Item Owner)] luid 244 string Count 2147483647 true [Migrated Data] lock_version 3 [lock_version (users) #1] [users (Item Owner)] lock_version 245 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id (users (Item Owner))] [users (Item Owner)] site_role_id 246 integer Sum 10 true [Migrated Data] id 3 [id (system_users) #2] [system_users (Item Owner)] id 248 integer Sum 10 true [Migrated Data] name 129 [name (system_users) #2] [system_users (Item Owner)] name 249 string Count 255 true "true" [Migrated Data] email 129 [email (system_users) #1] [system_users (Item Owner)] email 250 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password (system_users) #1] [system_users (Item Owner)] hashed_password 251 string Count 255 true "true" [Migrated Data] salt 129 [salt (system_users) #1] [system_users (Item Owner)] salt 252 string Count 255 true "true" [Migrated Data] sys 11 [sys (system_users) #1] [system_users (Item Owner)] sys 253 boolean Count true [Migrated Data] keychain 129 [keychain (system_users) #1] [system_users (Item Owner)] keychain 254 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id (system_users) #1] [system_users (Item Owner)] domain_id 255 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name (system_users) #1] [system_users (Item Owner)] friendly_name 256 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name (system_users) #1] [system_users (Item Owner)] custom_display_name 257 boolean Count true [Migrated Data] activation_code 129 [activation_code (system_users) #1] [system_users (Item Owner)] activation_code 258 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at (system_users) #1] [system_users (Item Owner)] activated_at 259 datetime Year true [Migrated Data] state 129 [state (system_users) #2] [system_users (Item Owner)] state 260 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level (system_users) #1] [system_users (Item Owner)] admin_level 261 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users) #2] [system_users (Item Owner)] created_at 262 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users) #2] [system_users (Item Owner)] updated_at 263 datetime Year true [Migrated Data] deleted_at 135 [deleted_at (system_users) #1] [system_users (Item Owner)] deleted_at 264 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id (system_users) #1] [system_users (Item Owner)] auth_user_id 265 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id (system_users) #1] [system_users (Item Owner)] asset_key_id 266 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (system_users) #2] [system_users (Item Owner)] lock_version 267 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update (system_users (Item Owner))] [system_users (Item Owner)] last_password_update 268 datetime Year true [Migrated Data] force_password_update 11 [force_password_update (system_users (Item Owner))] [system_users (Item Owner)] force_password_update 269 boolean Count true [Migrated Data] protected_password 129 [protected_password (system_users (Item Owner))] [system_users (Item Owner)] protected_password 270 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login (system_users (Item Owner))] [system_users (Item Owner)] last_failed_login 271 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts (system_users (Item Owner))] [system_users (Item Owner)] failed_login_attempts 272 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format (system_users (Item Owner))] [system_users (Item Owner)] protected_password_bad_format 273 boolean Count true [Migrated Data] dummy_join_field 3 [dummy_join_field] [Server Admin Permissions (Custom SQL)] dummy_join_field 275 integer Sum 10 true [Migrated Data] server_admins_string 129 [server_admins_string] [Server Admin Permissions (Custom SQL)] server_admins_string 276 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (Custom SQL Query) #1] [Site Admin Permissions (Custom SQL)] site_id 278 integer Sum 10 true [Migrated Data] site_admins_string 129 [site_admins_string] [Site Admin Permissions (Custom SQL)] site_admins_string 279 string Count 2147483647 true true "true" [Migrated Data] project_id 3 [project_id (Custom SQL Query)] [Project Leader Permissions (Custom SQL)] project_id 281 integer Sum 10 true [Migrated Data] project_leaders_string 129 [project_leaders_string] [Project Leader Permissions (Custom SQL)] project_leaders_string 282 string Count 2147483647 true true "true" [Migrated Data] The LUID of the user who sent the request Guaranteed to be unique to this user across the entire Server instance. Generally used to reference content via the Tableau Server API. The date and time that the request was completed, adjusted by the Timezone parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Æ Do not use this field for relative date filters--instead, use the non-local field. The date and time that the request was started, adjusted by the Timezone parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Æ Do not use this field for relative date filters--instead, use the non-local field. Denotes whether the request included a command to force a full refresh of the data in a view The duration of the request, in seconds 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). Specific actions taken by a user within the context of a session. There's no authoritative interpretation of these available, but most are self-explanatory. A high-level textual representation of the status returned to the client. Generally good for answering the question "did the request succeed or fail?" For a full list of possible HTTP status code descriptions, see https://en.wikipedia.org/wiki/List_of_HTTP_status_codes Denotes whether the request reflects a web edit session, either against an existing view, or a new workbook being created against a published data source. Same as Item Repository URL , except that for Views, this is the Repository URL of their parent Workbook. Determines whether the Tableau Server user accessing this data source has rights to see a given row of data. This can be set as a Data Source level filter so that it applies to anyone accessing the datasource. The duration of the request, in days (use for Gantt charts) If the request was to export data from a viz, then this field reflects the format of the export. If it was not an export, then the value is null. NOTE: Downloads of workbooks and data sources through the vizportal navigation pages are not captured in this data set. URL to jump into Web Edit mode on the view, workbook, or datasource on Tableau Server. Full URL to view the Data sources page of the workbook on Tableau Server. Full URL to view the Subscriptions page for this datasource or workbook on Tableau Server. Full URL to view the workbook or view on Tableau Server. The LUID of the user who owns the item that the request relates to Guaranteed to be unique to this user across the entire Server instance. Generally used to reference content via the Tableau Server API. Full URL to view the Details page of the datasource or workbook on Tableau Server. Full URL to view the Extract Schedule page for this datasource or workbook on Tableau Server. Full URL to download the workbook from Tableau Server. The LUID of the user who owns the project that the item relating to this request lives in. Guaranteed to be unique to this user across the entire Server instance. Generally used to reference content via the Tableau Server API. The LUID of the site the request relates to Guaranteed to be unique to this site across the entire Server instance. Generally used to reference content via the Tableau Server API. The action requested. Æ There's no authoritative interpretation of these available, but a few important ones are: Æ bootstrapSession : Main component of a viz being rendered. Focus on this for performance analysis. Æ get_customized_views : Gets a list of customized views during the process of loading a viz. Æ performPostLoadOperations : Does some cleanup after loading the viz. Æ publish : A publish event from a web edit context (publish events from Desktop are not captured). Æ save_customized_view : A user saved a customized view of a viz. Æ sessions : Most granular interactions a user has with a viz fall into this category. Use the Interaction field to analyze these in more detail. Æ sheetimage : Generate sheet images for Tableau Mobile. Æ show : Accessing a viz via alternative means--embeds, exports via URL parameter, etc. Anything else? Æ viewData : A user has viewed viz data (also see Interaction values tabdoc/get-summary-data & tabdoc/get-underlying-data ) Æ vud : A user has downloaded a text file of underlying data (also see Interaction value tabdoc/get-underlying-data ) Æ The date and time that the request was completed, adjusted by the Timezone parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Æ Do not use this field for relative date filters--instead, use the non-local field. A high-level textual representation of the status returned to the client. Generally good for answering the question "did the request succeed or fail?" For a full list of possible HTTP status code descriptions, see https://en.wikipedia.org/wiki/List_of_HTTP_status_codes The date and time that the request was completed, in UTC. The status returned to the client. You can generally interpret them as follows: 1xx (Informational): The request was received, continuing process 2xx (Successful): The request was successfully received, understood, and accepted 3xx (Redirection): Further action needs to be taken in order to complete the request 4xx (Client Error): The request contains bad syntax or cannot be fulfilled 5xx (Server Error): The server failed to fulfill an apparently valid request See the Status Code Type field for a higher-level summary of the code types. For a full list of possible HTTP status code descriptions, see https://en.wikipedia.org/wiki/List_of_HTTP_status_codes "Success" "Redirection" "Client errors" "Server errors" %all% The date and time that the request was started, adjusted by the Timezone parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Æ Do not use this field for relative date filters--instead, use the non-local field. The duration of the request, in seconds Specific actions taken by a user within the context of a session. There's no authoritative interpretation of these available, but most are self-explanatory. The action requested. Æ There's no authoritative interpretation of these available, but a few important ones are: Æ bootstrapSession : Main component of a viz being rendered. Focus on this for performance analysis. Æ get_customized_views : Gets a list of customized views during the process of loading a viz. Æ performPostLoadOperations : Does some cleanup after loading the viz. Æ publish : A publish event from a web edit context (publish events from Desktop are not captured). Æ save_customized_view : A user saved a customized view of a viz. Æ sessions : Most granular interactions a user has with a viz fall into this category. Use the Interaction field to analyze these in more detail. Æ sheetimage : Generate sheet images for Tableau Mobile. Æ show : Accessing a viz via alternative means--embeds, exports via URL parameter, etc. Anything else? Æ viewData : A user has viewed viz data (also see Interaction values tabdoc/get-summary-data & tabdoc/get-underlying-data ) Æ vud : A user has downloaded a text file of underlying data (also see Interaction value tabdoc/get-underlying-data ) Æ The date and time that the request was completed, in UTC. The date and time that the request was started, in UTC. The requested URI. A unique name for the of the item (Data Source or View) that the request relates to, derived from the ASCII characters in the name, which can be used in URLs to refer to it. If this value is null, then either: 1. The request does not relate to an item, or 2. The item information was too difficult to parse out of the HTTTP Request URI string [TS Web Requests (local copy)].[none:repository_url:nk] ([TS Web Requests (local copy)].[none:Calculation_299207941369360384:nk] * [TS Web Requests (local copy)].[avg:Calculation_1758937170226204672:qk])[TS Web Requests (local copy)].[thr:Calculation_1180224621576609793:qk]