/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Hi

I know that the Kace database can be queried remotely, and I am able to use MySQL Workbench to query it.  However, is there any way to run a query against the Kace database using a Linux CLI command?

Thank you.
--Tuyen
Answer Summary:
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Answer Chosen by the Author


Answers

0

If you have the query saved in a text file, try the following.  The connection information is the same that you used for MySQL Workbench

mysql --host=your.kbox.com --database=ORG1 --user=R1 --password=databasepassword < /path/to/query.sql > /path/to/output.txt

For more info on the command options, check the MySQL documentation.


Answered 04/29/2016 by: grayematter
Fifth Degree Black Belt

  • Thank you. I discovered this soon after as well. This is useful for when we want to make reports external from the Kace appliance.
Please log in to comment
Answer this question or Comment on this question for clarity

Answers