Check Extension Mobility Login Status

[Murali_DS]

Hi,

Is there any way to check the EM login status apart from the one in Cisco Reporting - System reports - Unified CM Extension Mobilty. this tool doesn't give me a exact picture seeing a discrepancy on the report and it is not quite updated. 

Thx,

M

[Terry Cheema · Accepted solution]

Either you can check from the CUCM - Actively logged in devices (From devices, Phones > from the upper right corner dropdown)

Ref: http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/admin/8_6_1/ccmcfg/bccm-861-cm/b06phone.html#wp1373809

or

you can try to run the below SQL from CLI:

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

-Terry

Please rate all helpful posts

[piyush aghera]

5 stars for the SQL Query.  Very helpful.

[Muhammed Thasleem]

Hi Terry ,

Is it possible to get the previous login\logout report ?