I had a problem with my database a while back due to a
generic agent job that was touching the tickets and creating a huge ticket
history. Sooo…I ran a pass on the database to trim the “junk”
records off the history. That worked fine. Unfortunately it was late at night and
I was tired and I accidentally ran another query that nuked the “ticket
created” record for a lot of tickets. This isn’t really causing a
problem except that historical stats are now breaking because they don’t
see the create record. I would have just restored the backup but then I would
have lost a good chunk of data from the last few hours of the day.
Does anyone have strong enough MySQL-fu and knowledge of
OTRS to create a SQL query that will create a new “ticket created”
record in tickets that don’t have one? I see various places to pull the
creation data from (dates, etc) so I think that it should be fairly possible to
do but my MySQL skills are weak.
Thank you,
Jason Loven
Manager - Technical Services Department
Computer Associates, Inc.
Phone: (401)232-2600, Fax: (401)232-7778
Email: jloven@cainetserv.com
Web: http://www.cainetserv.com/