Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Jabber Usage Reports

I was wondering if there is a way to show Jabber usage reports.  We were wondering if there was a way to see how many people are logging in and using the application on a regular basis, etc.


Thanks in advance,

Alex LP

New Member

The system dashboard under

The system dashboard under Diagnostics in CUPS shows the "Logged-in XMPP users" as the amount of users logged in at the moment.  In terms of historical reports I'm not sure if there's a way of seeing peaks and troughs.  Between that and the compliance DB we get a fairly good idea of how well it's being used.

New Member

Hi everyone,

Hi everyone,

We have Cisco CUCM and IM&P 10.5; and I’m looking for your kind advice if there is a tool or way to have a statistics usage report for Cisco Jabber with below fields:-

Number of Calls, Call Duration, Source and Destination numbers, and QoS

I tried both Prime assurance and Presence-reports, but unfruitful. Even Solarwinds too.

Many thanks in advance.

Cisco Employee

No, there's no way to get an

No, there's no way to get an overview of ALL Jabber users, best you can do is use CAR and then search for the users who have a Jabber device to get their individual data.



if this helps, please rate
New Member

If there is data in your CAR

If there is data in your CAR database you can query it from CLI with run sql command:

run sql car SELECT callingpartynumber, finalcalledpartynumber, user_id, origdevicename, duration, origjitter, origlatency, orignumberpacketssent FROM car:tbl_billing_data WHERE origdevicename LIKE 'BOT%'

This for example gives you all records for devicenames that begins with BOT 

Use with caution.

New Member

Many thanks Rok,

Many thanks Rok,

Is there any reference for learning more on the SQL statements for Jabber, please.

many thanks again.

New Member

There is no such thing as SQL

There is no such thing as SQL for Jabber. It is just database you query.

I am sure you can find a lot of documentation and examples on the net.

You can start playing around from here:

Also a lot of info in this forum.

New Member

Hi Muhammad,

Hi Muhammad,

you should try IR Prognosis for UC ( That should give you your statistics.

New Member

Did you find a way to

Did you find a way to generate and historical report of Jabber logins?