<!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.16945" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=860043715-23122009><FONT face=Arial size=2>Does anyone know of
a way to automate the retrieval of QRT entries in the
system?</FONT></SPAN></DIV>
<DIV><SPAN class=860043715-23122009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860043715-23122009><FONT face=Arial size=2>I'd like to get an
automatic weekly summary of calls that someone used the QRT button
for.</FONT></SPAN></DIV>
<DIV><SPAN class=860043715-23122009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860043715-23122009><FONT face=Arial size=2>I know I can get
that using a query in RTMT, but I want that to be automated?</FONT></SPAN></DIV>
<DIV><SPAN class=860043715-23122009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860043715-23122009><FONT face=Arial size=2>I don't know which
tables in the database the QRT info is stored in?</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>Tim Reimers</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Systems Analyst II</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Information Technology
Services</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>City of Asheville</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>70 Court Plaza</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Asheville, NC 28801</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>phone - 828-259-5512</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:timreimers@ashevillenc.gov">treimers@ashevillenc.gov</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>