[cisco-voip] data dictionary/database question

[Tom Piscitell (tpiscite)]

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