If they affected a ticket, Generic Agent will have used the API to make those changes, and therefore the ticket_history.create_time related to such change will be identical, or very close, to the time of Generic Agent action.

Sample query that gives you a bit of detail on what happened:
 SELECT ticket.tn, ticket_history.name, ticket_history_type.name, ticket_history.create_time FROM ticket_history LEFT JOIN ticket ON ticket.id=ticket_history.ticket_id  LEFT JOIN ticket_history_type ON ticket_history_type.id = ticket_history.type_id WHERE ticket_history.create_time between "2012-07-07 14:50:00" AND "2012-07-07 14:54:00"

If you just want ticket numbers, remove the other columns and append GROUP BY ticket.tn




On Tue, Nov 6, 2012 at 3:28 AM, Bogdan Iosif <bogdan.iosif@gmail.com> wrote:
Hi,

I have a couple of db Generic Agent jobs (configured through admin frontend GUI) and I would like to know the tickets affected by these jobs on each execution.

Looking in otrs.log I can see one line for each job execution, like this:

[Tue Nov  6 10:20:02 2012][Notice][Kernel::System::GenericAgent::JobRun] Run GenericAgent Job '...' from db.

I would like to know, at least, the ticket numbers for the affected tickets. Is there any way to achieve this with configurations?

Thanks,
Bogdan



---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs