Repository database query

[crmtdoo]

Hello,

is ti possible to get these information from repository PostgreSQL database :

• number of currently working (logged in) users
• status of refreshes scheduled overnight
• status of connection between Qlik and MSSQL server during load.
  

Thank you.

[Albert_Candelario · Accepted solution]

Hello @crmtdoo ,

Thanks for posting.

The second item listed might be possible to check within the "Task" and "Trigger"* tables of the PostgreSQL DB.

Have you had a look at them?

You might want to connect to the PostgreSQL to create a Qlik Sense app, load the data into an app and explore the different data available there.

Cheers,

Albert

*The name might differ of what I have written above.