topic Re: Extract list of users from Qlik Sense's postgre DB? in App Development

Extract list of users from Qlik Sense's postgre DB?

swarup_malli — Sat, 16 Nov 2024 06:45:49 GMT

Hello ,

I wanted to extract the list of users who have accessed qlik sense from the postgre db that qlik uses to store its meta data.

Is it possible? Can someone provide me the query used to extract this info from postgre?

I'm unable to leverage the operations monitor and license monitor .

Thanks

Swarup

Re: Extract list of users from Qlik Sense's postgre DB?

dplr-rn — Thu, 24 Jan 2019 16:18:39 GMT

Can i ask why you need to connect to postgres?
Wont that list be available within QMC
e.g. in audit --> License Usage summary section

Re: Extract list of users from Qlik Sense's postgre DB?

swarup_malli — Thu, 24 Jan 2019 16:29:01 GMT

Thanks for the reply.

I only want to extract users who were active in the past 90 days

Re: Extract list of users from Qlik Sense's postgre DB?

dplr-rn — Thu, 24 Jan 2019 16:32:56 GMT

Why not edit the operations or license monitor to achieve this?

Re: Extract list of users from Qlik Sense's postgre DB?

Gysbert_Wassenaar — Thu, 24 Jan 2019 16:33:59 GMT

I'm unable to leverage the operations monitor and license monitor .

How about the session monitor?

Re: Extract list of users from Qlik Sense's postgre DB?

swarup_malli — Thu, 24 Jan 2019 16:40:56 GMT

Thanks for responding to my post Gysbert.

The session monitor has not run since oct 2018. I've started reloading it since 4 days ,the problem is it gives me data till oct 2018 followed by jan data starting from jan 20 2019.The data for the period between Nov 2018 and jan 19 2019 is not available.

F Y I

We had moved the logs to a different location in Oct 2018.

Re: Extract list of users from Qlik Sense's postgre DB?

swarup_malli — Thu, 24 Jan 2019 17:36:09 GMT

I just took a copy of the session monitor app and reloaded it .It gives me the entire dataset starting from Jan 2018 to Jan 2019.

But whenthe same app is published in the monitoring stream and reloaded, the data between Nov 2018 and jan 19 2019 disappears

Re: Extract list of users from Qlik Sense's postgre DB?

Gysbert_Wassenaar — Fri, 25 Jan 2019 10:51:56 GMT

You published the copy and then reloaded that copy?