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

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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;

Answered 07/25/2013 by: chucksteel
Red Belt

  • Thanks a lot, Chuck!
Please log in to comment
Answer this question or Comment on this question for clarity

Share