<p>Does any one know how to get (which table is the info in) a phone's registration status, ie the UCM server its registered to or if its not registered at all?</p>
<p>This doesnt seem to be held in the Device table...</p>
I'm afraid that's not in the database. Depending on the CCM release you need to query the DeviceListX.asp report (details in the ip phone services developer guide that you can get in the appropriate section at developer.cisco.com) or send a SelectCmDevices AXL Serviceability query (with the usual caveat of only 200 devices per query.. so you need AXL to extract all devices, then send one AXL Serviceability request per 200 devices until you have all the devices).
You'll also find the details on developer.cisco.com (http://developer.cisco.com/web/sxml/home)