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

[Matthew Saskin]

Here you go: phone name, description, with device pool listed and all
subscribed services

run sql select DP.name,D.name,D.description,T.name
from device D
join devicepool DP on D.fkdevicepool = DP.pkid
join telecastersubscribedservice TS on D.pkid = TS.fkdevice
join telecasterservice T on TS.fktelecasterservice = T.pkid


-matt


On Wed, Jan 7, 2009 at 1:05 AM, Jacky Cai <jackycxh at gmail.com> wrote:

> you can go in to the service, and go to its dependency records to get a
> list of phones those subscribe to this service.
>
> 2009/1/7 Tim Reimers <treimers at ashevillenc.gov>
>
>>  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 <timreimers at ashevillenc.gov>
>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090107/c114b07c/attachment.html>