topic Re: QlikSense QRS Custom property in Management & Governance

QlikSense QRS Custom property

marksmunich — Mon, 05 Aug 2019 12:16:08 GMT

Hi Qlikies,

Is there a way to read the Custom property data from the QRS, logs. I tried to look into the Operations monitor, but there is no trace of any dimension holding the Custom property data.

I would like to load the data of custom property and its associated users from the QRS or the operations monitor.

Thanks

Mark

Re: QlikSense QRS Custom property

Giuseppe_Novello — Mon, 05 Aug 2019 15:47:10 GMT

It won't show in the Ops monitor, but it will in the DB, have you check the "CustomPropertyValues" table?

Gio

Re: QlikSense QRS Custom property

marksmunich — Tue, 06 Aug 2019 07:59:09 GMT

Hi Gio,

any clue how to read this table ?

Thanks for your reply.

Mark

Re: QlikSense QRS Custom property

Giuseppe_Novello — Tue, 06 Aug 2019 12:00:45 GMT

Maybe you could use the postgres ODBC connectors and look and load the table.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/PostgresSQL/PostgresSQL-connector.htm

Gio

Re: QlikSense QRS Custom property

marksmunich — Wed, 07 Aug 2019 11:43:51 GMT

Thanks for the reply. I will check it and let you know if it is working this way.

Mark

Re: QlikSense QRS Custom property

marksmunich — Mon, 19 Aug 2019 09:05:35 GMT

I have used the existing rest connectors to retrieve the custom properties for the Apps and Users, unfortunately it is not returning any data.

I have read in one of the blog posts like it is not recommended to use the Postgre SQL connection to query the QRS as the structure of the Tables might change. so i tried to read the QRS data using the REST API connection.

any thoughts why there is no data stored in the custom property Table.

Mark

Re: QlikSense QRS Custom property

Giuseppe_Novello — Mon, 19 Aug 2019 12:23:52 GMT

Looking directly in the DB, I can see the Custom Properties data, so I am not sure what you doing with your connection? To explain why you can't see data.

Gio

Re: QlikSense QRS Custom property

marksmunich — Mon, 19 Aug 2019 15:18:11 GMT

I have used the Rest Connector supplied with QlikSense Server for operations monitor App.

I can see the Root Folder and the structure with custom properties, Tags, Streams etc., but there is no data in the Custom Properties Table.

Is there any other way to query the QlikSense Repository. Also I tried to create a RESTconnection to read the QRS tables and i am unable to get the JSON Data, Rather it is showing CSV as default option and not returning any data. any idea about this . I tried to use postmaster and query the QRS , it was returning the data and the same is not working using a REST connector. The Custom property table is always empty using the REST connector for Apps, Tasks, Users etc.,

Thanks

Mark

Re: QlikSense QRS Custom property

mataylesbury — Fri, 04 Dec 2020 10:48:54 GMT

Hi Mark,

I've just been following the same path that you followed here trying to get custom property vales attached to users, via the existing monitor app connection. Did you ever get a solution that works?

Thanks.

Re: QlikSense QRS Custom property

stelei — Fri, 18 Nov 2022 10:08:58 GMT

In case anybody still needs this. Here is the SQL statement for retrieving the desired data:

SELECT u."UserDirectory", u."UserId", u."Name", u."RolesString", cpv."Value" as "CustomProperty" FROM public."Users" u LEFT JOIN public."CustomPropertyValues" cpv on u."ID" = cpv."User_ID" --WHERE u."Name" ORDER BY u."ID" ASC

Re: QlikSense QRS Custom property

Databayo — Fri, 03 May 2024 06:07:42 GMT

I know this is an old thread, but thought I'd provide the solution that worked for me. I had the same issue where the QRS API for monitor_apps_REST_user was just giving me blank values for the custom properties data. The solution or workaround rather, as others in this thread alluded to is using Qlik's Repository database instead. However, what no one mentioned here was how to actually set that up (as simple and obvious as it may be). Create a PostgreSQL data connection as you would any other connection in Qlik Sense, and use the following details:

Server: <Qlik Sense Hostname> Database: QSR Port: 443 Username: postgres Password: <super user password>

For some reason I had to try saving it a couple of times but once it saved it worked fine.

You can then use the connection to query the data as @stelei has shown.

Note: If you want the Custom Properties definition and not just the value, then you'll need to also grab the CustomPropertyDefinition table and link it to the CustomPropertyValues table with the Definition_ID field.

Re: QlikSense QRS Custom property

KeyReaL — Tue, 14 May 2024 11:36:09 GMT

Colleagues, good day.

We need help in writing a script (SQL request), because It is not strong in this ...

It is necessary to repeat the columns from the administrator console in the hub with the display of each Customer Property name into a separate column (as in the console, the screenshot invested).

The invested script unloads data, but all Values from different Customer Properties are folded in one field, but you need to different columns. Perhaps someone made a similar script, please share.

Thank you in advance.