AXL selectCmDevice call only returns phones with an IP address

Version 1
    This document was generated from CDN thread

    Created by: Muhammad Sabir on 27-01-2010 04:05:25 PM
    I have tried in on multiple version of CUCM 6.x and 7.1.3. Turns out that selectCmDevice only returns those phones that have an IP address. So if we add a new phone in CUCM, unless the phone is plugged in at least once (so that it gets an IP), it does not get returned in the list. Once a phone gets an IP, then we get the phone even if it is not registered (by settting the Status field to 'Any' )
     
    Any advice/comments?
     
    Thanks
     
     

    Subject: RE: AXL selectCmDevice call only returns phones with an IP address
    Replied by: David Staudt on 27-01-2010 09:24:10 PM
    This is by design.  As you note, devices are tracked by the real-time monitoring service when they register, and the record is maintained after they de-register.  Restarting the UCM will clear out this cache completely.
     
    In order to get a complete list of devices regardless of registration state, see the Admin AXL requests like listPhoneByName.  It may be a good idea to look into using executeSQLQuery and craft a targeted SQL statement which returns only the fields you need, in the interest of keeping performance nominal (the 'device' table is the main table here.)