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
