Exporting Entire KACE K1000 knowledge base to CSV
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? - JasonEgg 6 years ago
-
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 - mastermoder2 6 years ago
Answers (1)
Please log in to answer
Posted by:
JasonEgg
6 years ago
- Download and install Toad for MySQL (link)
- See this KB article for details on installing the MySQL driver
- 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.
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.
