[cisco-voip] data dictionary/database question

[Erick]

Thank you both!  

On Dec 5, 2012, at 4:18 PM, "Tom Piscitell (tpiscite)" <tpiscite at cisco.com> wrote:

> Paul,
> 
> You would be correct. There is an entry for each DN in that table regardless of if a CFA destination is configured or not. So, to get a list of DNs that have CFA destinations configured you could do something like this:
> 
> admin:run sql select n.dnorpattern, c.cfadestination from callforwarddynamic as c, numplan as n where n.pkid = c.fknumplan and cfadestination != ""
> dnorpattern        cfadestination 
> ===========    ============== 
> 1000                123            
> 
> If you have duplicate DNs in different partitions, you will need to use numplan.fkroutepartition and routepartition.name to make the output more useful.
> 
> HTH,
> 
> Tom Piscitell
> Customer Support Engineer
> Unified Communications Infrastructure
> +1-919-574-0081, 9am-5pm EST (GMT -5)
> 
> On Dec 5, 2012, at 4:51 PM, Paul <asobihoudai at yahoo.com> wrote:
> 
>> looking at this bit
>> http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_1_1/dd_611.pdf
>> 
>> I'd say it's callforwarddynamic table.
>> 
>> From: Erick Wellnitz <ewellnitzvoip at gmail.com>
>> To: cisco-voip <cisco-voip at puck.nether.net> 
>> Sent: Wednesday, December 5, 2012 1:28 PM
>> Subject: [cisco-voip] data dictionary/database question
>> 
>> Does anyone know which table contains the CFA destination in the 6.1 database?
>> 
>> _______________________________________________
>> 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
>