How to generate a report of Knowledge Base Articles, including the article text
I am creating KB articles within the KACE KBOX 1100 Service Desk module, and my co-workers would like to have a report or document they can easily scroll thru to see what the articles text is before they start using them, so they can get familiar with the text options without having to actually click thru or into each and every KB article to read them. I see I can export the KB list into a .csv file and the option exists to run a report, but I don't know how to acces or attach the article text to the report.
Anyone have any suggestions?
Thanks, as always, and in advance, for any help you can offer.
~ JSCHU67
Answers (1)
SELECT * FROM ORG1.ADVISORY;
That SQL query will give you a straight dump of all of the data in the ADVISORY table which is where the knowledge base articles are stored. If you want just the title and text you would use:
SELECT TITLE, NOTE FROM ORG1.ADVISORY;
Comments:
-
Thanks a lot, Chuck! - jschu67 11 years ago
