/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Can i have the list of field names under table 'HD_ARCHIVE_TICKET'

03/27/2018 1700 views
i have no means (sql developer) to access my KACE database. this info will help me to manipulate reports i am trying to create
0 Comments   [ + ] Show comments

Comments


All Answers

1
I could give you the list, but nope, being honest it will be best for you if you could get access to the Database, you do not need to worry about damages, if you are planning to read values, and learn How a particular table is composed.

I suggest you try to follow this KB article:
https://support.quest.com/kace-systems-management-appliance/kb/114992/can-i-access-the-k1000-appliance-database-using-a-third-party-reporting-tool-

You could also use a lightweight SQL software such as Heidi SQL, we used that one, pretty easy to setup and it works fine with the K1 DB.

Answered 03/27/2018 by: Channeler
Red Belt

  • Thank you, now my supervisor will have me doing way more reports :-/
  • I like MySQL Workbench for browsing the tables and creating reports.

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