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: jloven@cainetserv.com Web: http://www.cainetserv.com/