topic Qlik Sense monitor user selections at Excel exports in Archived Groups

Qlik Sense monitor user selections at Excel exports

pwagner — Tue, 22 Jul 2025 18:19:11 GMT

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

Re: Qlik Sense monitor user selections at Excel exports

Levi_Turner — Wed, 24 Jul 2019 12:55:46 GMT

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

Re: Qlik Sense monitor user selections at Excel exports

pwagner — Wed, 24 Jul 2019 12:57:06 GMT

Yes, correct.

Re: Qlik Sense monitor user selections at Excel exports

Brad_Peterman — Wed, 24 Jul 2019 13:14:31 GMT

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.

Re: Qlik Sense monitor user selections at Excel exports

pwagner — Wed, 24 Jul 2019 13:16:22 GMT

Hello Brad,

ok, thank you for the information.

Do you know which Audit Log file contains this data?

Re: Qlik Sense monitor user selections at Excel exports

Levi_Turner — Wed, 24 Jul 2019 20:07:00 GMT

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

Re: Qlik Sense monitor user selections at Excel exports

pwagner — Thu, 25 Jul 2019 05:37:20 GMT

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'?

Re: Qlik Sense monitor user selections at Excel exports

Levi_Turner — Thu, 25 Jul 2019 12:15:14 GMT

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

Re: Qlik Sense monitor user selections at Excel exports

pwagner — Fri, 02 Aug 2019 05:28:04 GMT

Hello Levi,

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

Regards, Patrick