Parent ticket Attachments to Child tickets
I have found several different SQL statements that will allow me to copy custom fields from the parent ticket to the child tickets when they get created but, what I am looking for however is a way to take the attachment of a parent ticket and attach it to all child tickets. I have found the correct tables that link the parent tickets to their attachments, but so far am unsuccessful at writing the correct update statement. Apparently KACE does not grant update statement within MySQL so it is impossible to run test.
Has anyone written a successful select / update statement to push Parent attachments to Child tickets?
Be the first to answer this question