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

[swarup_malli]

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

[dplr-rn]

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

[swarup_malli]

Thanks for  the reply.

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

[dplr-rn]

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

[Gysbert_Wassenaar]

---

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

---

How about the session monitor?

[swarup_malli]

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.

[swarup_malli]

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

[Gysbert_Wassenaar]

You published the copy and then reloaded that copy?