Access to K1000's Database Tables

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?

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: jknox 7 years ago
Red Belt

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



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


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