03-26-2015 01:02 AM - edited 03-18-2019 11:28 AM
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
Solved! Go to Solution.
03-26-2015 01:40 AM
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
03-26-2015 01:40 AM
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
04-07-2015 06:46 AM
5 stars for the SQL Query. Very helpful.
01-02-2016 11:42 PM
Hi Terry ,
Is it possible to get the previous login\logout report ?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide