Report to know which resources are linking knowledge articles to tickets

Rashmivs17
Tera Contributor

Hello Team,

I am struggling to create a report on the resources which are linking the knowledge articles to tickets. I have managed to get a count of resources who are doing the linking. However, I am not able to group them as per their names since the list just displays the ids.  

1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

Hi @Rashmivs17 ,

 

I'm unsure what you have done so far, but you can utilize the table m2m_kb_task table to get the most information.

AndersBGS_0-1709846446876.png

If you need further information, you can create a database where you relate the m2m_task_table and the sys_user table based on the created by = the user ID.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/