Qlik Sense monitor user selections at Excel exports

[pwagner]

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

[Levi_Turner]

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

[pwagner]

Yes, correct.

[Brad_Peterman]

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]

Hello Brad,

ok, thank you for the information.

Do you know which Audit Log file contains this data?

[Levi_Turner · Accepted solution]

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

[pwagner]

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]

> 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]

Hello Levi,

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

Regards, Patrick