Run report of all versions of Jabber being used

[mramirez-t]

I see where I can go into Device > Phone and check each individually registered Jabber phone to see what version all our users are using, but is there a way to run a report that tells that?  We're running UCM 10.5

[Aman Soi]

Hi,

you can login into IMP and run this query. It would tell  Jabber version of current users logged in.

run pe sql ttlogin select * from clientsessions

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>68fc6440-8062-4a05-b501-bd8490f95a38</1><5>6</5><6>11.6.0.235651</6><2>d6cace2b-7b51-4d58-821a-b04325a3c8c0</2><4>null</4><3>91023527-2602-7e84-d08c-f20968fb0929</3><0>00000002:572a1bd4:000f3b5a:00002c68</0></old></msg>
<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>fb83ccb2-3604-4601-a526-01d60a5df68b</1><5>6</5><6>11.5.3.233111</6><2>bd5283b6-c4a9-2b6b-71c1-5efe7e94f049</2><4>null</4><3>59123c81-6646-5717-0545-0dfbf73996e8</3><0>00000001:57285fc8:000ddf8b:00005565</0></old></msg>

regds,

aman

[mramirez-t]

This is what I got.  Not sure what to do with this.

admin:run pe sql ttlogin select * from clientsessions
sqlRv(t) sqlstmt(select * from clientsessions;)
***result set start***
count(444), success(t)
<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>001fc22d-41cf-4ada-952e-f8f51c4be052</1><5>1</5><6>11.8.0.249632</6><2>056a803e-6157-47f4-b987-bab4b12c1e2f</2><4>null</4><3>23bdca99-d263-c056-c5df-e3bbf619e2b3</3><0>00000001:5ae08d24:00091d2e:0001f171</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>01045dae-fcf1-4447-8a96-fa10868cf66f</1><5>1</5><6>11.5.0.26858</6><2>fc248b49-db6a-cd67-cdf0-2285bbddd9ac</2><4>null</4><3>937eea9d-02f4-1fd0-b7e5-fc6db31d809e</3><0>00000001:5adf2bb3:000c10fb:0001e56c</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>011827c5-43f3-4ea4-8535-7cc3bcaa9010</1><5>1</5><6>11.8.3.51659</6><2>e68e02b9-1744-49bd-7a3a-6c78167c55ba</2><4>null</4><3>69648f66-dddc-11b3-5125-082f11a5a4a3</3><0>00000001:5ade1d48:00018372:0001df13</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>02d80402-e178-4d91-813e-fc33e7b50479</1><5>1</5><6>11.5.0.26858</6><2>a5b0496b-15db-45fe-b970-cf21442f2989</2><4>null</4><3>1ebba24b-b8b3-b398-f425-838f4dc429f5</3><0>00000001:58c949d1:00033a42:00000d6c</0></old></msg>

[Aman Soi]

Hi,

from the output shown, u can get Jabber versions .I have made them BOLD

msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>001fc22d-41cf-4ada-952e-f8f51c4be052</1><5>1</5><6>11.8.0.249632</6><2>056a803e-6157-47f4-b987-bab4b12c1e2f</2><4>null</4><3>23bdca99-d263-c056-c5df-e3bbf619e2b3</3><0>00000001:5ae08d24:00091d2e:0001f171</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>01045dae-fcf1-4447-8a96-fa10868cf66f</1><5>1</5><6>11.5.0.26858</6><2>fc248b49-db6a-cd67-cdf0-2285bbddd9ac</2><4>null</4><3>937eea9d-02f4-1fd0-b7e5-fc6db31d809e</3><0>00000001:5adf2bb3:000c10fb:0001e56c</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>011827c5-43f3-4ea4-8535-7cc3bcaa9010</1><5>1</5><6>11.8.3.51659</6><2>e68e02b9-1744-49bd-7a3a-6c78167c55ba</2><4>null</4><3>69648f66-dddc-11b3-5125-082f11a5a4a3</3><0>00000001:5ade1d48:00018372:0001df13</0></old></msg>

<msg><type>TTLOGIN</type><table>clientsessions</table><action>Q</action><time>0</time><old><1>02d80402-e178-4d91-813e-fc33e7b50479</1><5>1</5><6>11.5.0.26858</6><2>a5b0496b-15db-45fe-b970-cf21442f2989</2><4>null</4><3>1ebba24b-b8b3-b398-f425-838f4dc429f5</3><0>00000001:58c949d1:00033a42:00000d6c</0></old></msg>