Need to pull session detail history into SQL

[marcoyukon]

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

[MendyS]

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 · Accepted solution]

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.