Skip to main content Skip to complementary content

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.

Information noteWhile the Audit page in the QMC shows 1,000 results at a time, the audit export has no limits. This could lead to significant resource usage by the repository during the export.

Do the following:

  1. Open the QMC: https://<QPS server name>/qmc

  2. Select Audit on the QMC start page or from the StartArrow down drop-down menu.

  3. Define an audit query. For more information, see Defining an audit query.

  4. Click Export.

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

Set NullInterpret = ''; LOAD * FROM [lib://DataFiles/your_file_name] (txt, codepage is 28592, embedded labels, delimiter is ',');

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!