Tableau Server_20200927_工作簿数据提取调度信息查询

--数据提取调度任务SELECT title,rtrim(ltrim(args ,'---
- Workbook
- '),'
- 1234567890null

') 报表名称,
notes, updated_at+ interval '8 hours' 更新时间, created_at+ interval '8 hours' 创建时间, completed_at+ interval '8 hours' 完成时间, started_at+ interval '8 hours' 任务开始时间, job_name 调度类型, finish_code 完成代码,
subtitle
FROM background_jobs where to_char(created_at + interval '8 hours','yyyymmdd')='20200924' and job_name='Refresh Extracts' order by completed_at desc;

--所有工作簿更新情况
SELECT a.id, a.name 工作簿名称, repository_url 资料库url, description 描述, a.created_at+ interval '8 hours' 创建时间, a.updated_at+ interval '8 hours' 更新时间, a.owner_id 拥有者ID ,b1.name 拥有者域名,b1.friendly_name 拥有者名称,
project_id, c.name,
view_count 视图数, size 大小, 
--embedded, thumb_user, 
refreshable_extracts 是否可以刷新, extracts_refreshed_at+ interval '8 hours' 刷新时间, 
--lock_version, 
state 状态, 
--version, checksum, display_tabs, data_engine_extracts, incrementable_extracts, 
a.site_id 站点ID,d.name 站点名称, 
--revision, repository_data_id, repository_extract_data_id, 
first_published_at+ interval '8 hours' 首次发布时间, 
--primary_content_url, 
share_description, 
--show_toolbar, extracts_incremented_at, default_view_index, 
luid, 
--asset_key_id, document_version, content_version, 
--last_published_at, data_id, reduced_data_id, published_all_sheets, extract_encryption_state, extract_creation_pending, 
is_deleted, 
--parent_workbook_id, is_private, 
modified_by_user_id 修改用户ID,b.name 修改者域名,b.friendly_name 修改者名称
FROM workbooks a
left join _users b on a.modified_by_user_id=b.id
left join _users b1 on a.owner_id=b1.id
left join _projects c on a.project_id=c.id
left join _sites d on a.site_id=d.id
where extracts_refreshed_at is not null
order by extracts_refreshed_at desc
;