I'll be implementing something very similar soon and my line of thinking
was an hourly script with:
$RT::Handle->SimpleQuery("update Tickets set status = 'stalled' where
status ='open' and LastUpdated < (now() - interval 12 hour)");
??
Roy
Mathew Snyder wrote:
has anyone written a scrip or script that will automatically set a
ticket to stalled after a certain period of inactivity?
Mathew Snyder
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
