Export All Rules From Qlik Sense Repository Using PowerShell

[ToniKautto]

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:

• qrs-api-get-all-rules.ps1 https://github.com/qlikcustomersuccess/qrs-api-powershell 

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.
 

1. Login to Windows Server on Qlik Sense central node

2. Copy attached PowerShell script file to any folder
   
   

3. Open PowerShell prompt

4. Navigate to the folder containing PS1 file 

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

6. Successful execution is indicated with green text and references to generated files

   
   
   

7. Collect extracted JSON files from same location as PS1 file and upload to your Qlik Support case

   

[AlexPolorotov]

You can also export Security Rules to Git using Gitoqlok without a scripting skillset.

This article is intended as a guide for those who are faced with the situation to figure out who made a disaster because of editing of Security Rules and how to roll back to the last stable version of Security Rules. 
https://apolorotov.medium.com/exporting-and-importing-security-rules-qlik-sense-to-git-deb96417107e