Hi, I wish to setup the rt-crontool (RT 3.6.17) to find tickets not acknowledged after 6 hours by using the "Told" field.
I am not able to select those ticket because the value of the Told field is "Not set". I've tried using '1970-01-01 00:00:00' but it does not work. /opt/rt3/bin/rt-crontool --search RT::Search::FromSQL --search-arg "Queue = 'network' AND (Status = 'new' OR Status = 'open') AND Told <= '1970-01-01 00:00:00'" --action RT::Action::Generic --verbose How can I look for tickets that have not been answered? Thanks for helping me.
-- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
