[cisco-voip] CUCM report for lines with forwards

[c3voip]

Thanks so much!

 

Looks like I am being forced into becoming SQL literate.

 

-C

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of cips
Sent: Thursday, October 29, 2009 7:06 AM
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CUCM report for lines with forwards

 

Here is the correct statement including the CFA

 

run sql select numplan.dnorpattern as DN, numplan.cfbdestination as CFB_EXT,
numplan.cfbintdestination as CFB_INT, numplan.cfnadestination as CNA_EXT,
numplan.cfnaintdestination as CNA_INT, callforwarddynamic.cfadestination as
CFA from callforwarddynamic right join numplan on
callforwarddynamic.fknumplan = numplan.pkid

 

Just figured that you should be able to use BAT to do this by creating a new
File Format, but it seems Cisco forgot to put in the CFA Destination field
in the selection window.

 

SQL is the way to go than.

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of cips
Sent: donderdag 29 oktober 2009 11:21
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CUCM report for lines with forwards

 

You could use BAT to export the devices or profiles, use AXL or use the
following sql command from SSH:

 

run sql select dnorpattern, cfbdestination, cfbintdestination,
cfnadestination, cfnaintdestination from numplan order by dnorpattern

 

the statement above does not contain the CFA numbers. Cisco decided to put
these in another table called callforwarddynamic and unfortunately these
tables (dnorpattern & callforwarddynamic) are linked via the numplan table,
so you should create a join to get the correct information.

 

If I find the time today to get the correct query I'll post it here.

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of c3voip
Sent: woensdag 28 oktober 2009 21:23
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] CUCM report for lines with forwards

 

Is there a way to get a report of directory numbers that have forwards setup
to any number other than voicemail in CUCM 7.1.2?

 

Thanks,

-C

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20091029/429804cf/attachment.html>