Ticket Life Report
For anyone who wanted it -- we built a report to show ticket lifetime averages (see the last page of the generated report).
Cheers
SELECT wo.WORKORDERID 'Request ID',wo.CREATEDTIME 'Created Time',wo.COMPLETEDTIME 'Completed Time',wo.TIMESPENTONREQ 'Elapsed Time',std.STATUSNAME 'Request Status' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((((wo.CREATEDTIME >= 1167624000635) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1189047599634) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)))) AND (wot.THD_WOID = wot.WORKORDERID))
Cheers
SELECT wo.WORKORDERID 'Request ID',wo.CREATEDTIME 'Created Time',wo.COMPLETEDTIME 'Completed Time',wo.TIMESPENTONREQ 'Elapsed Time',std.STATUSNAME 'Request Status' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((((wo.CREATEDTIME >= 1167624000635) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1189047599634) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)))) AND (wot.THD_WOID = wot.WORKORDERID))