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

AshutoshBaliarsingh — Fri, 02 Jan 2026 14:59:21 GMT

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.

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

Steps do it in automated way without QMC GUI:

Keep the repository database up and running post installation
Open powershell
Go to the Qlik Sense installation path (default is C:\Program Files>>Qlik>>Sense>>Repository>>PostgreSQL\<version>\bin)
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
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
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
Related to SSL Thumbprint
1. SELECT "SslBrowserCertificateThumbprint" from "ProxyServiceSettings";
2. UPDATE "ProxyServiceSettings" SET "SslBrowserCertificateThumbprint"='<value>';----To update the thumbprint value
Related to License
1. SELECT "Lef","Serial","Name","Organization" from "Licenses";
2. UPDATE "Licenses" SET "Lef"='<value>', "Serial"='<SerialNumber>', "Name"='<value>', "Organization"='<value>';
Related to HostAllowList
1. SELECT "WebsocketCrossOriginWhiteListString" from "VirtualProxyConfigs";
2. UPDATE "VirtualProxyConfigs" SET "WebsocketCrossOriginWhiteListString"='<value>';---to whitelist the domains/ips
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]

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

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