Tracking users activity

[jduenyas]

Hello gurus

(I am committing a "crime" and posting here the same question as in the Developer's folder. There is little to no action there. I am asked to be pardoned...😋)

In an attempt to track users use of a document from ACCESS POINT, I have created a small macro that writes to a .csv file in a common area. The data collected is Date, Time, UsersName, Sheet accessed, Object Accessed on Sheet.

For that I have set the Document setting to include a trigger OnAnySelect to fire the macro which happens when any selection in a table/chart/listbox happens. I have also added a call for the macro when a sheet is selected.

The issue I have is that everything works fine when I open and navigate through the document but none is happening when other users do. I have set the Requested Module Security to System Access and the Current Local Security to Allow System Access and our IT department had set permissions to allow everyone to write to the folder where the .cvs file resides.

Does anyone have an insight of why the macro does not write to the file when others use the document?

(The tracking is temporary just until I get an understanding of the usage because writing to the cvs file slows down the actions in the document)

Thanks

[marcus_sommer]

The macro-execution depends on the explicitily permission from the users. In earlier releases the user was asked per popup to allow or to deny the execution if there was an active macro but nowadays I think it has changed and per default no macros are executed and no information is shown about it (it's a bit similar to the MS office logic). This means the users itself need to activate the macros either by pressing ctrl + (shift) + m to get this popup or by editing the settings.ini.

Beside this in many countries and companies means your object to violence various laws and rules. Therefore I suggest to check for them.

Also the use of macros have more or less potential security risks which you should be aware of. Further firing triggers by nearly each interaction of the users may to impair your application especially in regard to the user experience and the performance.

Nevertheless if you want to continue with your task I suggest to discard your macro solution and to take the inbuilt audit-logging from the qlikview-server which you will find in the qmc\system\setup\qlikview servers\YOURSERVER\logging and the log-file is then within the folder of the server program data.

- Marcus

[jduenyas · Accepted solution]

Thanks Marcus.

I am aware of all that you noted. Especially the decline in performance for the user's interaction.

Will try to access the built in audit.

Thanks anyways.