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. 36 Thurber Blvd, Smithfield RI 02917 Phone: (401)232-2600, Fax: (401)232-7778 Email: [EMAIL PROTECTED] Web: http://www.cainetserv.com/
_______________________________________________ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
