/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Access to K1000's Database Tables

08/12/2013 14144 views

By default, when a user (submitter) enters a ticket via email, they receive a return email stating that a support ticket has been entered. When a user enters a ticket via the user portal, they do not receive any email notification.

I am trying to create a custom ticket rule to respond to the submitter of a new ticket no matter the method of input. I am new to writing SQL queries, so I want to be able to see the various tables that are in the database. Currently, I am setting up MySQL Workbench to connect to our K1000. Is there anything that needs to be enabled on the Kbox to allow access?

Answer Summary:
0 Comments   [ + ] Show comments

Comments


All Answers

2

You have to allow database access in the settings. You also will have to set a report user password.

Settings>Security Settings>Enable database access

Settings>General Settings>Report User Password

If you have Organizations:

System>K1000 Settings>Security Settings>Enable database access

System>Organizations>your org>Report User Password

 

http://www.kace.com/support/resources/kb/article/can-i-access-the-k1000-appliance-database-using

Answered 08/14/2013 by: jknox
Red Belt

  • Perfect! thanks for the help, I was using the wrong username and password.
 
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