<!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.16788" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>Hi
everyone-</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>Running UCM
6.01</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>What I'm trying to
do is get a list of phones that have a given service configured on
them.</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>I don't know of any
way to list phones and show their services, nor can I list phones from the
service.</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>I do have the
AXL SQL Tool Kit installed---</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>I can do the basic
provided query via the XML file that returns sample.xml.</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>I suspect there IS
some way to ask this question in a massive Select statement
---</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>but that could be a
sledgehammer approach, and I don't even know the table names or fields to be
asking for.</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>the game plan is to
list the devices in a device pool, with "what IP services are you subscribed to"
showing, so as to ensure that I've configured all phones and not missed
any.</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>I've been using BAT
successfully to add the service, but I'd like to verify my
work..</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>(thanks to those of
you who pointed me to BAT and templates to do that)</FONT></SPAN></DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=023415516-06012009><FONT face=Arial size=2>Also, it appears
that simply deleting the undesired service is safe and the phones no longer have
the service applied. (I forget who suggested
that)</FONT></SPAN></DIV></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </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>