How to obtain SQL for QRS resource library table fields corresponding to session details in Operations Monitor APP report
HI:
The QLIKSENSE historical document has a logging database (QLOG), which is no longer supported after the new version in 2021; So QLIKSENSE meta databases include QSR, SENSESERVICES, QSMQ, and LICENSES;
# Question: The Operations Monitor report session details record user access report logs. Which table in the meta database can be used to find response records?? Example log fields: access user ID, access report ID, access date, and access frequency.
THANK~
The main database is QSR. Qlik Support advises against getting data directly from the QSR DB, especially making any modifications. It helps in understanding the objective you are trying to achieve or what set of information you would like to compose. You can ignore SENSESERVICES, QSMQ, and LICENSES for this purpose
If you want user access details, the easiest is always looking on the proxy side. For some of the items you mentioned, in QSR, there is a collection of tables starting with Licence...Access...usage The tables include SessionID, latest activity, start time, hostname etc
Again, it is a very custom request and everything depends on what you try to discover.
Today I searched the QSR database and found many tables starting with "License... Access... Usage" (such as LicenceAnalysts Access usage, LicenceLogin Access usage, odaglink usage, etc.), but the data tables were empty;
In addition, the Operations Monitor APP data loading editor found the access log file lib://ServerLogFolder/governanceLogContent_7.16.0_file I couldn't find the SELECT code. How can I find it? Business demand: View QLIKSENSE user access report usage data and query the database through a third party (such as mobile phone).
