Extension Mobility Last logged on Phone for cluster

[abakshi01]

Hello Team,

I need to know last logged on cisco 7945 phone using Extension mobility for the cluster. Could you please tell me what query we can on CLI or any possible way using BAT query.

[Carlo Poggiarelli]

Hi,

From CUCM command line run:

run sql select enduser.userid,device.name,datetimestamp from extensionmobilitydynamic  inner join enduser on extensionmobilitydynamic.fkenduser_lastlogin=enduser.pkid inner join device on extensionmobilitydynamic.fkdevice=device.pkid where device.name = 'SEPXXXXXX' where SEPXXXXX is the device name of the IP Phone you want to check.

HTH

Regards

Carlo