Calculating User Concurrency from an Access Log

[shane_spencer]

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.

[adamdavi3s]

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

[shane_spencer]

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.

[adamdavi3s]

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.

[shane_spencer]

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

[adamdavi3s]

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

[shane_spencer]

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

[shane_spencer · Accepted solution]

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