Automated Process to Update the Settings User Roles, License value, Thumbprint and Host Allow List of Virtual Proxy in QMC or QRS

[AshutoshBaliarsingh]

 Use Case: We usually update the following in the QMC GUI. This causes problem at times when there is no RDP access is present to the server.

1. License Value
2. Host Allow List in Virtual Proxy for SAML
3. SAML Users to be setup with admin roles etc.

Steps do it in automated way without QMC GUI:

1. Keep the repository database up and running post installation
2. Open powershell
3. Go to the Qlik Sense installation path (default is C:\Program Files>>Qlik>>Sense>>Repository>>PostgreSQL\<version>\bin)
4. Connect to postgres database using the command ".\psql -h <hostname> -U <username> -d QSR -p <port number>"
   1. Example: .\psql -h localhost -U qliksenserepository -d QSR -p 4432
5. Type postgres command \dt in powershell prompt QSR=> and press enter to know the table names in current user
   1. \dt *.* will list all tables in postgres database across all schemas
   2. \d "<tablename>" will provide the metadata of the table
6. Related to Users

   1. SELECT * from "Users";-----To know all the users

   2. UPDATE "Users" SET "RolesString"='RootAdmin' where "Name"='<value>';-----To update the role of an user
7. Related to SSL Thumbprint

   1. SELECT "SslBrowserCertificateThumbprint" from "ProxyServiceSettings";

   2. UPDATE "ProxyServiceSettings" SET "SslBrowserCertificateThumbprint"='<value>';----To update the thumbprint value
8. Related to License
   1. SELECT "Lef","Serial","Name","Organization" from "Licenses";
   2. UPDATE "Licenses" SET "Lef"='<value>', "Serial"='<SerialNumber>', "Name"='<value>', "Organization"='<value>';
9. Related to HostAllowList

   1. SELECT "WebsocketCrossOriginWhiteListString" from "VirtualProxyConfigs";

   2. UPDATE "VirtualProxyConfigs" SET "WebsocketCrossOriginWhiteListString"='<value>';---to whitelist the domains/ips
10. Restart all Qlik Sense Services

The information in this article is provided as-is and will be used at your discretion. Depending on the tool(s) used, customization(s), and/or other factors, ongoing support on the solution below may not be provided by Qlik Support.

Environment

• [Qlik Sense May 2025]
• [Qlik Sense November 2025]