How to get registered status of phone

Version 1
    This document was generated from CDN thread

    Created by: Gordon Ross on 14-02-2009 11:09:08 AM
    (Using CUCM 6.1)
    I'm looking at the database schema for "device", and I can't see any fields for saying whether a device is actually registered with CallManager (i.e. plugged in and talking to CUCM)
    Am I looking in the wrong place or is this data not available via AXL or the SQL tables ?
    Thanks,
    GTG

    Subject: RE: How to get registered status of phone
    Replied by: David Staudt on 14-02-2009 04:37:38 PM
    Registration and IP address are dynamic data, not stored in the UCM database, and therefore not accessible using the Administrative AXL interface.  There is a separate SOAP webservice - Serviceability SOAP - from which you can get this type of information.  Info on this interface is in the same document as Admin AXL and the other web service interfaces: http://developer.cisco.com/web/axl/docs
    This wiki how-to includes a sample SelectCmDevice query that might be helpful: http://developer.cisco.com/web/axl/wikidocs?src=/wiki/display/AXL/how-to_telnet

    Subject: RE: How to get registered status of phone
    Replied by: Gordon Ross on 14-02-2009 09:42:06 PM
    Thanks. A quick look at the docs shows some promise. I'll have a better look, and post over in the Serviceability forum if I have any further questions.
    GTG