Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Highlighted
robertomedellin
New Contributor III

How to determine what sessions where denied?

Hello Friends!

I loaded the Session Logs to QlikView, and I can see what user (LanID) opened what document, at what time, and all. But I cannot determine which sessions were denied.

We have Session CALs, and Usage CALs, but they have not been enough. So I'm trying to build an analysis to know how much to purchase, but I can't tell which are succsessfull sessions, and which ones were denied.

How can I tell?

More info

"Exit Reason" is not helping me.

The Event log shows me when an Access is Denied, but I can't associate it to the Session log.

By "Original CAL Type" is not helping wither. There's "None" when it seems they used a license and were able to get a session going.

Regards.

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to determine what sessions where denied?

I think within the session-logs are only valid sessions therefore nothing about denied sessions. But a linking to the event-log could be possible and helpful per the timestamp-field. Maybe it needs a little bit blurring with one or two seconds. But it could you give the ratio between used CAL's and denieded access. Maybe you could use or customize already built apps - have a search here to GovernanceDashborad and GovernanceMaterials.

Another possibilty could be to check (and maybe associate) log-files from web-server: http://community.qlik.com/message/693724#693724.

- Marcus

robertomedellin
New Contributor III

Re: How to determine what sessions where denied?

Thanks Marcus.

Yes I've used the Governance Dashboard and QlikView System Ops Monitor, plus I've made my own App. But the few seconds of difference makes it unreliable, but well I did some statistics and calculations and I'm almost done.

If it helps anyone, In "Events" log, there's Message, so in the script I added:

IF(LEFT(Message,24)='CAL usage: Access denied',1) as DeniedCounter,

So letter I could graph SUM( DeniedCounter ) by month, or by day ("date" actually) and found out we are loosing 20 sessions a day, many ceros, but many more non zeros, with numbers up to 400 a day!

Who exactly did we lost, and to what document? Well we cannot know for certain but I distibute them according to what "Sessions" log tells me it's more popular.