Qlik Sense Enterprise on Windows security and load balancing rules may need to be exported. The complete rule definition is not included in Qlik Sense logs and must be collected separately through a Qlik Sense Repository Database dump or by being extracted through Qlik Sense Repository Service (QRS) API.
Environment:
Qlik Sense Enterprise on Windows
References:
Resolution:
Qlik Sense Enterprise on Windows security and load balancing rules can easily be extracted through PowerShell by utilizing Qlik Sense Repository Service (QRS) API calls.
-
Login to Windows Server on Qlik Sense central node
-
Copy attached PowerShell script file to any folder
-
Open PowerShell prompt
-
Navigate to the folder containing PS1 file
- Run the PS1 script with parameters UserName and UserDomain referring to a valid RootAdmin user;
.\qrs-api-get-all-rules.ps1 -UserName Administrator -UserDomain DOMAIN
-
Successful execution is indicated with green text and references to generated files
-
Collect extracted JSON files from same location as PS1 file and upload to your Qlik Support case