Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
I found reference manual in Qliktech folder. but i didnt any .qvw file which you mentioned.
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.
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
Hi avinashh,
have you checked the sessions log in C:\ProgramData\QlikTech\QlikViewServer?
HTH - Andy
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.
Hi i have found qlikview and qlikviewserverDocumentation folder in my qliktech. I dont have any QlikviewServer Folder in Qliktech.
many thanks
Avinash
Hi,
Qlikview Session log files will be available in this folder
C:\ProgramData\QlikTech\Qvs
Regards,
Jagan.
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