topic Re: Usage audit tracking in QlikView

Usage audit tracking

Anonymous — Wed, 20 Aug 2014 10:08:01 GMT

Hi Guys,

Can someone help me understand on how i can figure out the usage of a dashboard. I have enabled audit logging on the server already. I am trying to find out which are the reports the users have accessed. I am able to figure out what are the selections the users have made and who all have used the send to excel option and all.

But what i am looking for is as below.

If a user logs in and does not make any selections and just opens up a report (pivot table or straight table which is in minimized state by default). Can i get this information from the audit log.

Thanks in advance.

Aadil

Re: Usage audit tracking

martynlloyd — Wed, 20 Aug 2014 10:13:58 GMT

Hi, I have just created my own usage tracker, using the Audit and Sessions logs. Enable extensive logging in the management console. Regards. Marty.

Re: Usage audit tracking

ashfaq_haseeb — Wed, 20 Aug 2014 10:30:09 GMT

Hi,

have a look at below applications

http://community.qlik.com/docs/DOC-6725

http://community.qlik.com/docs/DOC-4307

http://community.qlik.com/docs/DOC-6699

Regards

ASHFAQ

Re: Usage audit tracking

Anonymous — Wed, 20 Aug 2014 10:32:31 GMT

Hi Martyn,

Thanks for the response.

From your screenshot i can figure out, the selections and the sheets that the user has navigated to. How do you figure out the object they have clicked on and not the selections that they made.

Thanks,

Aadil

Re: Usage audit tracking

martynlloyd — Wed, 20 Aug 2014 14:07:04 GMT

Hi Aadil,

Actually, this level of tracking is fine for me, it tells me which objects they are exporting to excel, as well as general navigation. I have enough info to evolve my application. Similar to Google Analytics...

regards,

Martyn.

Re: Usage audit tracking

Wed, 27 May 2015 16:52:20 GMT

Hey Martyn,

Is there any way to map sheet name with the username (who accessed it). Below is the table columns I am trying to get.

Dashboard Name, User Name, Sheet ID, Sheet Name, Time-stamp

Regards,

Janaki

Re: Usage audit tracking

martynlloyd — Mon, 08 Jun 2015 12:00:49 GMT

Hi Lynda, did you solve your problem?

Here is a way to grab the data - you will need to parse the audit string to get the sheet name

Audit:
LOAD

[Server Started] as AuditSS,
Timestamp as AuditTime,
Year(Timestamp) & Week(Timestamp) as Week,
Document,
SubField( Mid( Document , Index(Document, '\', -1) +1) , '.', 1) as DocumentName,
Type,
TextBetween(User,'\','') as DocumentUser,
Message as Audit
FROM
\\[SERVER]\[Log Folder]\Audit_[SERVER]_2015*.log
(txt, utf8, embedded labels, delimiter is '\t', msq);

Kind regards,

Marty.

Re: Usage audit tracking

Mon, 08 Jun 2015 21:58:35 GMT

Thanks a lot Martyn. I was able to resolve the issue.

Can I ask a question? When I load the Audit logs and get only Type=Sheet, if there is only one sheet the dashboard doesn't track the navigation. If I include any sheet activity then I am able to understand that some user visited that particular dashboard. Not sure why that happens?

Regards,

Janaki

Re: Usage audit tracking

martynlloyd — Wed, 10 Jun 2015 18:23:14 GMT

Hi Janaki,

Yes, that's an odd one - you can always create a hidden sheet in your documents to make sure you have a minimum of 2...

Regards,

Marty.

Re: Usage audit tracking

Thu, 11 Jun 2015 20:46:35 GMT

Hi Martyn,

I tried creating a hidden sheet, a blank sheet, using the "Activate Sheet" trigger, but nothing helps. So finally I added an Intro sheet.

Also lot of users within my company generally try to download tables in the dashboard. So if I have only one sheet and the user is navigating within that sheet, the Audit log doesn't track that if I put Type=Sheet.

Anyway thanks for responding.

Regards,

Janaki

Re: Usage audit tracking

martynlloyd — Fri, 12 Jun 2015 16:09:09 GMT

Hi Janaki, you are welcome.

Re: Usage audit tracking

Tyler_Waterfall — Tue, 29 Dec 2015 12:29:21 GMT

Good ideas here.

Also consider using the Governance Dashboard. It's a Qlik-supported tool that you can download from Qlik Market http://market.qlik.com/qlikview-governance-dashboard.html

I am working towards the release of v2.0 which is easier to use (no install!) and has improved Audit logging reporting to make it easier to track usage and activity. Let me know if you'd like access to the Beta!

Tyler

From the Sessions > User Activity page of the Governance Dashboard 2.0. Audit details at the bottom - in a pivot table so you can rearrange and collapse / expand as you'd like.

Re: Usage audit tracking

Tyler_Waterfall — Tue, 29 Dec 2015 12:37:54 GMT

Lynda - You can also get that detail on the "Log Details" page of the Governance Dashboard 2.0 - (I know I'm responding to an old conversation!)

Use the chart as is or modify to suit your needs

Re: Usage audit tracking

Tyler_Waterfall — Tue, 29 Dec 2015 21:34:07 GMT

You all (on this thread) now have access to the Governance Dashboard 2.0 beta:

QlikView Governance Dashboard 2.0 App Beta

Re: Usage audit tracking

Anonymous — Fri, 26 Jan 2018 18:27:16 GMT

Hi Martyn,

Can you share the usage tracking app you created.We need same details you are displaying on your dashboard for our use case.

Thanks,

Krishna