"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 <[email protected]> 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 <[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 >> <https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F>**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 >> >> > _______________________________________________ > cisco-voip mailing list > [email protected] > https://puck.nether.net/mailman/listinfo/cisco-voip >
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
