Knowledgebase Report

[Eduardo_Cunha]

Guys, we want to be able do generate a report to show the Agents with more knowledgebase articles created. The main objective is to encourage them to use more the application.

Does anyone know how to pull this information from Lansweeper? Could't find any reports for KB.

Thanks,
Ed

[rader]

@WilsonTech - Starting with ErikT's example I've expanded it to include more relatable information.

Select Distinct Top 1000000 htblknowledgebase.kbid As [KB ID],
  htblknowledgebasecategories.name As [KB Category],
  htblusers.name As [Author's Name],
  htblknowledgebaseattachments.filename As [KB Article Name],
  htblknowledgebase.added As [KB Added],
  htblknowledgebase.altered As [KB Last Changed]
From htblknowledgebase
  Inner Join htblknowledgebasecategories On
      htblknowledgebasecategories.categoryid = htblknowledgebase.categoryid
  Inner Join htblknowledgebasecategoriesteams On
      htblknowledgebasecategories.categoryid =
      htblknowledgebasecategoriesteams.categoryid
  Inner Join htblusers On htblusers.userid = htblknowledgebase.createdby
  Inner Join htblknowledgebaseattachments On htblknowledgebase.kbid =
      htblknowledgebaseattachments.kbid
Order By [KB ID],
  [KB Category]

See if this works as well.

[ErikT]

@Eduardo_Cunha 

Please find a sample report below that shows the number of knowledge base articles created for each user. 

Instructions for adding this report to your Lansweeper installation can be found in this article.  

Select Distinct Top 1000000 htblusers.name As name1,
  Count(Distinct htblknowledgebasecategories.name) As [number of articles]
From htblknowledgebase
  Inner Join htblknowledgebasecategories On
      htblknowledgebasecategories.categoryid = htblknowledgebase.categoryid
  Inner Join htblknowledgebasecategoriesteams On
      htblknowledgebasecategories.categoryid =
      htblknowledgebasecategoriesteams.categoryid
  Inner Join htblusers On htblusers.userid = htblknowledgebase.createdby
Group By htblusers.name

[WilsonTech]

Resurrecting a dead post because there was no reply to this and I want the same report.