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:
Please log in to answer
Posted by:
lmland
11 years ago
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.