<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>SQL question -- services...</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">Hi voipfolk...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">(thanks for the replies on my last one regarding Hold/Transfer)</FONT>
<BR><FONT SIZE=2 FACE="Arial"> </FONT>
<BR><FONT SIZE=2 FACE="Arial">I have a question about getting a list of services assigned to phones -</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Post a migration we did, I need to verify that certain services (10+) are built on something like 50 phones.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">That would be a serious pain to do via the GUI.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Can anyone think of a way to get a list of services and the phones subscribed to each service?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I can get a report of phones in a device pool and use that to compare once I have the data regarding services/subscription.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Tim Reimers</FONT>
<BR><FONT SIZE=2 FACE="Arial">Systems Analyst II</FONT>
<BR><FONT SIZE=2 FACE="Arial">Information Technology Services</FONT>
<BR><FONT SIZE=2 FACE="Arial">City of Asheville</FONT>
<BR><FONT SIZE=2 FACE="Arial">70 Court Plaza</FONT>
<BR><FONT SIZE=2 FACE="Arial">Asheville, NC 28801</FONT>
<BR><FONT SIZE=2 FACE="Arial">phone - 828-259-5512</FONT>
<BR><A HREF="mailto:timreimers@ashevillenc.gov"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">treimers@ashevillenc.gov</FONT></U></A>
</P>
</BODY>
</HTML>