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

Brian Meade bmeade90 at vt.edu
Wed Aug 30 17:28:02 EDT 2017


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
> <https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F>**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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20170830/fc6c490e/attachment.html>


More information about the cisco-voip mailing list