AccumulatedTimeTrackerAutmation.sql

/*
1. Create an automation in Admin > Rules and Triggers > Automations
2. Then add a Custom "WHERE" Clause criteria along with other criteria.
*/
xRequest in (select xRequest from (select sum(iSeconds)
TotalTime, xRequest from HS_Time_Tracker group by xRequest) as
TimeList where TotalTime > 3000)
/*
You will want to replace "3000" in this code with the number of seconds that you want to check for. 35 minutes would be 2100 second I believe. Then add your actions that you want to perform on the request. Your completed automation should look something like this http://drop.userscape.com/Ep5g/1nXCRqpE.
Note that you want to make sure that you have a condition in the automation that will prevent it from running more than once. So in my example I'm checking if the request has already been escalated and if it has, the request won't meet the criteria.
As always with automations make sure you use the test button to see what requests are going to be affected.
*/