process monitor

[Anonymous]

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

[MarcoWedel]

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

regards

Marco

[stevedark]

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