Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Any idea about how to get CPU usage per document from System Monitor dashboard ?
Thanks in advance
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