[cisco-voip] UCM 6.01 Linux version - Listing phones in device pool and showing subscribed IP Phone services?

[Tim Reimers]

Hi everyone-
 
Running UCM 6.01
 
 
What I'm trying to do is get a list of phones that have a given service
configured on them.
I don't know of any way to list phones and show their services, nor can
I list phones from the service.
 
I do have the AXL SQL Tool Kit installed---
I can do the basic provided query via the XML file that returns
sample.xml.
 
I suspect there IS some way to ask this question in a massive Select
statement ---
but that could be a sledgehammer approach, and I don't even know the
table names or fields to be asking for.
 
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.
 
I've been using BAT successfully to add the service, but I'd like to
verify my work..
(thanks to those of you who pointed me to BAT and templates to do that)
 
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)
 
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> 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090106/40c0b7d1/attachment.html>