/build/static/layout/Breadcrumb_cap_w.png

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

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

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: grayematter 7 years ago
5th Degree Black Belt
0

Top Answer

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.



Comments:
  • Thank you. I discovered this soon after as well. This is useful for when we want to make reports external from the Kace appliance. - tuyen 7 years ago

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