03-02-2016 08:56 AM
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?
Solved! Go to Solution.
03-02-2016 11:31 AM
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:
03-02-2016 11:31 AM
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:
03-02-2016 12:29 PM
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?
03-02-2016 12:45 PM
I believe that's right
03-02-2016 12:48 PM
Thanks again, much appreciated.
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