Jabber logins

[themizzz21]

Hello,

Is it possible to find the jabber logins of an end user?

I found the following here https://community.cisco.com/t5/collaboration-applications/how-to-find-jabber-user-last-login/td-p/2552680 but this query

un sql select e.userid, cd.timelastaccessed from enduser as e, credentialdynamic as cd, credential as cr where 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 cd.timelastaccessed

will also return possible selfcare portal logins.

Thanks in advance.

[Jaime Valencia · Accepted solution]

There are no historical reports, there's an enhancement request but only for the last login:

Need reports of last login time of jabber users and the connection time.

CSCum79370

Presence usage report would provide real time data of users who are logged in when running the report.

The information you want would only be available by parsing logs to find out the login events.