Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
suryaa30
Contributor II

Qliksense Monitoring app for scheduled task related information

Hi All,

I want to have all my qliksense sheduled tasks details in the sheduler tab of  QMC utility to be displayed as table in  an app. How to go ahead. loveisfailstalwar1‌ ‌kush141087

Shed1.png

Any sample app or the process? where to find the details of the tasks and how to connect it to the app

I am connected to postgrase DB  in which table should i find above fields.

how can i get those fields displayed in scheduler?

Task Name

Last execution

Status

.

..

Whether from a specific log file or from a postgre sql db

shed3.png

7 Replies
kenphamvn
Contributor III

Re: Qliksense Monitoring app for scheduled task related information

Hi

You can import app name "Reloads Monitor.qvf" from "C:\ProgramData\Qlik\Sense\Repository\DefaultApps" and reload it

this app very helpful for monitor task.

Regards

suryaa30
Contributor II

Re: Qliksense Monitoring app for scheduled task related information

the app is missing in the said  location. it is enterprise edition

kenphamvn
Contributor III

Re: Qliksense Monitoring app for scheduled task related information

Hi

which qlik version you installed, i'm using Qlik Sense Sept 2017(update from June), and this this default install location on central node

Any way, i send you default app if you can't find it

suryaa30
Contributor II

Re: Qliksense Monitoring app for scheduled task related information

using version 3.2 , only central node available.  where to download the app? Kindly share the same

kenphamvn
Contributor III

Re: Qliksense Monitoring app for scheduled task related information

Hi

It's default app from Qlik June 2017, i'm not sure it's runnable on Qlik 3.2

at Qlik Sense 3.2 you can using Operations Monitor app (in default stream Monitoring  Apps ), sheet Tasks Details for monitor task (You can edit it , if you want )

suryaa30
Contributor II

Re: Qliksense Monitoring app for scheduled task related information

Thanks An Phalm,   I will anyways have to build a app from scratch, I would be more interested to know how can i get those fields displayed in scheduler?

Task Name

Last execution

Status

.

..

Whether from a specific log file or from a postgre sql db

jeshwinm
New Contributor II

Re: Qliksense Monitoring app for scheduled task related information

Hi Surya,

Connect to Postgre DB in your app and try the following code.

SELECT

  "Apps"."Name" AS "AppName",

  "ReloadTasks"."Name" AS "TaskName",

  "ExecutionResults"."StartTime",

  "ExecutionResults"."StopTime"

  "ExecutionResults"."Status"

FROM

  "Apps",

  "ExecutionResults",

  "ReloadTasks"

WHERE

  "Apps"."ID" = "ReloadTasks"."App_ID"

  AND "ReloadTasks"."ID" = "ExecutionResults"."TaskID"

  AND "ReloadTasks"."App_ID" = "ExecutionResults"."AppID"

;

Hope it helps.