CustomerID on inbound emails to queue

[pstanbra]

This has to be really simple..

In the customer backend - there's an option to see all company tickets.
I understand that this is filtered on the customerID field.
I have just one customer user created on the backend. Think of him as my client onsite IT contact. The manager of the business who wants to see all tickets logged by his staff.
We do not set up a user for every staff member - this would take forever and would be a headache (clients are all separate remote businesses)

Instead - we set up a queue and a filter to move all emails from their @domain.com to the queue sent from many email addresses.
SO what I need is some way to set the customerID to all tickets on this filter so that they show up in Company Tickets.

I will also need to apply this ID to all previously logged tickets.
Any Ideas.

[jojo]

PostMaster Filter for Inbound and GenericAgent for existing tickets

[crythias]

generic agent. Apply filter. set customerID.

A fun query:

Code: Select all

select distinct concat("bin/otrs.AddCustomerUser.pl ", customer_user_id) from ticket where customer_user_id is not null and not (customer_user_id = "")