DOCUMENT ACCESSED TIME BY NAMED USER

[#1]

Hi All,

I required information of each document how many times accessed by each named user. Where can we find the information in server?

We have Document cals -'0' and Named Users -'55'

So i am able to see information for Named user accessed logged in time but how can we see for the Document(Document means Dashboard) wise for each Named user when logged in time with the document and how many times he accessed to that document.

Is there are any logs to checks for Document who logged in to this dashboard at what time like that???

Many Thanks in Advance

[alexandros17]

When you install qv server there is a document released  during installation called QVSystemMonitor,qvw (I do not remember the directory) that has the informations you required

[#3]

I found reference manual in Qliktech folder. but i didnt any .qvw file which you mentioned.

[jagan]

Hi,

Check this for link for System Monitoring Dashboard and change the file path and reload the Dashboard you will get the required details

QlikView Application: System Monitor v5.1.23

Regards,

Jagan.

[#5]

Many Many thanks for your reply jagan bro.

It is looking so complex to make cutomize for my requirement in that QVW file.

Could please help me on this i want only users details who logged at what time and how many times logged to that each dashboard details.

Already alert E-mail settings are done for failure tasks bro. So log will be sending to the user E-emails.

please help me on this bro. Could please make customization for this dashboard according to my requirements. 

many thanks in advance

[awhitfield]

Hi avinashh,

have you checked the sessions log in C:\ProgramData\QlikTech\QlikViewServer?

HTH - Andy

[jagan · Accepted solution]

Hi,

Use this script to load the user access details, on top of that create the charts.

Sessions:

LOAD

  Capitalize(LOWER(SubField(Document,'\',-1))) as Dashboard,

  Time(Timestamp) as SessionsTime,

  if(len([QlikView User]) = 0 ,[Authenticated user], [QlikView User]) as UserID,

   [Cal Type],

    [Cal Usage Count],  

     Date(Floor(Timestamp)) AS Date,

     Year(Date(Floor(Timestamp))) AS Year,

     Month(Date(Floor(Timestamp))) AS Month,

     Date(MonthStart(Timestamp), 'MMM YYYY') AS MonthYear,

     'Q' & Ceil(Month(Date(Floor(Timestamp)))/3) AS Quarter,

     [Session Duration]  as SessionDuration,     

     Calls as SessionCalls, 

     [Session Start]

FROM $(vLogFilesPath)\Sessions_*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

Note: change vLogFilesPath in the above script to you actual Session logs file path.

=Count([Session Start])  gives you number of sessions

Hope this helps you.

Regards,

Jagan.

[#8]

Hi i have found qlikview and qlikviewserverDocumentation folder in my qliktech. I dont have any QlikviewServer Folder in Qliktech.

many thanks

Avinash

[jagan]

Hi,

Qlikview Session log files will be available in this folder

C:\ProgramData\QlikTech\Qvs

Regards,

Jagan.

[#10]

jagan Bro....

Actaully we have two server .9 and .13 servers with same licence.

Here we have given publisher licence and server licence.

the below screenshot is folders which i have in qliktech.

i didnt find qvs and with session logs files. There are log files jagan bro.

Thanks in advance