"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. "<br><br>"Frequency: Choose from the following options, the frequency of the transaction:<br> Once<br> Monthly<br> Weekly<br> Daily<br> Hourly"<br><br>Source: <a href="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">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</a><br><div class="gmail_quote"><div dir="ltr">On Wed, Aug 30, 2017 at 4:28 PM Brian Meade <<a href="mailto:bmeade90@vt.edu">bmeade90@vt.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Use the AXL API and the following SQL query to automate this:<div><br><div>select dnorpattern,description from numplan where tkpatternusage='2'</div></div><div><br></div><div>You can put "run sql" before the query to run via SSH to CUCM.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 30, 2017 at 4:45 PM, Tim Reimers <span dir="ltr"><<a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi all-<div><br></div><div>In CUCM 9.12</div><div>I'm trying to figure out how to export just a few of the fields from the UCM database.</div><div>What we're after is simply the DN number, and the contents of the Description field associated with that DN</div><div><br></div><div>I've done a Phone export, and the resulting CSV is so huge it's unusable in Google Sheets.</div><div>I know I can set up an Export as a repeated schedule, but I have two questions.</div><div><br></div><div>- Can I somehow reduce the export query to a limited set of details about lines only. I don't need phone info particularly.</div><div>- 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.</div><div><br></div><div>Thanks, Tim<br clear="all"><div><br></div>-- <br><div class="m_1812275417473764355m_-4362294619693752590gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><p><b><i><span lang="EN" style="color:blue;font-family:"Arial",sans-serif;font-size:10pt"><a href="https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F" target="_blank"><span style="color:blue">Quis custodiet
ipsos </span></a></span></i></b><b><i><span style="color:blue;font-family:"Arial",sans-serif;font-size:10pt">opus
reticulatum</span></i></b><b><i><span style="color:blue;font-family:"Arial",sans-serif;font-size:10pt"></span></i></b></p>
<p>Tim Reimers</p>
<p>Network Administrator</p>
<p>I.T Services</p>
<p>City of Asheville </p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a></p>
<p>(desk) <a href="tel:(828)%20259-5512" value="+18282595512" target="_blank">828-259-5512</a></p>
<p>(cell) <a href="tel:(828)%20552-1585" value="+18285521585" target="_blank">828-552-1585</a></p>
<p>Please do NOT use the contact information above for
unsolicited sales contacts. </p>
<p>All unsolicited sales calls > /dev/null</p></div></div></div></div>
</div></div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div>