Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
mostal75
New Contributor III

GPDR

Hello

Do you have any idea how to list selections made by users in Qlik  Sense documents (app name, object name, fields selected, fields values) and report it for GPDR audit ?

Informations are stored in Engine_Traffic log files but I don't know how to easily parse this file.

do you have any idea please ?

Regards

Regis

 

Tags (4)
1 Solution

Accepted Solutions
Employee
Employee

Re: GPDR

Hey @mostal75,

In terms of auditing selections made by users, the following is possible:

audit-selections.pngIn this example screenshot from the log opened in Excel (for easy formatting), we can see:

  • We can see that user QTSEL\LTU opened an app with a specified GUID
  • Inside of that app the user had this sequence:
    • Selecting the QTSEL\ltu value in the UserId field
    • Clearing values
    • Selecting the INTERNAL\sa_scheduler value in the UserId field
    • Clearing values
    • Selecting the foo value in the Session App Name field

If this fits with your use case, then you can set it by:

  • Stop the Qlik Sense Engine and Qlik Sense Service Dispatcher services on all nodes with engines.
  • For each of the nodes: open Notepad as Administrator
  • Open the Settings.ini file (by default located at C:\ProgramData\Qlik\Sense\Engine\Settings.ini)
  • Modify the file to fit this schema:
    • [Settings 7]
      Key=Value

    • Note the blank line at the end of the file
  • Save the file
  • After these changes have been made on all nodes, start the Qlik Sense Engine and Qlik Sense Service Dispatcher services on each node.
  • Ensure that the Audit log level for the Engine is set to at least INFO
    • QMC > Engines > Edit > Logging

For this use case, the key values will be:

  • AuditLogAllSelection=1
  • AuditLogMessageLimit=10000

Hope that helps.

2 Replies
Employee
Employee

Re: GPDR

Hey @mostal75,

In terms of auditing selections made by users, the following is possible:

audit-selections.pngIn this example screenshot from the log opened in Excel (for easy formatting), we can see:

  • We can see that user QTSEL\LTU opened an app with a specified GUID
  • Inside of that app the user had this sequence:
    • Selecting the QTSEL\ltu value in the UserId field
    • Clearing values
    • Selecting the INTERNAL\sa_scheduler value in the UserId field
    • Clearing values
    • Selecting the foo value in the Session App Name field

If this fits with your use case, then you can set it by:

  • Stop the Qlik Sense Engine and Qlik Sense Service Dispatcher services on all nodes with engines.
  • For each of the nodes: open Notepad as Administrator
  • Open the Settings.ini file (by default located at C:\ProgramData\Qlik\Sense\Engine\Settings.ini)
  • Modify the file to fit this schema:
    • [Settings 7]
      Key=Value

    • Note the blank line at the end of the file
  • Save the file
  • After these changes have been made on all nodes, start the Qlik Sense Engine and Qlik Sense Service Dispatcher services on each node.
  • Ensure that the Audit log level for the Engine is set to at least INFO
    • QMC > Engines > Edit > Logging

For this use case, the key values will be:

  • AuditLogAllSelection=1
  • AuditLogMessageLimit=10000

Hope that helps.

mostal75
New Contributor III

Re: GPDR

Thanks a lot