Lansweeper 6: Knowledgebase questions

[a_seiler]

Hi!

I was moving some word documents and FAQs to the lansweeper knowledgebase (appreciate this new feature btw!) and got to thinking about where they were stored. I assume the database but wanted to doublecheck if that indeed was the case.

Also, I know export features are a pain, but it would be neat if you could export the knowledgebase articles somehow (to a csv for instance, since you have a import csv function :)). This would mostly be for backing up information in my case but might have some other use-cases, depending on options for exporting articles.

[mike_carey]

Very helpful- I adjust the SQL to work when there is not userid on the createdby or alteredby, and to sort by category, then name.

Select Top 1000000 htblknowledgebasecategories.name As Category,
htblknowledgebase.name,
htblknowledgebase.kbid,
htblknowledgebase.added,
htblknowledgebase.altered,
htblusers_1.name As CreatedBy,
htblusers.name As AlteredBy,
htblknowledgebase.message
From htblknowledgebase
Inner Join htblknowledgebasecategories On htblknowledgebase.categoryid =
htblknowledgebasecategories.categoryid
Left Outer Join htblusers As htblusers_1 On htblknowledgebase.createdby =
htblusers_1.userid
Left Outer Join htblusers On htblknowledgebase.alteredby = htblusers.userid
Order By Category,
htblknowledgebase.name

[Karel_DS · Accepted solution]

The text for knowledgebase articles is indeed stored in the database, their attachments are located in Program Files (x86)\Lansweeper\Website\Knowledgebase\kbfiles.

There is no direct export feature for knowledgebase articles, but you could make a custom report and export from there. A simple example report would be:

SELECT htblknowledgebase.kbid, htblknowledgebase.name, htblknowledgebase.added, htblknowledgebase.message, htblknowledgebase.altered,
htblknowledgebasecategories.name AS Category, htblusers_1.name AS CreatedBy, htblusers.name AS AlteredBy
FROM htblknowledgebase INNER JOIN
htblknowledgebasecategories ON htblknowledgebase.categoryid = htblknowledgebasecategories.categoryid INNER JOIN
htblusers AS htblusers_1 ON htblknowledgebase.createdby = htblusers_1.userid INNER JOIN
htblusers ON htblknowledgebase.alteredby = htblusers.userid