We have CUCM 9.1 and when I check the phones on web gui, peer firmware sharing is enabled for some phonesets and not for some..
How to discover which phonesets are not enabled for peer firmware sharing? I got a report from phone all details from bulk tool. But the detail is not seen on this report?
Any AXL query or recommendations is appreciated.
You may want to check out this blog by the great Bill Bell in his UCGuerrilla series;
I tried the query written in ucguerilla and it fails
admin:run sql select d.name,d.description,tm.name as phoneModel from device d inner join typemodel tm on d.tkmodel=tm.enum where d.xml like '%peerFirmwareSharing>0%' and d.name like 'SEP%' order by tm.name, d.name
Column (xml) not found in any table in the query (or SLV is undefined).
This is by far not my area of expertise ....(if there are any)....but that looks to me like a pre- CUCM 9.x type query, did you note the differences he makes for pre/post 9.x versions?
I'm sorry that I can't be of more help here, but I would encourage you to post this question on the IP Telephony sub-forum as well to get more eyes on this issue.
Hi It worked now by running these queries. Note that, it will show only the individual configurations. If the peer firmware sharing is configured via Common Phone profile you can't see them on the list below.
Peer Firmware sharing disabled phones
run sql select d.name,d.description from device d inner join devicexml4k dxml on dxml.fkdevice=d.pkid where dxml.xml like '%peerFirmwareSharing>0%'
Peer Firmware sharing enabled phones
run sql select d.name,d.description from device d inner join devicexml4k dxml on dxml.fkdevice=d.pkid where dxml.xml like '%peerFirmwareSharing>1%'