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

[Anthony Holloway]

"You can customize BAT reports for phones and for user device profiles to
meet your particular needs by choosing items from a list of device fields
and line fields. You can also choose how to arrange the fields in the
report. "

"Frequency: Choose from the following options, the frequency of the
transaction:
Once
Monthly
Weekly
Daily
Hourly"

Source:
https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/bat/9_1_1/CUCM_BK_C271A69D_00_cucm-bulk-administration-guide-91.html
On Wed, Aug 30, 2017 at 4:28 PM Brian Meade <bmeade90 at vt.edu> wrote:

> 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
>>
>>
> _______________________________________________
> 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/20170831/988b4a2d/attachment.html>