<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=796434719-18072007><FONT face=Arial
size=2>All-</FONT></SPAN></DIV>
<DIV><SPAN class=796434719-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=796434719-18072007><FONT face=Arial size=2>My boss wants to
know if we're meeting our response times (SLAs) whenever a ticket is submitted.
I'd like to know if anyone has a quick SQL query to accomplish this (or point me
to a spot in the wiki). For example: 10 tickets submitted today, and 6 of
users were contacted by a tech (via RT) within 1 hour. </FONT></SPAN></DIV>
<DIV><SPAN class=796434719-18072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=796434719-18072007><FONT face=Arial
size=2>regards,</FONT></SPAN></DIV>
<DIV><SPAN class=796434719-18072007><FONT face=Arial size=2>Mike
M.</FONT></SPAN></DIV></BODY></HTML>