Qlik sense sheets usage

[cdecluseau]

Hi,

I was wondering how we can know sheets usage by users of an application ?

I saw some topic in the Community without answer. I think that log form Proxy or Engine can contains this, but where ? I wan find this information and it's quite hard to read.

Operation monitor don't display this information and I don't see them in the data.

Should I put an higher log detail in the QMC ?

Thanks for your help and don't hesitate to ask me if necessary.

[cdecluseau]

A little up... Can somebody help me ?

[rittermd]

The apps sheet of the Operations Monitor has a table that does show the object or sheets along with the object id. The table is called App Object Details.

I have never tried it.  But there has to be a way to locate all of the sheets that make up an app in the repository and then possibly hit the same log file that they are getting the app activity from to get the sheet activity.

Just a guess.  If I have some time I will try to look into this.

[cdecluseau]

Hi ! Thanks for your answer. I imagine something like that but logs files are so difficult to read !

[Anonymous]

Mark,

I am about to have a look into this.  Do you manage to have a look or know of any relevant documents / url's ?

Fortunately I have more exposure to hoiking data from log files than a sane person would dare admit to.

[Anonymous]

Having poked around in the Ops Monitor it looks like it is using the Qlik Sense repository service API

• https://help.qlik.com/en-US/sense-developer/November2017/Subsystems/RepositoryServiceAPI/Content/Rep...

Doing a REST call to https://localhost/qrs/app/object/full to get the App Object Name's.

It is now beer o'clock in the UK.  I'll see if I can poke further tomorrow.

[e_petrasevicius21]

Hi Christophe,

I have tried to create an app to analyze user usage per sheet. First of all you need to set "Engine Traffic Logging" level from "Off" to "Info". It will give you all information about each user and movement though the app and selections user made. But take note : it will generate the huge amount of log files.

In these logs you will find field "Message". You need to extract "qGenericId" values from the message field. You will use these values to connect with information from QRS.

Next step to do connect to QRS via REST connector. You could use default connector "monitoring-app-object" to extract all app objects information. To create connection between Log files and QRS you need to use "qGeneric" values from Log files and "engineObjectId" from QRS.

Hope it will help you.

[phaneendra_kunc]

Any luck in creating the app? If so can you share the code here?

I agree enabling Traffic Logs are creating very big files. But want to see if you have a solution.

Thanks,

Phani

[liam_hanninen]

Any updates on this? This seems like a fundamental monitoring metric! I wish this was built out-of-the-box.

[e_petrasevicius21]

Hi everyone, latest news on app status - postponed due to lack of time. Hope I will find time to finish until the summer. I will let you know if app status change.