[cisco-voip] Call forwarding report

[Robert Singleton]

On Thu, 2006-11-02 at 13:48 -0500, Mike Armstrong wrote:
> Does anyone know of away to get a report from CCM listing all phones which 
> have CFwdAll set, with the forward number?

I use an SQL query:

select DNOrPattern,CFADestination from NumPlan where DNOrPattern like 
'2%' and CFADestination like '[0-9]%' order by DNOrPattern

I have some third parties on my CallManager, so the first clause filters
them out. You may not want to limit the return so.

Also, that particular query would not account for CFwdAll to
voicemail....

select DNOrPattern,CFADestination from NumPlan where (CFADestination
like '[0-9]%' or  CFAVoicemailEnabled = 1) order by DNOrPattern

My SQL guru tells me that this one would give the same results with
slightly less server overhead, though admittedly it would be difficult
to measure without thousands of returned records:

select DNOrPattern,CFADestination from NumPlan where (CFADestination is
not null or CFAVoicemailEnabled = 1)

Robert