Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Why is kb_use generating multiple identical records?

SakshyaR
Tera Contributor

Hi All,

I need some clarification on how the kb_use table works.
I’m seeing multiple duplicate entries with the same timestamp for the same user (screenshot attached).

Can someone please help me understand:
• Why these duplicate records are generated?
• How exactly the kb_use table logs or captures usage?

Any guidance or insights would be appreciated.

Thank you!

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SakshyaR 

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0693342

 

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1220880

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715776

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0817930

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Chaitanya ILCR
Mega Patron

Hi @SakshyaR ,

I was able to replicate this

ChaitanyaILCR_0-1763381406272.png

this happens when the users view the article from the contextual search 

ChaitanyaILCR_1-1763381487440.png

as the users open the KB results and view the articles a event is fired (kb.view) 

if the users open the KB article twice the event gets fired twice (no.of view = number of events)

 

if the user had opened and viewed the article in short space may be being in the different tabs of the same browser the events will be fired and when the system processes them there is a script action that creates a kb_use record as these are events are in queue at the same time and process within no time the script action runs multiple times and creates the multiple kb_use records 

 

ChaitanyaILCR_2-1763381755565.png

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

 

SakshyaR
Tera Contributor

The KB article shown in the screenshot have different sys_ids. I searched the sys_ids in the kb_knowledge table and found two KB records — one is retired and the other is published.