[cisco-voip] Automatically exporting just the DN and Description fields

[Brian Meade]

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 <bamick at humanarc.com> 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:cisco-voip-bounces at puck.nether.net] *On Behalf
> Of *Brian Meade
> *Sent:* Wednesday, August 30, 2017 5:28 PM
> *To:* Tim Reimers <treimers at ashevillenc.gov>
> *Cc:* cisco-voip <cisco-voip at puck.nether.net>
> *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 <treimers at ashevillenc.gov>
> 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
>
> treimers at ashevillenc.gov
>
> (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
> cisco-voip at puck.nether.net
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20170831/288e0f70/attachment.html>