Exporting audit query results
You can export the results for an audit query to a CSV file. You can then import the file into a Qlik Sense app for further analysis. The exported file is saved in the temporary content folder on the server for 24 hours.
The audit export feature is controlled by the QmcAuditExportEnable feature flag. To enable export, switch on the flag in capabilities.json. The default value is false.
Audit export is only available for security rules and not for load balancing rules or license rules. The same security rules and access conditions that are available when you perform a query using the Audit button apply when you export query results.
Do the following:
-
Open the QMC: https://<QPS server name>/qmc
-
Select Audit on the QMC start page or from the Start
drop-down menu. -
Define an audit query. For more information, see Defining an audit query.
-
Click Export.
-
A dialog opens with a warning about potentially high resource usage. Click Export to confirm.
When the export is finished, you can find the file under C:\ProgramData\Qlik\Sense\Repository\TempContent. The file name is Audit_Stream followed by a timestamp.
Importing audit data into Qlik Sense
You can import the CSV file with the audit data into a Qlik Sense app. To avoid problems with null values in the audit results, enter the following code in the load script of the app. This removes any empty rows from the CSV file.