@wisit_jan
This is unique request, and there is no easy way to achieve this. The only way I know to get this done is using the steps below.
The CDR report gives you the "origDeviceName" and "destDeviceName". The former is your calling device name, and the latter is your called device name. These device names include desk phones, softphones, VGs. SIP Trunks, H323/MCGP gateways etc. Export all of these device types from CUCM. The exported files include the device pool of all of your device types.
Open the list of exported devices in Excel.
open CDR with comma delimiting in excel.
Now, use "vlookup" in excel to find the device pool of the CDR calling and called devices
Once you find the device pool of CDR calling and called devices, you need to export a list of all your device pools from CUCM. Open the list of exported device pools in excel. The file contains the name of the region associated with each device pool. Use "vlookup" again to find the region name for the device pool of each of your CDR calling and called devices.
If you do everything correctly, you will end up with a file that contains the following columns.
"origDeviceName" "OrigDevicePool" "OrigRegion" "destDeviceName" "DestDevicePool" "DestRegion"
You can then filter by each region under the "OrigRegion" column and count the number of different regions in "DestRegion" column.
