Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Luminary Alumni
Luminary Alumni

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
alexandros17
Partner - Champion III
Partner - Champion III

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
Author

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

jagan
Luminary Alumni
Luminary Alumni

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
Author

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
Partner - Champion
Partner - Champion

Hi avinashh,

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

HTH - Andy

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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

many thanks

Avinash

jagan
Luminary Alumni
Luminary Alumni

Hi,

Qlikview Session log files will be available in this folder

C:\ProgramData\QlikTech\Qvs

Regards,

Jagan.

Not applicable
Author

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