Qlikview Server log files

[#1]

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.

[#2]

Thanks Jason for your detailed reply.

Yes i have got this sheet info in audit file. I have Audit , Session , Performance & event log files too.

[jschrader · Accepted solution]

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.

[#4]

Thanks a ton Jason ..
This resolved my problem..

[Karim_Khan]

HI Jason,

   What will be the issue in my scenario below.I have just tried 100 record from debugger limited rows but then also at the same stage.

My Script code

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:redshift://ucpprd.cusjr55gdzdb.us-east-1.redshift.amazonaws.com:5439/ucpprd?ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory;XUserId=CTCZMadLULaOXQVNNF;XPassword=RBfVGadLULaOXQVNDJQIWZNJRRMGDUC;";

Directory;

T_WAR_PRODUCT:

//First 1000000

//LOAD *;

SQL SELECT *

FROM ucpprd.ucp."t_war_product";

STORE T_WAR_PRODUCT INTO D:\UCP\KK_WAR_PRODUCT.qvd (qvd);

Log Files Data 

12/21/2015 7:36:20 PM:      Execution started.

12/21/2015 7:36:20 PM:      QlikView Version:11.00.11154.0

12/21/2015 7:36:20 PM:      CPU Target                    x64

12/21/2015 7:36:20 PM:      Operating System              Windows 7 Professional Service Pack 1 (64 bit edition)

12/21/2015 7:36:20 PM:      Wow64 mode                    Not using Wow64

12/21/2015 7:36:20 PM:      MDAC Version                  6.1.7601.17514

12/21/2015 7:36:20 PM:      MDAC Full Install Version     6.1.7601.17514

12/21/2015 7:36:20 PM:      PreferredCompression          2

12/21/2015 7:36:20 PM:      EnableParallelReload          1

12/21/2015 7:36:20 PM:      ParallelizeQvdLoads           1

12/21/2015 7:36:20 PM:      AutoSaveAfterReload           0

12/21/2015 7:36:20 PM:      BackupBeforeReload            1

12/21/2015 7:36:20 PM:      EnableFlushLog                0

12/21/2015 7:36:20 PM:      SaveInfoWhenSavingFile        0

12/21/2015 7:36:20 PM:      UserLogfileCharset            0

12/21/2015 7:36:20 PM:      OdbcLoginTimeout              -1

12/21/2015 7:36:20 PM:      OdbcConnectionTimeout         -1

12/21/2015 7:36:20 PM:      ScriptWantsDbWrite            false

12/21/2015 7:36:20 PM:      ScriptWantsExe                false

12/21/2015 7:36:20 PM:      LogFile CodePage Used:        1252

12/21/2015 7:36:28 PM: 0002  SET ThousandSep=','

12/21/2015 7:36:28 PM: 0003  SET DecimalSep='.'

12/21/2015 7:36:28 PM: 0004  SET MoneyThousandSep=','

12/21/2015 7:36:28 PM: 0005  SET MoneyDecimalSep='.'

12/21/2015 7:36:28 PM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

12/21/2015 7:36:28 PM: 0007  SET TimeFormat='h:mm:ss TT'

12/21/2015 7:36:28 PM: 0008  SET DateFormat='M/D/YYYY'

12/21/2015 7:36:28 PM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

12/21/2015 7:36:28 PM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

12/21/2015 7:36:28 PM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

12/21/2015 7:36:28 PM: 0017  CUSTOM CONNECT*Provider*JDBCConnector_x64.dll*XUserId*XPassword*

12/21/2015 7:36:33 PM: 0018  Directory

12/21/2015 7:36:33 PM: 0019  T_WAR_PRODUCT:

12/21/2015 7:36:33 PM: 0020 

12/21/2015 7:36:33 PM: 0021 

12/21/2015 7:36:33 PM: 0022 

12/21/2015 7:36:33 PM: 0023  SQL SELECT *

12/21/2015 7:36:33 PM: 0024  FROM ucpprd.ucp."t_war_product"

12/21/2015 7:36:35 PM:       16 fields found: visit_dt, visitor_id, visit_nbr, ip_addr, hit_seq_nbr, hit_ts, site_nm, site_section_nm, product_nm, page_nm, product_view_cnt, product_edu_view_cnt, trial_initiate_cnt, cloud_initiate_cnt, edu_download_start_cnt, dt, 100 lines fetched

Regards,

Karim Khan

[jschrader]

Karmin,

Does your reload timeout? Do you receive a general script error? Do you receive an error that mentions something about your Connector?

Jason

[Karim_Khan]

No Its go into infinite loop like hung stage

[rwunderlich]

it says "Script Finished". What happens if you press the "Close" button?

[Karim_Khan]

Its get hang