topic Re: Calculating User Concurrency from an Access Log in QlikView

Calculating User Concurrency from an Access Log

shane_spencer — Wed, 24 Aug 2016 09:58:00 GMT

I've got an Access Log that shows every time a named user logs on to one of our Instances, when they logged off and sessions duration - see attached.

From that data is it possible to parse the data so it shows at 5 minute intervals for every day how many concurrent users were logged on to each Instance

i.e.

Re: Calculating User Concurrency from an Access Log

adamdavi3s — Wed, 24 Aug 2016 11:16:48 GMT

Can you just interval match the timestamp to 'bucket' them and analyse that?

The Qlikview Governance Dashboard does concurrency so it could be worth downloading and taking a look at that?

Adam

Re: Calculating User Concurrency from an Access Log

shane_spencer — Wed, 24 Aug 2016 12:35:29 GMT

Hi Adam -

These are not QlikView logs - not sure if that was made clear. I have used Governance Dashboard previously and the code was locked down so I could not view it but I assume it uses the Performance Logs which collects Active Users at the interval you set. Unfortunately the App I'm using does not have such a log that's why I'm having to parse the Access Logs. Thanks for the heads up about Interval Match though - I'll take a look in to it.

I found this which is giving me some ideas:

Creating Reference Dates for Intervals

but it's not quite exactly what I'm after I don't think.

Re: Calculating User Concurrency from an Access Log

adamdavi3s — Wed, 24 Aug 2016 12:54:40 GMT

Hi Shane,

Sorry that is my fault for not explaining my logic properly, of course I can see that it isn't the QLik logs but I wasn't sure if the method in the governance dashboard would have been helpful or not.

You can get into the code (at least in 2.0) the password is on the first page of the script

This is definitely possible to do and not that complex, I've done something similar in the past but can't put my hand on it.

Let me see if I can dig it out of the back of my brain and knock up an example.

Re: Calculating User Concurrency from an Access Log

shane_spencer — Wed, 24 Aug 2016 12:58:47 GMT

I think I have it working - the Interval Match was enough of a point in the right direction.

Re: Calculating User Concurrency from an Access Log

adamdavi3s — Wed, 24 Aug 2016 13:00:41 GMT

Cool

I also found this on auto generating time i.e. if a time doesn't exist but you still want a continuous series of data.

Just skip right to the last post:

https://community.qlik.com/thread/2571

Re: Calculating User Concurrency from an Access Log

shane_spencer — Wed, 24 Aug 2016 13:05:25 GMT

Thank. I simply created a spreadsheet with 5 minute intervals that I'll load in and join the field to a date variable.

Re: Calculating User Concurrency from an Access Log

shane_spencer — Wed, 24 Aug 2016 14:45:21 GMT

I managed to get something working using the Time Interval option.