Calculate concurrent sessions

[poonam_kulwal]

Hi All,

I have sample from QV server Sessions log.

Data is about document access history (from access point).

SessionStart, SessionEnd, Document,Server,CalType

 I want to calculate concurrent sessions:

Maximum concurrency per server

Maximum concurrency per server per CAL

What are the documents contributing for max concurrency?

How many sessions each of those document had?

Which document was the biggest contributor?

Appreciate your inputs on this.

Regards,

Poonam

[NadiaB]

Hi @poonam_kulwal 

Are you familiar with the Governance Dashboard? It has a section to analyze sessions and has most of what you have listed.

How to configure the Governance Dashboard

Kind Regards,

[rwunderlich · Accepted solution]

Attached is the general script I use to process QV Server Logs into QVDs, including concurrent session calculation.  I calculate concurrency to the second but then save only the max value per hour and CAL Type.  Feel free to modify to fit your own needs. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[poonam_kulwal]

Thanks Rwunderlich!

Appreciate your help.

[poonam_kulwal]

Thanks NadiaG for Link to Governance dashboard!