OID for CUCM to pull Phone numbers

[tnraines]

I am finding references to OID changing here etc. But nothing for the CUCM to pull phone numbers which is what I need.  Anyone have recommend resource to help? This tasking is outside my norm and trying to learn along the way.  Essentially is there a way to pull the phone numbers for each phone by an OID.  I have plenty of information for the IP address etc. however not able to find anything for the actual phone numbers.  Is this even possible? 

[Nithin Eluvathingal]

run sql select  device.name as DeviceMAC, numplan.dnorpattern as Extension, callingsearchspace.name as CSS from device ,numplan , devicenumplanmap , callingsearchspace where devicenumplanmap.fkdevice =device.pkid and devicenumplanmap.fknumplan =nUMPLAN.pkid and numplan.fkcallingsearchspace_sharedlineappear= callingsearchspace.pkid and tkclass =1  order by callingsearchspace.name

Use above SQL Query to  get the DeviceMAC , extension and calling search space associated with the extension.