8 Replies Latest reply on Feb 15, 2019 5:15 AM by Ajai Govind

    Custom admin views

    Twinkle Bansal

      HI Team,

       

      If anyone is having custom admin view for 'background tasks for extracts' for tableau server. Please help me with it.

        • 1. Re: Custom admin views
          Ken Flerlage

          What do you need to do with it?

          • 2. Re: Custom admin views
            Twinkle Bansal

            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

              --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

              2 of 2 people found this helpful
              • 4. Re: Custom admin views
                Twinkle Bansal

                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

                  Hi Twinkle,

                  Here you go:

                   

                  Shareable Data Sources for Tableau Server

                   

                  Download the workbook TS Background Task. The workbook has the information you're looking for.

                   

                  Regards,

                  Gerardo

                  1 of 1 people found this helpful
                  • 6. Re: Custom admin views
                    Twinkle Bansal

                    Thank you so much Gerardo for help

                    • 7. Re: Custom admin views
                      Gerardo Varela

                      You're welcome.

                       

                      Regards,

                      Gerardo

                      • 8. Re: Custom admin views
                        Ajai Govind

                        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.