<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Tim,<div><br></div><div>You don't necessarily need SQL for this. In CUCM, go to Device -> Device Settings -> Phone Services. Click on the service you want to find the phones that are associated to it. Once in the service (where it's lists ASCII service name...blah blah blah), in the upper-right there will be a drop-down for Related Links. It'll say "Go Back to Find/List." Change it to "Dependency Records" and click Go. The pop-up will list how many phones are using the service and if you click on the number, it'll display the actual devices. Hope this helps!</div><div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Mike Wilusz, CCNA<br>Telecommunications & Networking Supervisor<br>Price Chopper Supermarkets / The Golub Corporation<br> <br>E-Mail: <a href="mailto:MikeWilusz@PriceChopper.com">MikeWilusz@PriceChopper.com</a></div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Jabber/XMPP ID: <a href="mailto:MikeWilusz@golub.com">MikeWilusz@golub.com</a></div></span></div></span></span>
</div>
<br><div><div>On Jun 18, 2010, at 10:24 AM, Tim Reimers wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<div>
<!-- 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>
</div>
<span><ATT00001..txt></span></blockquote></div><br></div></body></html>