-
1. Re: Custom admin views
Ken FlerlageFeb 12, 2019 7:21 AM (in response to Twinkle Bansal)
What do you need to do with it?
-
2. Re: Custom admin views
Twinkle Bansal Feb 12, 2019 7:24 AM (in response to Ken Flerlage)Actually in our project we need to send daily report for the extracts status by all schedules, whether they are success or not with the 'completed_at' time and also backgrounder id's.
-
3. Re: Custom admin views
Gerardo Varela Feb 12, 2019 9:49 AM (in response to Twinkle Bansal)2 of 2 people found this helpful--Changed Query on 9-7-2016 to eliminate
-- "_backgroun_tasks"."link" edited out
SELECT "_sites"."id" AS "site id",
"_sites"."name" AS "name",
"_sites"."url_namespace" AS "url_namespace",
"_sites"."status" AS "site status",
"_background_tasks"."backgrounder_id" AS "backgrounder_id",
"_background_tasks"."id" AS " background id",
"_background_tasks"."created_at" AS "created_at",
"_background_tasks"."completed_at" AS "completed_at",
"_background_tasks"."finish_code" AS "finish_code",
"_background_tasks"."job_type" AS "job_type",
"_background_tasks"."progress" AS "progress",
"_background_tasks"."args" AS "args",
"_background_tasks"."notes" AS "notes",
"_background_tasks"."started_at" AS "started_at",
"_background_tasks"."job_name" AS "job_name",
"_background_tasks"."priority" AS "priority",
"_background_tasks"."title" AS "title",
"_background_tasks"."processed_on_worker" AS "processed_on_worker",
--"_background_tasks"."link" AS "link",
"_background_tasks"."subtitle" AS "subtitle",
"_background_tasks"."language" AS "language",
"_background_tasks"."site_id" AS "site_id",
"_background_tasks"."locale" AS "locale",
"_background_tasks"."created_at" +0.25 * INTERVAL '1 DAY' AS "Time",
CASE WHEN "_background_tasks"."progress" = -1 THEN 'Waiting'
WHEN "_background_tasks"."progress" < 100 THEN 'In Process'
WHEN "_background_tasks"."finish_code" = 0 THEN 'Success'
ELSE 'Error' END AS "Backgrounder Status"
FROM "public"."_background_tasks" "_background_tasks"
LEFT OUTER JOIN "public"."_sites" "_sites" ON "_background_tasks"."site_id" = "_sites"."id"
WHERE "_background_tasks"."job_name" IN
('Increment Extracts', 'Reap Extracts', 'Refresh Extracts')
That'll get you what you need. I don't remember where I stole the query from so I can't give credit for it.
Regards,
Gerardo -
4. Re: Custom admin views
Twinkle Bansal Feb 12, 2019 9:55 AM (in response to Gerardo Varela)Thank you so much for the valuable information Gerardo. Is there any way we can connect this extracts information as per our schedules on server?
-
5. Re: Custom admin views
Gerardo Varela Feb 12, 2019 10:10 AM (in response to Twinkle Bansal)1 of 1 people found this helpfulHi Twinkle,
Here you go:
Tableau Server Insights (formerly Shareable Data Sources for Tableau Server)
Download the workbook TS Background Task. The workbook has the information you're looking for.
Regards,
Gerardo
-
6. Re: Custom admin views
Twinkle Bansal Feb 12, 2019 8:44 PM (in response to Gerardo Varela)Thank you so much Gerardo for help
-
7. Re: Custom admin views
Gerardo Varela Feb 13, 2019 6:49 AM (in response to Twinkle Bansal)You're welcome.
Regards,
Gerardo
-
8. Re: Custom admin views
Ajai Govind Feb 15, 2019 5:15 AM (in response to Twinkle Bansal)Twinkle Bansal I would also recommend reading through Project Griffon blogs by Ravi Mistry. Really helpful in understanding the basics and building on top of it.
-
9. Re: Custom admin views
Twinkle Bansal Feb 17, 2019 5:58 AM (in response to Ajai Govind)Thanks Ajai