Using the Management Console › Export Call Details

Export Call Details

You can export the details of a call from the database into a spreadsheet. In some cases, the data available for export is not available in other UC Monitor reports.

No charts are included in the spreadsheet. The raw data provides a deeper insight into call activity and performance on the network and is useful for troubleshooting incidents. The spreadsheet identifies the directory numbers and IP addresses of the endpoints in each Location, which are useful for fine-tuning Location definitions.

You can select the details to include in the spreadsheet, such as the individual endpoint, the Location, media device, or a pair of Locations or media devices.

The following data is not available for export:

• Data from watched calls from the Call Watch feature
• Data from medianet streams

Follow these steps:

1. Click Troubleshooting, Calls, Export in the navigation bar.

   The Export Call Details page opens.

2. Use the following fields to select the data and database columns you want to export.
   • Group and Location/Media Device lists. You can export call data for:
     • a group of managed items.
     • a pair of groups of managed items.
     • a Location, media device, or directory number.
     • a pair of Locations or media devices.
     • a pair that consists of a Location and a media device.
     • a pair of directory numbers.
     • a pair that consists of a directory number and a Location or media device.

     The lists include all available groups, Locations, and media devices.

   • Phone Number. Type the directory number of an endpoint whose call data you want to export. Use the format 8887675443.
     • Enter a direct-dial number. Individual extensions are not supported.
     • Do not use hyphens or periods to separate the area code and number.
     • International numbers (with country code appended) are not supported.
     • You can use an asterisk (*) as a wildcard. For example, *55* matches 55, 155, 552, and 1552. You can also use a pound or number sign (#) as a single-digit wildcard. For example, 45#7 matches 4517, 4527, and 4537.
   • To/From and To options. Use these options to determine the call data to include. The direction is an indication of the origination party and the destination party and thus indicates whether call setup metrics are included. Both directions (legs) of a call are always included.
     • Select To to export only the call data for calls from Call Party 1 to Call Party 2.
     • Select To/From to export call data for all calls related to the two call parties.

     To export data for a Location or media device, select it as Call Party 1, select a direction, and then select Any (Location or Media Device) for Call Party 2.

   • Include abandoned calls. Select the check box to include data from calls that were connected successfully but were abandoned before data was sent.
   • Call Description. This option cannot be disabled.
     • Date and time of a call
     • Called number
     • Call setup metrics
     • MOS
   • Origination Call Detail. Select this option to include information about the origination endpoint, such as the directory number, call server, codec, firmware version, and switch connection type. Availability of this information depends on the type of endpoint.
   • Destination Call Detail. Select this option to include information about the destination endpoint, such as the directory number, call server, codec, firmware version, and switch connection type. Availability of this information depends on the type of endpoint.
3. Click Export.

   The File Download dialog opens.

4. Click Save.

   Note: We do not recommend selecting the option to open the file. Downloading a large amount of data takes longer when you select this option.

5. Enter or browse to a download location and click OK.

   The selected details are exported to a file in .csv format. The process takes a few minutes to complete, depending on the amount of data available in the database and the parameters you selected.