Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

DOCUMENT ACCESSED TIME BY NAMED USER

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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.

View solution in original post

21 Replies

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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

Not applicable

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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

MVP & Luminary
MVP & Luminary

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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.

Not applicable

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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

Partner
Partner

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Hi avinashh,

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

HTH - Andy

MVP & Luminary
MVP & Luminary

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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.

View solution in original post

Not applicable

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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

many thanks

Avinash

MVP & Luminary
MVP & Luminary

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Hi,

Qlikview Session log files will be available in this folder

C:\ProgramData\QlikTech\Qvs

Regards,

Jagan.

Not applicable

Re: DOCUMENT ACCESSED TIME BY NAMED USER

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 advanceNew Bitmap Image (2).bmp