[cisco-voip] SQL question -- services...

[Tim Reimers]

Thanks all -- 
 
Mike's suggestion works fine.
Turns out the entire service for one paging subset is gone --
I'll just have to recreate it and put it back on the phones. 
 
Tim Reimers
Systems Analyst II
Information Technology Services
City of Asheville
70 Court Plaza
Asheville, NC 28801
phone - 828-259-5512
treimers at ashevillenc.gov <mailto:timreimers at ashevillenc.gov> 
 

________________________________

From: Wilusz, Mike [mailto:mikewilusz at pricechopper.com] 
Sent: Friday, June 18, 2010 11:04 AM
To: cisco-voip at puck.nether.net list; Tim Reimers
Subject: Re: [cisco-voip] SQL question -- services...


Tim, 

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!

Mike Wilusz, CCNA
Telecommunications & Networking Supervisor
Price Chopper Supermarkets / The Golub Corporation
 
E-Mail: MikeWilusz at PriceChopper.com
Jabber/XMPP ID: MikeWilusz at golub.com

On Jun 18, 2010, at 10:24 AM, Tim Reimers wrote:



	Hi voipfolk... 

	(thanks for the replies on my last one regarding Hold/Transfer) 
	  
	I have a question about getting a list of services assigned to
phones - 

	Post a migration we did, I need to verify that certain services
(10+) are built on something like 50 phones. 

	That would be a serious pain to do via the GUI. 

	Can anyone think of a way to get a list of services and the
phones subscribed to each service? 

	I can get a report of phones in a device pool and use that to
compare once I have the data regarding services/subscription.

	Tim Reimers 
	Systems Analyst II 
	Information Technology Services 
	City of Asheville 
	70 Court Plaza 
	Asheville, NC 28801 
	phone - 828-259-5512 
	treimers at ashevillenc.gov <mailto:timreimers at ashevillenc.gov>  

	<ATT00001..txt>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100621/133e1fca/attachment.html>