Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
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

Labels (2)
7 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

Thanks for  the reply.

 

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

dplr-rn
Partner - Master III
Partner - Master III

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?


talk is cheap, supply exceeds demand
swarup_malli
Specialist
Specialist
Author

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

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?

talk is cheap, supply exceeds demand