topic Re: User in the server event log message in QlikView

User in the server event log message

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

it would be nice to get the user of a server event log message (table: Events field: Message).

The expression would be

mid(Message, index(Message,'"')+1,index(Message,'"',2)-index(Message,'"')-1)

Thanks a lot!

Peggy

Re: User in the server event log message

Tyler_Waterfall — Tue, 21 Oct 2014 17:03:40 GMT

Hi Peggy,

Are you asking for that [User] to be added to the Event.log files or to the Governance Dashboard?

How would you use the [User] "field"? (What questions are you trying to answer?)

Tyler

Re: User in the server event log message

Wed, 22 Oct 2014 09:36:39 GMT

Hi Tyler,

I would like to know which user caused an event, e.g. which user got the message "out of session cals".This is a table out of the Governance Dashboard:

If I would have the user, I could select it to see all Messages caused by this user. I can get to know how often this would happen and if I may change the license type for this user.

Peggy

Re: User in the server event log message

Tyler_Waterfall — Wed, 22 Oct 2014 10:52:01 GMT

I see. So this is specific to which users were denied access due to insufficient CALs.

It looks like the way you've set it is working.

If you wanted more ability to use that "Event Log User", you could create a list box with your expression:

=mid(Message, index(Message,'"')+1,index(Message,'"',2)-index(Message,'"')-1)

Or you could add one that shows user denied:

=IF(index(Message,'No CAL assigned to user')>1,

mid(Message, index(Message,'"')+1,index(Message,'"',2)-index(Message,'"')-1)

,null())

Tyler

Re: User in the server event log message

Wed, 22 Oct 2014 10:59:30 GMT

Hi Tyler,

sorry, I have to clarify...

My question is, if this could be created within the script? So that everybody may use it in future.

Greetings

Peggy

Re: User in the server event log message

Tyler_Waterfall — Wed, 22 Oct 2014 11:02:14 GMT

I thought you might ask this

I will add it to the enhancement list, though at the present time there is no set release date for this and other requested enhancements (GOV-455).

Tyler

Re: User in the server event log message

Wed, 22 Oct 2014 11:07:20 GMT

Hi Tyler,

yeah, sorry for the confusion

Thanks a lot

Do you know that the E-Mail for the Feedback doesn't work? qvgdfeedback@qliktech.com

Peggy