Re: [cisco-voip] Automatically exporting just the DN and description fields

2017-09-01 Thread Ben Amick
--- From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Pawlowski, Adam Sent: Friday, September 1, 2017 2:22 PM To: cisco-voip@puck.nether.net Subject: Re: [cisco-voip] Automatically exporting just the DN and description fields Lelio, I guess it depends on your approach an

Re: [cisco-voip] Automatically exporting just the DN and description fields

2017-09-01 Thread Pawlowski, Adam
tephen Welsh , cisco-voip > >Subject: Re: [cisco-voip] Automatically exporting just the DN and > Description fields >Message-ID: >Content-Type: text/plain; charset="utf-8" > >Agreed. Amazing. This might actually give me what I need to start thinking >about

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

2017-09-01 Thread Anthony Holloway
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 transla

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

2017-08-31 Thread Lelio Fulgenzi
ilto:treim...@ashevillenc.gov>> Cc: cisco-voip mailto:cisco-voip@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 tkpatte

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

2017-08-31 Thread Ryan Ratliff (rratliff)
n to have a crash course on all that, would you? From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>] On Behalf Of Brian Meade Sent: Wednesday, August 30, 2017 5:28 PM To: Tim Reimers mailto:treim...@ashevillenc.gov>> Cc: cisco-voip mailto:cis

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

2017-08-31 Thread Anthony Holloway
o 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-boun...@puck.nether.net] *On >> Behalf Of *Brian Meade >> *Sent:* Wednesda

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

2017-08-31 Thread Brian Meade
ons, 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? >

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

2017-08-31 Thread Stephen Welsh
o: Tim Reimers mailto:treim...@ashevillenc.gov>> Cc: cisco-voip mailto:cisco-voip@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

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

2017-08-31 Thread Anthony Holloway
er.net] *On Behalf > Of *Brian Meade > *Sent:* Wednesday, August 30, 2017 5:28 PM > *To:* Tim Reimers > *Cc:* cisco-voip > *Subject:* Re: [cisco-voip] Automatically exporting just the DN and > Description fields > > > > Use the AXL API and the following SQL query to autom

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

2017-08-31 Thread Brian Meade
to have a crash course on all > that, would you? > > > > *From:* cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] *On Behalf > Of *Brian Meade > *Sent:* Wednesday, August 30, 2017 5:28 PM > *To:* Tim Reimers > *Cc:* cisco-voip > *Subject:* Re: [cisco-voip] Automatically

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

2017-08-31 Thread Ben Amick
...@puck.nether.net] On Behalf Of Brian Meade Sent: Wednesday, August 30, 2017 5:28 PM To: Tim Reimers Cc: cisco-voip 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

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

2017-08-30 Thread 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 tr

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

2017-08-30 Thread Brian Meade
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 wrote: > Hi all- > > In CUCM 9.12 > I'm trying to figur

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

2017-08-30 Thread Tim Reimers
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 Googl