CUCM SQL request EM and phones

[Bekzod Fakhriddinov]

Hi, what is the correct way to pull phones out which don't have EM logged in users ? 

I am using "select fkdevice from extensionmobilitydynamic where logintime is NULL" , but not sure ...

Thank you 

[HARIS_HUSSAIN]

Check if below helps
https://community.cisco.com/t5/ip-telephony-and-phones/extension-mobility-report/td-p/2965809

*** Please rate helpful post &; Mark "Accept as a Solution" if applicable

Thanks,
Haris

[Bekzod Fakhriddinov]

No my friend, my question is a little bit different.