<!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.17063" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=207211113-21062010><FONT face=Arial
color=#0000ff size=2>Thanks all -- </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207211113-21062010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=207211113-21062010><FONT face=Arial
color=#0000ff size=2>Mike's suggestion works fine.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207211113-21062010><FONT face=Arial
color=#0000ff size=2>Turns out the entire service for one paging subset is gone
--</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=207211113-21062010><FONT face=Arial
color=#0000ff size=2>I'll just have to recreate it and put it back on the
phones. </FONT></SPAN></DIV>
<DIV> </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><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Wilusz, Mike
[mailto:mikewilusz@pricechopper.com] <BR><B>Sent:</B> Friday, June 18, 2010
11:04 AM<BR><B>To:</B> cisco-voip@puck.nether.net list; Tim
Reimers<BR><B>Subject:</B> Re: [cisco-voip] SQL question --
services...<BR></FONT><BR></DIV>
<DIV></DIV>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="WORD-SPACING: 0px; FONT: medium Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -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="WORD-SPACING: 0px; FONT: medium Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -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="WORD-SPACING: 0px; FONT: medium Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -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 face=Arial size=2>Hi voipfolk...</FONT> </P>
<P><FONT face=Arial size=2>(thanks for the replies on my last one regarding
Hold/Transfer)</FONT> <BR><FONT face=Arial size=2> </FONT> <BR><FONT
face=Arial size=2>I have a question about getting a list of services assigned
to phones -</FONT> </P>
<P><FONT face=Arial size=2>Post a migration we did, I need to verify that
certain services (10+) are built on something like 50 phones.</FONT> </P>
<P><FONT face=Arial size=2>That would be a serious pain to do via the
GUI.</FONT> </P>
<P><FONT face=Arial size=2>Can anyone think of a way to get a list of services
and the phones subscribed to each service?</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>Tim Reimers</FONT> <BR><FONT face=Arial
size=2>Systems Analyst II</FONT> <BR><FONT face=Arial size=2>Information
Technology Services</FONT> <BR><FONT face=Arial size=2>City of
Asheville</FONT> <BR><FONT face=Arial size=2>70 Court Plaza</FONT> <BR><FONT
face=Arial size=2>Asheville, NC 28801</FONT> <BR><FONT face=Arial size=2>phone
- 828-259-5512</FONT> <BR><A href="mailto:timreimers@ashevillenc.gov"><U><FONT
face=Arial color=#0000ff size=2>treimers@ashevillenc.gov</FONT></U></A>
</P></DIV><SPAN><ATT00001..txt></SPAN></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>