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:
Please log in to answer
Posted by:
grayematter
8 years ago
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.
- http://dev.mysql.com/doc/refman/5.7/en/mysql.html
- http://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html
- http://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
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 8 years ago
