Kevin, Probably because I'm embarassed ;-). I've been really stumped as to what happend and now I've finally determined that ALL these tickets (120) with missing GROUP/PRINCIPALS Table records were created within 3 seconds and ALL in the same Queue over a year ago. That lead me to conclude that I had a User that went ahead and created a temporary scrip to mass create some tickets and failed to insert a GROUPS & PRINCIPALS record for each ticket in that code (BAD TOAD!!). I'll be stopping by his office for a few words (of wisdom).
This can be corrected, so no big deal at the moment, since all these tickets belong to the same person. By the way, I got rt-validator to run. Thanks. I'm going to set up a monthly cron job to run it so I can monitor stuff like this. Thanks for your help. Kenn LBNL On Tue, Jun 21, 2011 at 1:34 PM, Kevin Falcone <[email protected]>wrote: > On Tue, Jun 21, 2011 at 12:46:00PM -0700, Kenneth Crocker wrote: > > I also noticed, while perusing the DB, that there are a lot of gaps in > ticket numbers and the > > create dates are in the evening when no one is around in the building, > usually around midnight > > (TICKETS sorted in ID sequence). > > > > What is rt-validator? > > Kenn > > rt-validator ships with RT. Just run find /opt/rt3 -name rt-validator > and read the documentation. > > You've not given any information that would allow me to comment on > ticket id gaps. > > -kevin > > > -------- > 2011 Training: http://bestpractical.com/services/training.html >
-------- 2011 Training: http://bestpractical.com/services/training.html
