We have a number of users that have come into the SDP database with an erronous site. We clean this up, but any tickets created prior to the correction still have the erronous site.

Question 1

Is there a fast way to clean these up using a script or process? (Right now we are searching for all the tickets assigned to the user and updating the requests manually, but this is not a very efficient or quick process. Any better ideas?

Question 2

Is the region also assigned at this time of ticket creation? How can we update the region, since there isn't even a manual way to do this. Is there a script we can run that updates the requester's ticket assigning the region based on the site.

Thanks,

Adam