Here's the full data dictionary- https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm
Once you find a few connections, it's easy to see the structure. I'd also recommend Uplinx for getting some good configuration reports out of CUCM for projects. On Thu, Aug 31, 2017 at 3:06 PM, Ben Amick <[email protected]> wrote: > Do you have a quick reference sheet of the field names? I’d like to do > something similar to this but also including the RNA timer/destination, > user associations, external number mask, and the recording setting for each > line. > > > > Really, I’d like to do a run against all my translations, phones, CTI > route points, etc to just automagically generate all my documentation, but > I have not nearly enough knowledge about hot to use the API or the database > structure in general. You wouldn’t happen to have a crash course on all > that, would you? > > > > *From:* cisco-voip [mailto:[email protected]] *On Behalf > Of *Brian Meade > *Sent:* Wednesday, August 30, 2017 5:28 PM > *To:* Tim Reimers <[email protected]> > *Cc:* cisco-voip <[email protected]> > *Subject:* Re: [cisco-voip] Automatically exporting just the DN and > Description fields > > > > Use the AXL API and the following SQL query to automate this: > > > > select dnorpattern,description from numplan where tkpatternusage='2' > > > > You can put "run sql" before the query to run via SSH to CUCM. > > > > On Wed, Aug 30, 2017 at 4:45 PM, Tim Reimers <[email protected]> > wrote: > > Hi all- > > > > In CUCM 9.12 > > I'm trying to figure out how to export just a few of the fields from the > UCM database. > > What we're after is simply the DN number, and the contents of the > Description field associated with that DN > > > > I've done a Phone export, and the resulting CSV is so huge it's unusable > in Google Sheets. > > I know I can set up an Export as a repeated schedule, but I have two > questions. > > > > - Can I somehow reduce the export query to a limited set of details about > lines only. I don't need phone info particularly. > > - Is there a way to transfer the file off the UCM environment > automatically, so that it's available to another automated process that > will automatically consume the resulting file and use that data? Right > now, I have to manually download the export job file. > > > > Thanks, Tim > > > > -- > > *Quis custodiet ipsos > <http://cp.mcafee.com/d/1jWVIg4xEqdELTohjuod79EVdTdEEILIFzxO9EVdEEILIFzDDSjqabbXPUVVZMSyyUqejhPuZQrCO6GOIl1hdJnor6TbCOrqKMSdKndIKE9zJd7b_nVMsUCMYZRXBQSnxT8ELK6zB5dPG8FHnjlKy_OEuvkzaT0QSyrjdTWWa8VNwttYQsCXCOsVHkiPfxNyhmiTEiTw0e695po0XsG2JCWjGxbVyIBGlEaSrFeG7Q7IyVKQGmGncRAIn8lrxrW0FpKNnwqj-f0QSqehOb9I5-Aq83iTqlblbCqOmdbFEw46VRlSsHquumd47xWRoPB0yq815KAPh1cDVEw3woq8dwwq80XWmz9qsGMd43ILfgEr7fCNxQY>**opus > reticulatum* > > Tim Reimers > > Network Administrator > > I.T Services > > City of Asheville > > [email protected] > > (desk) 828-259-5512 <(828)%20259-5512> > > (cell) 828-552-1585 <(828)%20552-1585> > > Please do NOT use the contact information above for unsolicited sales > contacts. > > All unsolicited sales calls > /dev/null > > > _______________________________________________ > cisco-voip mailing list > [email protected] > https://puck.nether.net/mailman/listinfo/cisco-voip > <http://cp.mcafee.com/d/5fHCMUgdELTohjuod79EVdTdEEILIFzxO9EVdEEILIFzDDSjqabbXPUVVZMSyyUqejhPuZQrCO6GOIl1hdJnor6TbCOrqKMSdKndIKE9zJd7b_nVMsUCMYZRXBQSnxT8ELK6zB5dPG8FHnjlKy_OEuvkzaT0QSCrjdTWWa8VNwttYQsCXCOsVHkiP5CX5u1FfUY3s4RtxxYGjB1SKmBiRiVCIBztFkJkKpH9oKgGT2TQ1iPtyL0QDYu1FIQszAmjobZ8Qg6BKQGmGncRAIqnjh08dPGHIVmQYYIq8f3RGNDa14Qg2bt9Cy2pfPh070MQgr10Qg1TQJ6iQVlwq87puuxgSevdP01KNxc> > > > > Confidentiality Note: This message is intended for use only by the > individual or entity to which it is addressed and may contain information > that is privileged, confidential, and exempt from disclosure under > applicable law. If the reader of this message is not the intended recipient > or the employee or agent responsible for delivering the message to the > intended recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. If > you have received this communication in error, please contact the sender > immediately and destroy the material in its entirety, whether electronic or > hard copy. Thank you
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
