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   [ + ] Show Comments

Comments

Please log in to comment

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
Fourth 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

Answers

Answer this question or Comment on this question for clarity