Anyway to tell when the last time a device profile was logged into for Emob?

[hanluc6933]

I'm currently cleaning up unused direct inward dial numbers and I'm trying to determine if the device profiles that have extensions associated to them are no longer in use.  Are there any cisco reports where I can see when the last time a device profile was logged into?

Thanks,

~Han

[Jaime Valencia]

https://community.cisco.com/t5/ip-telephony-and-phones/extension-mobility-last-logged-on-phone-for-cluster/td-p/2784815

https://community.cisco.com/t5/ip-telephony-and-phones/cucm-8-6-extension-mobility-logging/td-p/2108176

[Mohammed al Baqari · Accepted solution]

Hi,

use this sql query in cucm

run sql select eu.userid, emd.logintime, emd.loginduration,
emd.datetimestamp from extensionmobilitydynamic emd inner join enduser eu
on emd.fkenduser_lastlogin=eu.pkid

then paste the result in excel and convert the date/time cells using below
link to get it in readable format

https://community.cisco.com/t5/other-collaboration-subjects/cdr-quot-datetimeorigination-quot-conversion-formula-in-excel/td-p/231546

***** remember to rate useful posts

[hanluc6933]

This is exactly what I was looking for.  Thank you kindly for the excellent instructions!