Search for Translation Pattern by Called Party Transform Mask

[tjackson]

I have about four directory numbers that I am pretty sure are being pointed at by translation patterns. How can I figure out which translation pattern is targeting these directory numbers? We are using CUCM 9.1.2.1. Let me know if you need any more information from me in order to help.

[Ayodeji Okanlawon]

You need to look at the pattern of the xlation pattern and then find out what it xlates to..

eg 75XX..will xlate to extensions range 7500-7599..

Is this what you  mean?

Please rate all useful posts

"opportunity is a haughty goddess who waste no time with those who are unprepared"

[tjackson]

Thanks for the response aokanlawon, but I am asking if I can do the opposite of that. I have the directory number and I am trying to figure out what translation pattern translate a number to that directory number. (If that is possible)

[Amine Nouasri]

I believe you can only do it using a SQL query from the CLI. Let me know if you need the query.

Please rate helpful answers!

[Jaime Valencia]

Maybe using the export function from BAT

Sent from Cisco Technical Support iPad App

[tjackson]

@amine:

Unfortunately in my situation I won't have SQL command line access.

@jaime:

How would I use the BAT export function to accomplish this?

[Carlo Poggiarelli · Accepted solution]

Hi.

Use bulk administration -->Import/Export ---> Export

Select translation pattern from the list.

Download the exported file from Bulk Administration (the exported file is a .tar, you can use winrar on Windows to export all files)

Import the csv file that you find in the .tar file on Excel.

There you will find the info you need

HTH

Regards

Carlo

Please rate all helpful posts

"The more you help the more you learn"

[shaijal.allipra]

Hello,

Is there any better way of getting same report in CUCM 11.5, is there any query command to generate from CLI.