Finding actively logged in device profiles

[shikamarunara]

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?

[dstaudt · Accepted solution]

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)

[shikamarunara]

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?

[dstaudt]

I believe that's right

[shikamarunara]

Thanks again, much appreciated.