Retrieve User license & last login information from Postgres Qlik metadata

[VamsiBhagavathula1]

Hello,

I want to get the user creation date , license allocation(analyzer/professional),last login date or last used  directly from the qlik postgres db's instead of using license or operations app provided in qliksense as they involves log files.

Has anyone tried retreiving the information directly from postgres DB, If yes, Please share me the sample query if you had one or provide me the tables information it involved.

Thanks in advance

Best Regards,

Vamsi

[Jack_Guo]

Hi @VamsiBhagavathula1 ,

user creation date >>> QSR DB, Users table, CreatedDate column.

license allocation:

Pro >>> QSR DB,  LicenseProfessionalAccessTypes table, User id column(user id = users.id)

Analyzer >>> QSR DB,  LicenseAnalyzerAccessTypes table, User id column(user id = users.id)

last login date >>> QSR DB,  LicenseProfessionalAccessTypes table, lastUsed column.

Hope this helps. But we don't suggest to make those call to repo database in a PROD environment.

[VamsiBhagavathula1]

Hi @Jack_Guo , Thank you for the information shared. Could you please also let me know tables involved for retrieving user information togather with streams and the applications that he has access to and apps in users work area??

Thanks,

Vamsi