Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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

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

7 Replies
Highlighted
Partner
Partner

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

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
Highlighted
Specialist
Specialist

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

Thanks for  the reply.

 

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

Highlighted
Partner
Partner

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

Why not edit the operations or license monitor to achieve this?
Highlighted
MVP & Luminary
MVP & Luminary

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


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

 


How about the session monitor?


talk is cheap, supply exceeds demand
Highlighted
Specialist
Specialist

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

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.

Highlighted
Specialist
Specialist

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

You published the copy and then reloaded that copy?

talk is cheap, supply exceeds demand