Gary beat me to the SQL option... ;-) The other option if you're running the IM compliance by logging to an external PGSQL database is that you can get stats on the number of messages sent etc etc, I had a good dev working with me who anonymised this and made some pretty graphs...
The only commercial option I'm aware of is tiger communications ( www.tigercomms.com) who whilst coming more from the billing side of things have built some UC adoption reporting into their latest product. HTH IAn On Thursday, 19 May 2016, Gary Parker <g.j.par...@lboro.ac.uk> wrote: > > > On 18 May 2016, at 16:36, Brian Meade <bmead...@vt.edu <javascript:;>> > 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.koekem...@dimensiondata.com <javascript:;>> 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:cc...@lboro.ac.uk <javascript:;> o > | http://delphium.lboro.ac.uk/pubkey.txt | > \r----------------------------------------------d-/ > >
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip