Solved: Re: Qlikview Server log files - Qlik Community

Report Inappropriate Content · ‎2014-03-28

Hi,

I am building a dashboard for Auditing & Monitoring of all dashboards available in organisation. I have got qlikview server log files but it doesnt have info about which sheet accessed by users & what is the duration for it. Where can i find this info?

Thanks in advance.

jschrader · ‎2014-04-02

The next thing we need to do is figure when a session starts, what happens during the session, when the session ends, and the overall duration of the session. In the sessions log, you should see the following three columns, Session Start, Session Timestamp, and Session Duration. The Session Start is a timestamp identifying when a user first opens a document. The Session Timestamp is a timestamp that identifies when a users closes the document. The Session duration identifies how long a user had a document open. These three columns can be used to identify when a session started, when a session ended, and how long a session lasted. Yet, the sessions log do not identify what the user did while having the document open, or when the user did it. This information is contained in the audit log.

We already know from the audit log that we can identify all the activities the user engages while having a document open, but we have not yet looked at the Timestamp column. The Timestamp column identifies the time at which a user does something in the document like activate a sheet, create a bookmark, or make a selection. With the addition of the Timestamp in the audit log, we now can figure out when a user opened a document (Session Start), when a user did something in the document (Timestamp), when the user closed the document (Session Timestamp), and how long the user had the document open (Session Duration).

Hope this helps. Let me know if you have any more questions.

View solution in original post

alexandros17 · ‎2014-03-28

There are not info about sheets and objects, only documents and users

datanibbler · ‎2014-03-28

Hi Alessandro,

maybe the "QlikView_Governance_Dashboard" (a special qvw, to be found here) can provide you with that info. I haven't tested it because it requires Server_access (logical, so it can read that info)

HTH

Best regards,

DataNibbler

alexandros17 · ‎2014-03-28

I didn't find that info, please if someone gets it let me know

Thanks

jschrader · ‎2014-03-28

http://community.qlik.com/blogs/technicalbulletin/2013/12/05/qlikview-governance-dashboard-11-availa...

Here is the link to the governance dashboard.

ThornOfCrowns · ‎2014-03-28

I don't know how the info is written to the logs, but I run a dashboard that pulls Dashboard Name, Session Duration etc., from our log files, so it can be done.

jimshakes · ‎2014-03-28

Try this app as a basis:

http://community.qlik.com/docs/DOC-4307

I used this as a basis for a dashboard and was able to get session duration, along with the usage of objects etc within applications.

jschrader · ‎2014-03-28

Pallavi,

The the QMC has a logging option that will enable you to generate specific logs. In the QMC, click on system, select a server, and then select logging. At this point, you can generate different types of logs. The audit log will tell you which users are using which sheets. The session log will tell you when a user began a session and ended a session. With the information provided by these two logs, you should be able to answer questions like who accessed a document, when the document was accessed, how long did the session last, and which sheets and sheet objects were clicked.

Report Inappropriate Content · ‎2014-04-01

Thank you everyone.

Jason,

I have QMC log files which are specifically for dashboards log. But it doesnt contain information about Dashboard sheet. What I mean By Dashboard sheet is which sheet user have accessed & what is the start/end time etc..

For Qlikview Governance Dashboard

jschrader · ‎2014-04-01

Pallavi,

I think I understand what you mean, but if this response does not answer your question, then let me know. We will get everything figured out. One of the logs that the QMC generates is an audit log. In the audit log, you will need to look at two specfic columns to figure out which sheet is being opened in which document. The first column, the type column, will contain information like sheet or bookmark. The information you are looking for is sheet. If you see sheet in the type column, then you next need to look at the message column in the same row. The message column will include statement like the following one, sheet object activated\SH34. The SH34 is the sheet id that can be found in the upper right portion of sheet properties under the general tab. If possible, you should change the sheet id to something that easily helps you identify which sheet the id references. At this point, you should be able to identify any sheet that has been opened by any user. Give this a try first. If it works, then we will get into start and end times.

Jason