topic Re: DOCUMENT ACCESSED TIME BY NAMED USER in QlikView

DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 06:32:01 GMT

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

Re: DOCUMENT ACCESSED TIME BY NAMED USER

alexandros17 — Fri, 03 Jul 2015 07:20:53 GMT

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

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 07:27:49 GMT

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

Re: DOCUMENT ACCESSED TIME BY NAMED USER

jagan — Fri, 03 Jul 2015 07:35:09 GMT

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.

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 08:25:04 GMT

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

Re: DOCUMENT ACCESSED TIME BY NAMED USER

awhitfield — Fri, 03 Jul 2015 08:38:22 GMT

Hi avinashh,

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

HTH - Andy

Re: DOCUMENT ACCESSED TIME BY NAMED USER

jagan — Fri, 03 Jul 2015 08:40:32 GMT

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.

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 08:46:10 GMT

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

many thanks

Avinash

Re: DOCUMENT ACCESSED TIME BY NAMED USER

jagan — Fri, 03 Jul 2015 08:50:24 GMT

Hi,

Qlikview Session log files will be available in this folder

C:\ProgramData\QlikTech\Qvs

Regards,

Jagan.

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 08:57:52 GMT

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

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:01:22 GMT

jagan bro..

again one more thing while installing we have clicked on IIS and installed in .13 server.

i found webserver folder and in that with log folder and log files are there.

thanks

Avinash

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:04:33 GMT

I found in DSC folder with log files in qliktech. is this log files are session logs

Re: DOCUMENT ACCESSED TIME BY NAMED USER

jagan — Fri, 03 Jul 2015 09:08:25 GMT

Hi,

Log into QMC-> System-> Setup-> Select Qlikview Server-> Logging -> Log Folder

Check in this path, you will have filenames starting with Session*.

Regards,

Jagan.

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:10:37 GMT

jagan bro...

i found only three services running in services. Directory service connector, Distribute service and management service.

I didnt found Qlikview server in services.

please let me know on this..

Thanks

avinash

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:12:27 GMT

I found in this log folder this folder path "C:\ProgramData\QlikTech\QlikViewServer" and split files is selected as "Never"(should i have select any daily, weekly, yearly other than "never")

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:20:57 GMT

jagan bro...

Found the folder with session which i ahev attached in the below screen shot please let me know is it right or not?

One more thing we have development in .9 server it is a publisher licence so qlikview desktop is installed in this server only and in .13 server is qlikview server licence and this session folder found in that server. so now qlikview desktop is installed in that server. so now how can i give this session folder path in vLogPathfile as you mentioned in the code.

please let me know on this

thanks

avinash

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:21:29 GMT

Re: DOCUMENT ACCESSED TIME BY NAMED USER

jagan — Fri, 03 Jul 2015 09:29:14 GMT

Hi,

You need to give this path and load the session log files.

Regards,

Jagan.

Re: DOCUMENT ACCESSED TIME BY NAMED USER

Fri, 03 Jul 2015 09:42:05 GMT

many many thanks bro for your patience....

Bro could you please share me the options of server setting in "LOGGING" tab.

I have selected High and Never options after log folder in logging tab in server. Is it correct?

Re: DOCUMENT ACCESSED TIME BY NAMED USER

jagan — Fri, 03 Jul 2015 10:00:00 GMT

Medium and Split Monthly is the best option. If you split monthly, then every month it will generate a new file. Instead of putting all in a single split it.

Regards,

Jagan.