/build/static/layout/Breadcrumb_cap_w.png

Need Update query to change unassigned tickets

So, I did a dumb thing and deleted a ticket owner out of our system. Now all her tickets are unassigned. I want to make them all assigned to her again. I have the select query, but don't know what the update query should look like. This is unchartered waters for my SQL skills.


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: lmland 11 years ago
10th Degree Black Belt
0

I figured it out by searching for all closed tickets in Kace ordering by owner, selecting all of the unassigned tickets and reassigning them to her. The SQL was going to be more of a problem than it was worth. Nice GUI workaround.

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