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.

Answer Summary:
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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.

Answered 05/01/2013 by: lmland
Tenth Degree Black Belt

Please log in to comment