Knowledge Use report

[Casper Van Coes]

I am trying to create a report or indicator that will display knowledge use of articles only after the article has been published. In our instance, there are many users with the Knowledge admin role so they may view a KA before it's been published but we'd like to report on knowledge usage after the article has been published.

Using the kb_use table so far I can only make a simple relative filter condition to display KA usage where the parent KA was published 'more than' an hour before the usage was created.

Without creating a new database view is there a more elegant way to filter or break down the relationship between the kb_use created date and the KA published date?

[bammar]

Great question. I know this may be a no-no ... if data regarding KB views/use pre Publishing is of no value to you

You could make a Business rule when KB article state changes to Published- then clear value to 0- 

You could record ot track the value before the clearance if it actually has value. If you think about it someone could make a KB in 1 view. Another person could reload it over ad over laboring over every letter and cause 100 views. So i think the real important count is the one from the customers. 

Also if you think the value will be negligible over time like then maybe avoid worrying about it. 

[Casper Van Coes]

Hi Bammar,

That is a good idea, I will propose it to my team. Thanks for your help!

[Henrietta T]

Is there a way to exclude specific users or groups from reporting on articles? 

[Casper Van Coes]

Hi Henrietta,

You could filter out Articles created by certain groups. If you trying to limit the visibility of reports on articles you can only share the report with specific non-admin users who will be the only users that can see the report.

Thanks,