topic Re: Finding actively logged in device profiles in Management

Finding actively logged in device profiles

shikamarunara — Wed, 02 Mar 2016 16:56:02 GMT

Hi,

I'm writing a query to find out if a phone has been logged into with extension mobility. I've written the following, but I doubt it has enough information to do what I need and will likely create a join;

select * from Device where tkDeviceProfile != '0' and tkDeviceProfile != '3' and tkDeviceProfile != '4'

This will give me the full list of device profiles, but nothing about their state or which phone is using it. Can someone tell me where the states are kept?

Re: Finding actively logged in device profiles

dstaudt — Wed, 02 Mar 2016 19:31:29 GMT

Take a look at the extensionmobilitydynamic table:

https://developer.cisco.com/site/axl/documents/latest-version/datadictionary11-0-1.gsp

Also the Extension Mobility API, which makes it pretty easy to query this kind of info:

Cisco DevNet: Extension Mobility API (EMAPI)

Re: Finding actively logged in device profiles

shikamarunara — Wed, 02 Mar 2016 20:29:56 GMT

Hi dstaudt,

Thank you for replying. Just making sure I'm understanding the table properly based on the database dictionary; the two fields that look like I would be primarily interested in are fkdevice and fkdevice_currentloginprofile. These two fields contain the uuid of the phone that's logged into (if it's logged into), and the uuid of the device profile being used?

Re: Finding actively logged in device profiles

dstaudt — Wed, 02 Mar 2016 20:45:21 GMT

I believe that's right

Re: Finding actively logged in device profiles

shikamarunara — Wed, 02 Mar 2016 20:48:50 GMT

Thanks again, much appreciated.