Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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
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
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