[cisco-voip] Jabber utilization report

[Gary Parker]

> On 18 May 2016, at 16:36, Brian Meade <bmeade90 at vt.edu> wrote:
> 
> There is a Presence Usage Report on the Cisco Unified IM and Presence Reporting dropdown but it only gives you current logged in clients.
> 
> On Tue, May 17, 2016 at 1:53 PM, Louis Koekemoer (ZA) <Louis.Koekemoer at dimensiondata.com> wrote:
> 
> 
> Hi all,
> 
> 
> 
> I have a customer where we deployed Jabber. The client now want a report on the user take-on and utilization of Jabber after the deployment. Does anyone know where one can get a report like that?

NB. this is for 8.6, ymmv with later versions…

If you login on the CLI and run this:

run sql select e.userid, ex.firstname, ex.lastname, ex.department, DBINFO('utc_to_datetime', cd.timelastaccessed) AS lastaccess from enduser as e, credentialdynamic as cd, credential as cr, enduserex as ex where e.pkid = ex.fkenduser and e.pkid=cr.fkenduser and e.tkuserprofile=1 and e.primarynodeid is not null and cr.tkcredential=3 and cr.pkid=cd.fkcredential order by last access

You’ll get a list of all presence users ordered by the last time they logged in. Run it periodically, log the data and build some usage stats. Not perfect, I know, but better than nothing...

---
/-Gary Parker----------------------------------f--\
|     Unified Communications Service Manager      |
n      Loughborough University, IT Services       |
|     tel:+441509635635 im:ccgjp at lboro.ac.uk      o
|     http://delphium.lboro.ac.uk/pubkey.txt      |
\r----------------------------------------------d-/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 842 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160519/360f9a1e/attachment.sig>