Run report of Jabber versions plus device name

[mramj499]

Trying to find out who in my user base needs their Jabber version updated.  So I found in a different Cisco support forum post that running this command on my IMP server will spit back all versions that are currently registered to IMP.  However, I don't know how to associate this to an actual user.  The output and command are both below.  The output shows hte version (bold).  If it could tell me what directory number is for that device, or device name, or user name, I can take it from there.  But this doesn't help me much because I can't use it to reach out to individual people to get their versions upgraded.

Any help is appreciated.

This is the command:

run pe sql ttlogin select * from clientsessions

This is the output:

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>21617917-d660-4fff-a2bc-5701b28b04d1</1><5>1</5><6>12.1.1.19866</6><2>e2feacb8-e73c-357d-5aa7-c217b10c2d9c</2><4>null</4><3>690e53b7-727d-78eb-1529-525d2b62c759</3><0>00000002:5e469ff2:00040de9:000950a3</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>23171503-2dc3-4108-aa78-eb5034986171</1><5>1</5><6>12.6.1.284405</6><2>968fb460-9dc2-491e-a165-6fcf66a388bf</2><4>null</4><3>54914ce1-84f0-26be-710a-47ecfc0be713</3><0>00000002:5e4698e8:00009e4d:00094f1b</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>23b11b96-de5a-4390-adab-998e4437d7e4</1><5>1</5><6>11.8.3.51659</6><2>b12081ff-473f-c948-61af-8b33a2439510</2><4>null</4><3>e3e8725c-2639-ac23-19b1-6f9a70e9d247</3><0>00000002:5e46a31a:0002d50d:000951a0</0></old></msg>

[Andrew Skelly]

Do you have a default firmware version defined in CUCM?  If so, you can go to Device - Device Settings - Firmware Load Information.  This will show you the amount of phones that have a firmware different from the defined default.  One thing to consider though is if you manually specify a Phone Load Image on the device configuration, if it is the same as the default it will still show up as not using the default even though it really is.

[mramj499]

Under Firmware Load Information, I do see all the Load Information/Device Type/Device Not Using Default Load.  But only one doesn't say None, which is 7961G-GE for some physical phones.

[Andrew Skelly]

I'm not sure how large your environment is but you can log in to each subscriber and run the "show risdb query phone" command.  This will give you the output of all the phones on the cluster in the below output format.  I'm sure there is a sql query you can run against tk.model = '503' (503 is for CSF), however SQL is not my strong point so I will defer to others to offer guidance there.  If you want to see what the enum is for all phone models you can use: run sql select enum,name from typemodel

DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus,
 PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#,
 RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId,
 DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp, Perfmon Object

[Roger Kallberg]

---

@Andrew Skelly wrote:

Do you have a default firmware version defined in CUCM?  If so, you can go to Device - Device Settings - Firmware Load Information.  This will show you the amount of phones that have a firmware different from the defined default.  One thing to consider though is if you manually specify a Phone Load Image on the device configuration, if it is the same as the default it will still show up as not using the default even though it really is.

---

What you described applies to phones and other hardware devices, not to Jabber.

[refram]

When I take a look at the Load information it shows all of my Jabber phones are not using the default load.  And it's saying that the default load is sip88xx.12-5-1SR1-4, which - y'know - isn't a client services framework file.  I have no idea how this happened and no idea how to fix it.  There doesn't seem to be a place where a load can be configured for a CSF device.  Does anyone have some idea where this can be changed?

[Andrew Skelly]

To the best of my knowledge you can't.  You will need to download a copy of Jabber from Cisco and install it on each computer/laptop you want it on.

[b.winter]

There is nothing like a "Jabber Phone" and therefore, you cannot set a load version in the phone configuration page for a CSF device.
And it doesn't use a phone firmware like 88xx at all.

CUCM doesn't have a firmware for Jabber installed and doesn't control the version either. You just install Jabber on the PC like a normal programm.

[refram]

I looked and didn't see anything dealing with a place where a firmware load could be configured before I wrote, so I am in agreement with you B.  However, the loads that I described do show up.  What I should have clarified is that the place where I'm seeing these loads is in CUCM  reports.  If I navigate to Reports and select phones with mismatched firmware loads, all these Client Service Framework phones show up with 88xx loads configured.  Is this just a bug?

[Jaime Valencia]

You can get the username with two SQL queries, in here:

https://cway.cisco.com/docs/tools/CollaborationSolutionsAnalyzer/csa.callengine.supportedproducts.html