Qlik Community

Ask a Question

Monitoring & Administration

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pwagner
Partner
Partner

Qlik Sense monitor user selections at Excel exports

Hello,

we have the request to monitor what the user exports to Excel. At the moment we find the command 'Export Excel' in the QS Operations Monitor. With this we can track the user, the time and the object of the export. Unfortunately I cannot find the 'user selections' in the Operations Monitor.

Do you have an idea how to find the 'user selections' in the Operations Monitor or in the Qlik Sense Log files?

Thank you.

Best regards, Patrick

1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

Steps:

  • Go to Engines->Logging->Tracing in the QMC and set Audit log level to Debug.
    User-added image
  • Adding following lines into C:\ProgramData\Qlik\Sense\Engine\Settings.ini.

[Settings 7]
AuditLogAllSelection=1
AuditLogMessageLimit=10000

* Need an empty row after a setting in settings.ini for it to take effect. i. e. press enter after set AuditLogAllSelection=1

  • Restart the Engine service
  • Make some selections on the application via hub.
  • Go to C:\ProgramData\Qlik\Sense\Log\Engine\Trace and look for a ServerName_Audit_Engine.txt.

 

Example output (some columns removed)

Message ProxySessionId ActiveUserDirectory ActiveUserId SessionId Document Type User ObjectId
Open 58d8c198-92d8-47c1-8cf5-1a25c6d4d12f DOMAIN UserID 171a7503-0d29-4291-854d-13f5b1055b67 6e794c0a-6913-4179-ab17-06b8a5f1c8f7 Document UserDirectory=DOMAIN; UserId=UserID
Alpha: B,C,D,E,F,G,H,I,J,K,L,M,N,O,P 58d8c198-92d8-47c1-8cf5-1a25c6d4d12f DOMAIN UserID 171a7503-0d29-4291-854d-13f5b1055b67 6e794c0a-6913-4179-ab17-06b8a5f1c8f7 Selection UserDirectory=DOMAIN; UserId=UserID rWcZndX
Exported Object pjjZXH of type barchart 58d8c198-92d8-47c1-8cf5-1a25c6d4d12f DOMAIN UserID 171a7503-0d29-4291-854d-13f5b1055b67 6e794c0a-6913-4179-ab17-06b8a5f1c8f7 Export UserDirectory=DOMAIN; UserId=UserID pjjZXH

View solution in original post

8 Replies
Levi_Turner
Employee
Employee

So you want to monitor the selection state of the export?

pwagner
Partner
Partner

Yes, correct.

Brad_Peterman
Employee
Employee

The selections won't be in the same logs as the export.    They would be in the Audit Log, and would not tie out with a direct key to the export log.   You would need to perform some tricky logic to get the max datetime stamp of the audit log state, just before the export was executed, by the same user, and then you could maybe infer the selection state at export. 

pwagner
Partner
Partner

Hello Brad,

ok, thank you for the information.

Do you know which Audit Log file contains this data?

Levi_Turner
Employee
Employee

Steps:

  • Go to Engines->Logging->Tracing in the QMC and set Audit log level to Debug.
    User-added image
  • Adding following lines into C:\ProgramData\Qlik\Sense\Engine\Settings.ini.

[Settings 7]
AuditLogAllSelection=1
AuditLogMessageLimit=10000

* Need an empty row after a setting in settings.ini for it to take effect. i. e. press enter after set AuditLogAllSelection=1

  • Restart the Engine service
  • Make some selections on the application via hub.
  • Go to C:\ProgramData\Qlik\Sense\Log\Engine\Trace and look for a ServerName_Audit_Engine.txt.

 

Example output (some columns removed)

Message ProxySessionId ActiveUserDirectory ActiveUserId SessionId Document Type User ObjectId
Open 58d8c198-92d8-47c1-8cf5-1a25c6d4d12f DOMAIN UserID 171a7503-0d29-4291-854d-13f5b1055b67 6e794c0a-6913-4179-ab17-06b8a5f1c8f7 Document UserDirectory=DOMAIN; UserId=UserID
Alpha: B,C,D,E,F,G,H,I,J,K,L,M,N,O,P 58d8c198-92d8-47c1-8cf5-1a25c6d4d12f DOMAIN UserID 171a7503-0d29-4291-854d-13f5b1055b67 6e794c0a-6913-4179-ab17-06b8a5f1c8f7 Selection UserDirectory=DOMAIN; UserId=UserID rWcZndX
Exported Object pjjZXH of type barchart 58d8c198-92d8-47c1-8cf5-1a25c6d4d12f DOMAIN UserID 171a7503-0d29-4291-854d-13f5b1055b67 6e794c0a-6913-4179-ab17-06b8a5f1c8f7 Export UserDirectory=DOMAIN; UserId=UserID pjjZXH

View solution in original post

pwagner
Partner
Partner

Thank you, perfect. You showed me the last steps.

 

Two more questions:

- How is it possible to save this Audit Log day by day?

- How is it possible to exclude the data from ActiveUserId 'sa_sceduler'?

Levi_Turner
Employee
Employee

> How is it possible to save this Audit Log day by day?

This is a normal Qlik Sense log. There is an active log in %ProgramData%\Qlik\Sense\Log\Engine\Trace then the log is archived. So yes, there is data from every day.

 

> How is it possible to exclude the data from ActiveUserId 'sa_sceduler'?

In the log file itself? No. But you can certainly do filter when you load the file. For example inside of a Qlik app with a WHERE clause or similar.

pwagner
Partner
Partner

Hello Levi,

nice, thank you. I found the archived logs in folder \\TRNBIQS01\QlikDataShare\ArchivedLogs\trnbiqs01.terna-bi.com\Engine\Trace

Regards, Patrick