How to Check Number of task running in QMC in QVW file?

[#1]

Hi All,

I wanted to make a qvw file in which it will check how many task is running in QMC for every hour. So i am not able to get the source for this. From where i can get data for QMC related task.

Regards,

Ritesh

[Anonymous]

you need to take a QDS log file (Workorder_xxxxx) for that as a source.

The files located in C:\ProgramData\QlikTech\DistributionService\1\Log in the QDS

[#3]

Thanx for the reply konstantins kozins.

I got the file but i could not understand how we can calculate number of task running in QMC from 7 AM to 8 AM from that Workorder file.

It would be really helpfull if i get any qvw or example as for reference

[Anonymous]

T1:

LOAD @1,

     @2,

     @3

FROM

(txt, utf8, no labels, delimiter is '\t', msq);

T2:

Load *,

SubField(@3,chr(39),1) as Filter,

SubField(@3,chr(39),4) as JobName,

mid(@1,11,2) as hour

Resident T1

where SubField(@3,chr(39),1) = 'FireTriggerWaiterThread: Activating the trigger ';

Drop table T1;

[#5]

Great it working fine now. One more question.

There are some task which run in QMC but for that there is no data being generated in this Workorder File.

So how we can get data for those task or is there anything which has to be set in QMC?

[Anonymous]

Are those tasks run manually?

[#7]

No some of them are on EDX trigger while some on other task trigger. None of them run manually.