/build/static/layout/Breadcrumb_cap_w.png

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

03/27/2018 1316 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.