process monitor

Anonymous — Sun, 23 Mar 2014 23:00:46 GMT

Dear all,

by Qmc is possible to manage processes and check their duration time.

Is it possible to create a document in order to get all the processes information without access to QMC?

Is there an example concerning this topic ?

Thanks in advance

Re: process monitor

MarcoWedel — Sun, 23 Mar 2014 23:19:11 GMT

parts of this information are included in the load log files the creation of which you can enable in the document properties:

regards

Marco

Re: process monitor

stevedark — Mon, 24 Mar 2014 00:06:41 GMT

Events are written to log files and it is possible to pick these up in QlikView.

The following code will get you started:

let vDateFormat = 'DD/MM/YYYY';

let vMonthFormat = 'MMM-YY';

let vDistributionFolder = 'c:\ProgramData\QlikTech\DistributionService\';

for each vFile in FileList('$(vDistributionFolder)TaskExecutionHistory\TaskExecutionHistory_*.xml')

SET ERRORMODE = 0; // ignore file lock errors

TaskExecutionHistoryItem:

LOAD

1 as ExecutionCount,

TaskId,

TaskLogId,

TaskStatus,

StartTimeStamp,

Date(DayStart(StartTimeStamp), '$(vDateFormat)') as Date,

Date(MonthStart(StartTimeStamp), '$(vMonthFormat)') as [Month Year],

Month(StartTimeStamp) as Month,

Year(StartTimeStamp) as Year,

Hour(StartTimeStamp) as Hour,

EndTimeStamp,

Duration

FROM [$(vFile)]

(XmlSimple, Table is [Root/TaskExecutionHistoryItems/TaskExecutionHistoryItem]);

SET ERRORMODE = 1;

next

Only a months worth of logs are kept by default. I've written an incremental load to persist old log entries to QVD. Also, I read in the task details into my version of the dashboard and have put a few objects on the front end to track performance.

When I get a chance I will tidy this up a bit and remove client specific code and branding and upload to Qlik Community.

Hope the above helps though.

Steve

topic Re: process monitor in QlikView

process monitor

Re: process monitor

Re: process monitor