Scripting Question

Exporting Entire KACE K1000 knowledge base to CSV

06/07/2017 2651 views
Ok so we are moving away from kace as our place to store knowledge base stuff and going to be using confluence. i need to export to entire knowledge base to another format that i can use to import in to confluence. i tried to use SELECT * FROM ORG1.ADVISORY; in reports to export to a CSV but i did not get the entire "TEXT" field.

I need to report to be able to give me everything from every field. Any help is welcome. Thanks 
1 Comment   [ + ] Show comment


  • what are you using to query the database?
    • well from what i found the guide had told me to do it in the reports section from with in kace. Im by no means a database person so any help as to what i should be using to get what i need would be helpful. Thanks

All Answers

  1. Download and install Toad for MySQL (link)
  2. See this KB article for details on installing the MySQL driver
  3. Start Toad and create a new connection. The details for this connection are located in step 6 in the numbered list in the KB article.
If your knowledge base table has thousands of rows then use the "Export Wizard" in Tools > Export > Export Wizard. Otherwise, run the query in an "editor" window then copy/paste the results to your favorite spreadsheet program.

Technical note: the database engine of KACE is actually "MariaDB" and not "MySQL" but they're essentially the same thing: MariaDB has a few more features and is not owned by Oracle.
Answered 06/21/2017 by: JasonEgg
Red Belt

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ