topic Re: Understanding the logs in QlikView

Understanding the logs

Anonymous — Tue, 24 May 2016 09:23:55 GMT

Hi All,

i am trying to caluclate the response time for every dashboard by using the Audit and session logs , for this my approach is

session start (available in session log) -Timestamp (Available in Audit log) , can we condiser this as the response time ?

i am brain storming on :

Do Time stamp in audit logs capture the time when the document is visible to user after he initiated the session by accessing the access point or it will capture the time stamp when an user do some sort of operation(selection,bookmark) on it

kkkumar82‌marcus_sommer‌AndreeBauer‌denis.legena‌Robert_Mika‌stalwar1‌stalwar1‌cleveranjos‌afd‌jimhalpert‌jagan‌tresesco‌kush141087‌hic‌

Re: Understanding the logs

Kushal_Chawda — Tue, 24 May 2016 09:34:49 GMT

see this

Qlikview log analyser

Re: Understanding the logs

Anonymous — Tue, 24 May 2016 09:45:42 GMT

appreciate your quick response ,but i am not looking at the document analyzer , i am looking for the exact information regarding what Time stamp in Audit log stores weather it is the time when the document shows up in the access point or is it the time when user do some selections.That information will suffice my requirement

Re: Understanding the logs

Kushal_Chawda — Tue, 24 May 2016 10:24:48 GMT

AFAIK, Session Start in session log is is the time when user logs into the access point. After logging in anything like selections, selecting bookmarks, sheet activation i.e any click event will be captured in Audit log timestamp.

Re: Understanding the logs

Anonymous — Tue, 24 May 2016 10:35:44 GMT

Then How can we calculate the response time for an dashboard

Response Time : The time taken by a dashboard to show up when user selects the dashboard in access point , as per your statement the logic which i am following now do not give correct output ,right?

Re: Understanding the logs

Kushal_Chawda — Tue, 24 May 2016 10:47:54 GMT

I am not sure what could be the correct logic to calculate Response time. I think when user selects the dashboard only that timestamp is captured in the log, I don't think so the time dashboard takes to load is captured in the log.

Re: Understanding the logs

Anonymous — Tue, 24 May 2016 10:52:16 GMT

yes even i think so , if you have access to logs in your company can you check ?

Re: Understanding the logs

marcus_sommer — Tue, 24 May 2016 11:01:25 GMT

You couldn't get with the timestamps from the audit-logs the response-times of an object - you will get only the time when a user had started an action like selecting values/object/sheets and so on.

If you want to look for the response-times you will need to export and analyse the mem-files, see: Recipe for a Memory Statistics analysis.

- Marcus

Re: Understanding the logs

Kushal_Chawda — Tue, 24 May 2016 11:12:10 GMT

I am sure that, Dashboard response time will not be there in any logs. Perhaps you can see the below for more details on logs in which you will get the definition of Each and every field of the logs

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Server/Content/QlikView%20Server/QVSRM_Logging.htm?q=audit%20timest…