How to extract this data

[#1]

Hello all,

in attachment you can see the data from xml that tasks produce.

How can I get the data, so that I can create a chart showing the usage of cpu, ram etc?

Thanks in advance

[maxgro]

try Peter suggestion here

http://community.qlik.com/message/633876#633876

[JonnyPoole]

Hi there - have you tried the governance dashboard or systems monitor ?  These utilities have already been built .

http://market.qlik.com/qlikview-governance-dashboard.html

QlikView Application: System Monitor v5.1.23

[#4]

I need that info for my own application, so that will not work.

[#5]

bump

[anbu1984]

Can you post sample data and expected output

[rwunderlich]

Use the Table File wizard to generate the correct load statement.

-Rob

[#8]

Hello Rob.

the answer is helpful, but do you know how to get data from multiple files.

When I use the wizard, it loads data within that specified range, and extracted data is like in attachment.

Can you help me?

[rwunderlich]

Please post your LOAD statement.

-Rob

[#10]

Hello Rod, here it is:

LOAD @134:139,

     @163:168,

FROM

[\\10.145.73.78\qlikview\QlikView_Server_Logs\DistributionService\REPO\TaskResults\TaskResult*.xml]

(fix, utf8, header is 3 lines, record is 7 lines);