Usage audit tracking

[Anonymous]

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

[martynlloyd]

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

[ashfaq_haseeb]

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

[Anonymous]

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

[martynlloyd]

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.

[#6]

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

[martynlloyd]

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.

[#8]

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

[martynlloyd]

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.

[#10]

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