CallManager Who has forwarded their DN to another DN

[richard-matthews]

Hi,

We are currently running Cisco Unified CM 9.1.2.11900-12.

We have had a user call in stating that they are receiving a number of calls asking for other users and she has contacted us asking if we can trace if any user has forwarded their phone to her extension in error.

Hopefully its an easy fix - but is there any way to check which extensions have set up a call forward to a certain DN?

I have asked the user to, when receiving these misplaced calls, ask for who the caller was intended to speak to - but she hasn't been very forthcoming with providing this info. So now I am wondering if there is a quick way in CUCM to report on who may have forwarded their extension?

Thanks for any help

[Aaron Harrison]

Hi

Run this from a putty session to the server; log to text; open as tab seperated text in Excel:

run sql select first 2 d.name, d.description, n.dnorpattern, n.description, n.cfbintdestination, n.cfbdestination, n.cfnaintdestination, n.cfnadestination, n.cfurintdestination,n.cfurdestination from device d join devicenumplanmap dnm on dnm.fkdevice = d.pkid join numplan n on dnm.fknumplan = n.pkid 

Regards

Aaron

[richard-matthews]

Hi,

Thanks for this Aaron - but this only brought up 2 users with calls being forwarded (more call forward when busy, etc.) where I know we should have a lot more users than this?

Is there a way to query just 1 target DN?

Thanks again

[Aaron Harrison · Accepted solution]

run  sql select first 2 d.name, d.description, n.dnorpattern, n.description, cfd.cfadestination, n.cfbintdestination, n.cfbdestination, n.cfnaintdestination, n.cfnadestination, n.cfurintdestination,n.cfurdestination from device d join devicenumplanmap dnm on dnm.fkdevice = d.pkid join numplan n on dnm.fknumplan = n.pkid join callforwarddynamic cfd on cfd.fknumplan = n.pkid

I left 'first 2' in there by accident. Also I've added CFA, the query just returned CFB/CFNA etc.

Easiest way to use would be search in the output text in notepad or excel.

Or you can tag on a where clause, e.g. this to find the settings on extension 06002361:

run  sql select first 2 d.name, d.description, n.dnorpattern, n.description, cfd.cfadestination, n.cfbintdestination, n.cfbdestination, n.cfnaintdestination, n.cfnadestination, n.cfurintdestination,n.cfurdestination from device d join devicenumplanmap dnm on dnm.fkdevice = d.pkid join numplan n on dnm.fknumplan = n.pkid join callforwarddynamic cfd on cfd.fknumplan = n.pkid where n.dnorpattern = '06002361'

Or this to find anything CFAd to 06002361:

run  sql select first 2 d.name, d.description, n.dnorpattern, n.description, cfd.cfadestination, n.cfbintdestination, n.cfbdestination, n.cfnaintdestination, n.cfnadestination, n.cfurintdestination,n.cfurdestination from device d join devicenumplanmap dnm on dnm.fkdevice = d.pkid join numplan n on dnm.fknumplan = n.pkid join callforwarddynamic cfd on cfd.fknumplan = n.pkid where cfd.cfadestination = '06002361'

Checking multiple fields gets tricky, which is why I suggest searching in text if you know know SQL.

Aaron

[Manish Gogna]

Hi Richard,

You can enable detailed callmanager traces on cucm node to which the affected user is registered and collect the trace for the timestamp when call was forwarded to him/her. Using the trace file it can be easily seen who forwarded the call. If you can post the trace for a timestamp then it can be looked into. Else, i am sure there would be an option to check it via some sql query.

HTH

Manish

[richard-matthews]

Aaron you are a star! This has got me exactly what I need and will be very useful in future queries, I am sure!

Thank you so much for your quick responses in helping me resolve this issue!