/build/static/layout/Breadcrumb_cap_w.png

Supporting Linux Question


How can I remotely query the Kace database using a Linux CLI command?

04/27/2016 943 views
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:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

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
5th 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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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