No Access Alert

[#1]

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

[#2]

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

[#3]

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.

[Or]

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.

[#5]

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