/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Where is the parent table in Kace?

08/13/2015 1321 views
There are plenty of posts here about copying information from Parent to Child tickets on Kace. In pretty much all of the suggested scripts they reference the Parent table. However, if you use a tool like Heidi or Workbench, the Parent table does not appear in the schema. Is the Parent table referenced in the scripts an alias for another table?
0 Comments   [ + ] Show comments

Comments


All Answers

2
You may find the answer is actually in the HD_TICKET table.

HD_TICKET.IS_PARENT has a default value of 0 and when marked as a parent the value changes to 1

HD_TICKET.PARENT_ID will contain the linked parent ticket value if the ticket is a child

In the SQL rules given as solutions the PARENT.ID is actually a created variable during the ticket rule, just so that you can identify the specific data.

Hopefully that helps a little
Answered 08/13/2015 by: Hobbsy
Red Belt

  • I didn't spot that, thanks for the help

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