How to get the Phone IP address having the extension number?

Version 1
    This document was generated from CDN thread

    Created by: Marcelo Rocha on 09-08-2008 09:09:56 PM
    I've got the extension number form Active Directory using LDAP.
    Then I need to get the IP address from extension to push data to the phone.

    I try to use AXL, but I did not find a simple way to do that.

    Any clues?
    thx in advance,

    Subject: Re: How to get the Phone IP address having the extension number?
    Replied by: Stephan Steiner on 09-10-2008 08:35:44 AM
    AXL cannot give you this information. You can only use AXL to send an SQL query to get from the extension (in the table nummplan) to the phone (in the table device).

    Then, if you're on CCM 4.x, there's the DeviceListX.asp report which gives you the IP address. Refer to the IP Phone Services Developer Guide for more info.

    Starting with CCM5 you need to use AXL Serviceability to get the information (first you send an SQL query via AXL to get from the extension to the phone, then get the phone's IP via AXL serviceability). Refer to the XML developer guide for more info on AXL serviceability.

    Finally, the data dictionary will help you formulate the appropriate SQL query.

    You can find all those douments here: