Hi,

osticket version: v1.9.15 (70898b3)

I know we are working with an EOL version of osticket and I have already requestet for an update at our technical staff.

But maybe there is a solution for my task, which I can not find an answer for.

I found the following discussion, wich tells that there is no possibility for my task to mass change the owner of tickets:
https://forum.osticket.com/d/85107-mass-change-owner

So I would like to ask, if there is a solution in the UI (without manually changing database tables) to mass change the owner of several tickets?

Thanks so far,
Carsten

Several clicks? No

Go to Agent panel.
Click on Users.
Click on the user that you want to see the tickets for.
Click on the first ticket.
edit it.
enter the email of the person.
repeat.

or
To to the Agent panel -> Users.
Mouse over or click on the User who has the tickets that you want to move. Get their id=##. (lets say it was 50 for this demo).
Fire up your your favorite DB editor you can do something like:
SELECT default_email_id FROM ost_user WHERE id=50
That should give you a number. The number may in fact match, but do not assume it does with out checking.

REPEAT this for the user that you want to move them to. (for demo sake the user I want to change to is 23, email id 23.)

Then you can do this:
UPDATE ost_ticket SET user_id=23,use_email_id=23 WHERE user_id=50 AND use_email_id=50

Thanx ntozier,
changing by the UI is what I already know and is too much work by hand 😉
But making changes to to ost_user table does not sound like a big trick.
I am not good in sql, but as your given explanation show the changes step by step, I will give it a try 🙂
Carsten.

Write a Reply...