cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Eduardo_Cunha
Engaged Sweeper
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
3 REPLIES 3
rader
Champion Sweeper III

@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
Lansweeper Tech Support
Lansweeper Tech Support

@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
Engaged Sweeper II

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