Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get CPU usage per document from System Monitor dashboard ?


Hi All,

Any idea about how to get CPU usage per document from System Monitor dashboard ?

Thanks in advance

1 Reply
Not applicable
Author

Hi Nayana

I solve this trouble with the solution above:

Monitor´s Dashboard sweep Qlikview access Log Files. So at any application in extract layer I search for those files with this basic function

Sub readFiles (root)

    For each File in filelist ('$(root)\Sessions*.log')

    vsFileCheck = index(File,'~$');

        if vsFileCheck=0 then

            Acessos:

  LOAD [Exe Type],

      [Exe Version],

      [Server Started],

      Timestamp,

      Document,

      [Document Timestamp],

      [QlikView User],

      [Exit Reason],

      [Session Start],

      [Session Duration],

      [CPU spent (s)],

      [Bytes Received],

      [Bytes Sent],

      Calls,

      Selections,

      [Authenticated user],

      [Identifying user],

      [Client machine identification],

      [Serial number],

      [Client Type],

      [Client Build Version],

      [Secure Protocol],

      [Tunnel Protocol],

      [Server Port],

      [Client Address],

      [Client Port],

      [Cal Type],

      [Cal Usage Count]

  FROM

      [$(File)] (txt, utf8, embedded labels, delimiter is '\t', msq);

    endif

  Next File;

  

  //Se não tiver arquivos de log, carrega uma estrutura vazia pra não deixar no vácuo

    Acessos:

  LOAD * INLINE

  [

  Exe Type,Exe Version,Server Started,Timestamp,Document,Document Timestamp,QlikView User,Exit Reason,Session Start,Session Duration,CPU spent (s),Bytes Received,Bytes Sent,Calls,Selections,Authenticated user,Identifying user,Client machine identification,Serial number,Client Type,Client Build Version,Secure Protocol,Tunnel Protocol,Server Port,Client Address,Client Port,Cal Type,Cal Usage Count

  ];

  //Armazena no arquivo QVD

  store Acessos into DADOS\Acessos.qvd;

  //Apaga tabela residente

  drop table Acessos;

End sub;


After that call pointing to access log directory´s as a parameter


call readFiles('C:\ProgramData\QlikTech\QlikViewServer')

The final QVD file created in this function will be contains many information about documents, CPU, memory profiles and session time by user and application and can be transformed and displayed in any application.

Hope this helps