you can go in to the service, and go to its dependency records to get a list of phones those subscribe to this service.<br><br>
<div class="gmail_quote">2009/1/7 Tim Reimers <span dir="ltr"><<a href="mailto:treimers@ashevillenc.gov">treimers@ashevillenc.gov</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div><span><font face="Arial" size="2">Hi everyone-</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">Running UCM 6.01</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><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><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><font face="Arial" size="2"></font></span> </div>
<div><span>
<div><span><font face="Arial" size="2">I do have the AXL SQL Tool Kit installed---</font></span></div>
<div><span><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><font face="Arial" size="2"></font></span> </div>
<div><span><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><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><font face="Arial" size="2"></font></span> </div>
<div><span><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><font face="Arial" size="2"></font></span> </div>
<div><span><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><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><font face="Arial" size="2"></font></span> </div>
<div><span><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" target="_blank">treimers@ashevillenc.gov</a></font></div>
<div> </div></div><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br>