Here you go: phone name, description, with device pool listed and all subscribed services<br><br>run sql select DP.name,D.name,D.description,T.name<br>from device D<br>join devicepool DP on D.fkdevicepool = DP.pkid<br>join telecastersubscribedservice TS on D.pkid = TS.fkdevice<br>
join telecasterservice T on TS.fktelecasterservice = T.pkid<br><br><br>-matt<br><br><br><div class="gmail_quote">On Wed, Jan 7, 2009 at 1:05 AM, Jacky Cai <span dir="ltr"><<a href="mailto:jackycxh@gmail.com">jackycxh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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" target="_blank">treimers@ashevillenc.gov</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c">
<div>
<div><span><font size="2" face="Arial">Hi everyone-</font></span></div>
<div><span><font size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">Running UCM 6.01</font></span></div>
<div><span><font size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">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 size="2" face="Arial">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 size="2" face="Arial"></font></span> </div>
<div><span>
<div><span><font size="2" face="Arial">I do have the AXL SQL Tool Kit installed---</font></span></div>
<div><span><font size="2" face="Arial">I can do the basic provided query via the XML file that returns sample.xml.</font></span></div>
<div><span><font size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">I suspect there IS some way to ask this question in a massive Select statement ---</font></span></div>
<div><span><font size="2" face="Arial">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 size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">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 size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">I've been using BAT successfully to add the service, but I'd like to verify my work..</font></span></div>
<div><span><font size="2" face="Arial">(thanks to those of you who pointed me to BAT and templates to do that)</font></span></div>
<div><span><font size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">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 size="2" face="Arial"></font> </div>
<div align="left"><font size="2" face="Arial">Tim Reimers</font></div>
<div align="left"><font size="2" face="Arial">Systems Analyst II</font></div>
<div align="left"><font size="2" face="Arial">Information Technology Services</font></div>
<div align="left"><font size="2" face="Arial">City of Asheville</font></div>
<div align="left"><font size="2" face="Arial">70 Court Plaza</font></div>
<div align="left"><font size="2" face="Arial">Asheville, NC 28801</font></div>
<div align="left"><font size="2" face="Arial">phone - 828-259-5512</font></div>
<div align="left"><font size="2" face="Arial"><a href="mailto:timreimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a></font></div>
<div> </div></div><br></div></div>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">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>
<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>