Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
marcoyukon
Creator
Creator

Need to pull session detail history into SQL

I am looking into pulling the operations monitor session details and inserting the data into sql for analysis.

Are there any resources on where to connect to pull all the historical session data details and the tables involved in the process?

Thanks,

Marco

Labels (3)
1 Solution

Accepted Solutions
NadiaB
Support
Support

Hi @marcoyukon 

The sessions come from the Engine logs, the details are here:

https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...

"Sessions Monitor uses the ProxySessionId from the engine's session logs for deriving its session counts like Operations Monitor, which effectively gives the proxy session counts. Sessions Monitor also registers short sessions (less than 40 seconds) that are excluded in the Operations Monitor due to their respective design choices. Therefore, the Sessions Monitor session counts can sometimes lie in between the session counts of Operations Monitor and License Monitor."

For more details about how is calculated, it is suggested to look at the Sessions Monitoring app code. 

Hope it helps. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

View solution in original post

2 Replies
MendyS
Partner - Creator III
Partner - Creator III

Hi @marcoyukon 

all the data present in the app monitor session came from logs,
you have two options - 
1. read the logs with a tool like Elastic
2. store Table in format Excel from Data load script, and used with SSIS or something like this.

this the options that I think about, maybe there are more 

 

NadiaB
Support
Support

Hi @marcoyukon 

The sessions come from the Engine logs, the details are here:

https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...

"Sessions Monitor uses the ProxySessionId from the engine's session logs for deriving its session counts like Operations Monitor, which effectively gives the proxy session counts. Sessions Monitor also registers short sessions (less than 40 seconds) that are excluded in the Operations Monitor due to their respective design choices. Therefore, the Sessions Monitor session counts can sometimes lie in between the session counts of Operations Monitor and License Monitor."

For more details about how is calculated, it is suggested to look at the Sessions Monitoring app code. 

Hope it helps. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm