topic No Access Alert in QlikView

No Access Alert

Wed, 28 Apr 2010 10:02:44 GMT

I need to add functionality to a QV model to send an alert everytime a user who doesn't have access to the model tries to access it. Can anyone point me in the right direction please.

I'm using QlikView 8.5

No Access Alert

Wed, 28 Apr 2010 10:15:38 GMT

Hi,

You can able to see these kind of activities in the event log of QlikView Server. Create a application with event log as your source file and based on the event code you can trigger a alert to whomever when ever it find the same in the latest time period.

You can reload every 10-15mins.

regards

rajesh

No Access Alert

Wed, 28 Apr 2010 10:48:34 GMT

Thank you Rajesh.

I tried your suggestion using the Sessions log file, but it only creates an entry in the log file once the user successfully logged into the model. I need to know when a model was opened regardless if login was successfull or not.

No Access Alert

Or — Wed, 28 Apr 2010 11:10:17 GMT

The QV Events log can give you a partial answer. It will log a line like this on failed attempts:

2010-04-24 00:23:46 2010-04-27 15:08:52 2 110 Warning The document X:\QlikView\myModel.qvw failed to load because of no access [15].

However, it does not specify who the user.

No Access Alert

Wed, 28 Apr 2010 11:16:32 GMT

Is there not a way for me to do this in a VB macro in the model?