Active/Inactive Jabber Report

[rikardkrvaric]

Is there a possibility to pull a report out of IM&P to find out who hasn't logged in to Jabber for a period of time?
Let's say... hasn't logged in to Jabber in past 90 days, or 6 months, or ever?

[Ratheesh Kumar]

Hi there

I think may be using traces. Other than that I dont think so there is an option.

try this

http://benmorgan.com.au/blog/cisco-jabber-last-logged-in-report/

Though this was an enhancement in Cisco 

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCuv26808?referring_site=bugquickviewredir

Hope this Helps

Cheers
Rath!

***Please rate helpful posts and if applicable mark "Accept as a Solution"***

[nnikolaev · Accepted solution]

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

[rikardkrvaric]

This query works, but it gives me anybody that has ever logged in to the UC system... not necessarily Jabber.

I see this because I have SIP devices that have end users, but no Jabber account.

These accounts are listed on this report, but I can have them removed.

Thanks much @nnikolaev !