Logo
login: password:
register | forgot?

Knowledgebase

After a migration, how do I remove all my workers as requesters on tickets?


After a migration your workers may show up as requesters on some tickets. This is because the Cerb 1.0 to 3.x databases stored the workers address as the sender, while Cerb 4.0 stores the helpdesk address as the sender (for better security/privacy).

This affects you if you notice your workers show up on the "To:" line when replying to tickets.

Rather than having to remove requesters from ticket properties every time, the easiest way to remove all your workers as requesters on tickets is to interact with the database directly.

First you can find a list of all your workers who are also requesters on tickets:

SELECT count(*),a.id,a.email FROM requester r, address a, worker w WHERE w.email=a.email AND a.id=r.address_id group by a.id;

Then you can use the returned IDs (second column) to clear the requester links.

DELETE FROM requester WHERE address_id IN (1,2,3,4);

Make sure you replace the IDs in the statement above ("1,2,3,4") with the IDs returned by the first query for any workers you want to unlink.

If you have other addresses who aren't workers that you'd also like to globally unlink as requesters, such as past team members who aren't set up in your new helpdesk, you can find their IDs with a simple query like:

SELECT id FROM address WHERE email = 'long_gone@company.com';

If you have any trouble with this, feel free to contact our support team by e-mail or forums.
Powered by Cerberus Helpdesk 4.0™