cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
1377
Views
1
Helpful
4
Replies
Highlighted
Enthusiast

Finding actively logged in device profiles

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Cisco Employee

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)

View solution in original post

4 REPLIES 4
Highlighted
Cisco Employee

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)

View solution in original post

Highlighted

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?

Highlighted

I believe that's right

Highlighted

Thanks again, much appreciated.

Content for Community-Ad