For a list of all jabber users and their last login time, you can run the following query:
run 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
This date is in something called “epoch” format. To convert to something that makes sense, you’ll need to use the following formula:
This is for Eastern Standard Time where -5 = UTC -5, you can change this accordingly.