Configuration and Maintenance Guide for Cisco Unified MeetingPlace Express Release 1.2
Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
Downloads: This chapterpdf (PDF - 283.0KB) The complete bookPDF (PDF - 5.53MB) | Feedback

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Table Of Contents

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Information About Reports and Exported Data

About Report Destinations

About Export Destinations

About Report and Export Options

How To Export Data

Exporting Information to a File

Exporting Information about User Profiles

Exporting Information about User Groups

Exporting Information about Meetings

Exporting Information about Meeting Participants

Exporting Information about When Participants Join and Leave Meetings

Exporting Information about Scheduling Failures

Running a Report about Meeting Cancellations

Running a Report about Billing

Running a Report about Port Utilization

Running a Report about Disk Usage

Displaying the E-Mail Notification Queue

Monitoring Meetings in Session

Exporting Information about Outgoing Calls

Running a Report about the Audio Mixer and Video Mixer


Running Reports and Exporting Data from Cisco Unified MeetingPlace Express


Revised: October 18, 2006, OL-11374-01

Two areas of the Administration Center provide useful data that you can analyze and save:

Reports

Maintenance > Export Information

The output produced in these two areas differs in format. The Reports area provides information that is formatted in tables, either in HTML or plain text. The Export Information area provides data in comma-delimited text files, which you may sort and format using any generally available third-party report-generation application.

The report and export data enable you to monitor resource usage, monitor end-user activity, gather billing information, and watch for toll fraud. This data can help you answer questions such as:

How frequently are people in my company using Cisco Unified MeetingPlace Express? How many meetings did an end user schedule or attend?

Are there enough licenses, voice recording space, and other system resources to support the number of calls being made by end users?

Is there an unusual number of calls on one port?

Topics in this section include:

Information About Reports and Exported Data

How To Export Data

The content in this chapter applies only to the Cisco Unified MeetingPlace Express system and not to the Cisco Unified MeetingPlace Express VT system.

Information About Reports and Exported Data

Topics in this section include:

About Report Destinations

About Export Destinations

About Report and Export Options

About Report Destinations

When you run reports in Cisco Unified MeetingPlace Express, you can choose the destination of the generated report output. Table 10-1 describes the destination options.

Table 10-1 Report Destination Options 

Destination
Description

Screen

The report output appears on the screen. From the screen output, you have the option to print the information or export it to a file1 .

Note Screen output is limited to 500 results. If the report output exceeds 500 results, then the report is sent to a file instead of appearing on the screen.

File

The report output is placed in a file, which you choose to either open or save.

For plain text report output, use a text-editing program such as Notepad or Wordpad to view or modify the file.

For HTML output, use a web browser to view the file.

Printer

The report output appears on the screen and is sent to a printer. From the screen output, you have the option to print the information again.

Note Printer output is limited to 500 results. If the report output exceeds 500 results, then the report is sent to a file instead of being sent to a printer and appearing on the screen.

1 See the "Exporting Information to a File" section.


Related Topics

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

About Export Destinations

When you export data from Cisco Unified MeetingPlace Express, you can choose the destination of the exported information. Table 10-2 describes the destination options.

Table 10-2 Export Destination Options 

Destination
Description

Screen

The exported data appears on the screen. From the screen output, you have the option to print the information or export it to a file.

Note Screen output is limited to 500 results. If the exported data exceeds 500 results, then you must choose the File export destination to view the whole report. Otherwise, only the first 500 results appear in the screen output.

File

The exported data is placed in a text file, which you can either open or save.

Note We recommend that you use the .csv file extension to save the file using the comma-separated values (CSV) file format. Open the saved file with a spreadsheet program such as Excel.

Printer

The exported data appears on the screen and the Print dialog box is displayed, giving you the option to print the data. You can also save the data by clicking Export to File.

Note Printer output is limited to 500 results. If the exported data exceeds 500 results, then you must choose the File export destination to print the whole report. Otherwise, only the first 500 results appear in the printer output.


Related Topics

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

About Report and Export Options

The system provides many report and export options for displaying information in the database about your user base and system usage. The options you use may depend on whether you are gathering information about users, calls, or meetings. Table 10-3 shows which report and export options provide information about users, calls, meetings, or a combination of the three.

Table 10-3 Which Report and Export Options Provide Information About Users, Calls, or Meetings 

Report or Export Option
Provides Information About...
Users
Calls
Meetings

Exporting Information about User Profiles

Yes

Exporting Information about User Groups

Yes

Exporting Information about Meetings

Yes

Exporting Information about Meeting Participants

Yes

Yes

Running a Report about Billing

Yes

Yes

Yes

Exporting Information about When Participants Join and Leave Meetings

Yes

Yes

Exporting Information about Outgoing Calls

Yes

Yes

Yes

Exporting Information about Scheduling Failures

Yes

Yes

Running a Report about Meeting Cancellations

Yes

Yes

Running a Report about Port Utilization

Yes

Yes

Running a Report about Disk Usage

Yes

Yes

Displaying the E-Mail Notification Queue

Yes

Yes

Monitoring Meetings in Session

Yes

Running a Report about the Audio Mixer and Video Mixer

Yes


How To Export Data

Topics in this section include:

Exporting Information to a File

Exporting Information about User Profiles

Exporting Information about User Groups

Exporting Information about Meetings

Exporting Information about Meeting Participants

Exporting Information about When Participants Join and Leave Meetings

Exporting Information about Scheduling Failures

Running a Report about Meeting Cancellations

Running a Report about Billing

Running a Report about Port Utilization

Running a Report about Disk Usage

Displaying the E-Mail Notification Queue

Monitoring Meetings in Session

Exporting Information about Outgoing Calls

Running a Report about the Audio Mixer and Video Mixer

Exporting Information to a File

Many Cisco Unified MeetingPlace Express Administration Center pages have an Export to File button, which enables you to either view the information on that page or to save the information on that page in a file. The page may contain configuration information, profile information, or the data generated by running a report.

The following procedure begins when you click Export to File on one of the Administration Center pages.

Procedure


Step 1 Click Export to File.

The File Download dialog box opens. You can either open or save the file.

Step 2 To open and view the file, follow these steps:

a. Click Open.

b. If you are prompted with an Open With dialog box, do one of the following:

For reports, which are in HTML format, choose a web browser.

Otherwise, choose a text editor, such as Notepad or WordPad.

Step 3 To save the file, follow these steps:

a. Click Save.

b. In the Save As dialog box, use the Save in drop-down menu to navigate to the directory where you want to save the exported file. Click Save.

c. If the Download Complete dialog box appears, click Close.


Related Topics

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about User Profiles

This topic describes how to export user profile information from the Cisco Unified MeetingPlace Express database.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Profile Information.

Step 4 On the Profile Information page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output. If you plan to use the exported output to create an import file, then select Yes.

c. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.

If you are exporting data to create an import file, then export the data to a file with a .csv extension.


Note For help interpreting the exported data, see the "Output Fields of the Profile Information Page—Used for Importing User Profiles" section on page C-121.



Related Topics

Information About User Profiles, page 8-3

About Export Destinations

About This Page: Profile Information, page C-120

Exporting Information about User Groups

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about User Groups

This topic describes how to export user group information from the Cisco Unified MeetingPlace Express database.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Group Information.

Step 4 On the Group Information page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output. If you plan to use the exported output to create an import file, then select Yes.

c. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.

If you are exporting data to create an import file, then export the data to a file with a .csv extension.


Note For help interpreting the exported data, see the "Output Fields of the Group Information Page—Used for Importing User Groups" section on page C-71.



Related Topics

Information About User Groups, page 8-1

About Export Destinations

About This Page: Group Information, page C-70

Exporting Information about User Profiles

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about Meetings

This topic describes how to export meeting information from the Cisco Unified MeetingPlace Express database for all meetings during a specified range of dates, including:

Continuous meetings that were scheduled or initiated before or during the specified date range.

Instances of recurring meetings that occur during the specified date range.


Note If you export meeting information to create a meeting import file, then save the exported file with a .csv extension, which indicates the comma-separated values (CSV) file format. See the "Setting Up an Import File" section.


Restrictions

If you export meeting information to create a meeting import file, then make sure that you specify a range of dates that includes all occurrences of recurring meetings that you want to be able to import. The End date is optional. Also, see the "Restrictions for Importing Meetings" section.

You cannot export meetings for a specific user, but the CSV file can be edited to include only the meetings that are owned by a specific user.

If the meeting owner of an exported meeting does not have an existing user profile, then the SchedulerUid field is left blank in the meeting export file.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Meeting Information.

Step 4 On the Meeting Information page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output.

c. Choose whether to include meetings that have already ended in the output. If you plan to use the exported output to create an import file, then select Yes.

d. Specify the range of dates for which you want to export meeting details.

e. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.

If you are exporting data to create an import file, then export the data to a file with a .csv extension.


Note For help interpreting the exported data, see the "Output Fields of the Meeting Information Page—Used for Importing Meetings" section on page C-103.



Related Topics

Importing Meetings

About Export Destinations

About This Page: Meeting Information, page C-102

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about Meeting Participants

This topic describes how to export information about meeting participants who attended meetings during a specified range of dates.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Meeting Participant Information.

Step 4 On the Meeting Participants Report page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output.

c. Specify the range of dates for which you want to export information about meeting participants.

d. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the exported data, see the "Output Fields of the Meeting Participants Report Page" section on page C-114.



Related Topics

About Export Destinations

About This Page: Meeting Participants Report, page C-113

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about When Participants Join and Leave Meetings

This topic describes how to export information about meeting participants who joined or left a Cisco Unified MeetingPlace Express meeting during a specified range of dates.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Meeting Participant Join Leave Information.

Step 4 On the Meeting Participant Join Leave Information page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output.

c. Specify the range of dates for which you want to export information about when meeting participants join and leave meetings.

d. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the exported data, see the "Output Fields of the Meeting Participant Join Leave Information Page" section on page C-112.



Related Topics

About Export Destinations

About This Page: Meeting Participant Join Leave Information, page C-111

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about Scheduling Failures

This topic describes how to export information from the Cisco Unified MeetingPlace Express database about failed attempts to schedule meetings during a specified range of dates.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Scheduling Failures Information.

Step 4 In the Scheduling Failures Information page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output.

c. Specify the range of dates for which you want to export information about scheduling failures.

d. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the exported data, see the "Output Fields of the Scheduling Failures Information Page" section on page C-128.



Related Topics

About Export Destinations

About This Page: Scheduling Failures Information, page C-127

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Running a Report about Meeting Cancellations

This topic describes how to run a report about meeting cancellations, which provides information about each meeting that was cancelled during a specified range of dates.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click Meeting Cancellation Report.

Step 4 Configure the fields, which are described in the "Fields on the Meeting Cancellation Report Page" section on page C-95.

Step 5 Click Create Report.

Step 6 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the report output, see the "Output Fields of the Meeting Cancellation Report Page" section on page C-96.



Related Topics

About Report Destinations

About This Page: Meeting Cancellation Report, page C-95

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Running a Report about Billing

This topic describes how to run a report about billing, which provides information about all billing codes both by individual end user and by user group during a specified range of dates. You can run this report monthly to provide a bill-back report for departments in your company.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click Billing Report.

Step 4 Configure the fields, which are described in the "Fields on the Billing Report Page" section on page C-30.

Step 5 Click Create Report.

Step 6 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the report output, see the "Output Fields of the Billing Report Page" section on page C-31.



Related Topics

About Report Destinations

About This Page: Billing Report, page C-30

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Running a Report about Port Utilization

This topic describes how to run a report about port utilization, which compares the number of ports scheduled to the number of ports actually used during a specified period of time. You can use this report to determine the peak and off-peak times of your system and compare resource usage with available capacity.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click Port Utilization Report.

Step 4 Configure the fields on the Port Utilization Report page.

Step 5 Click Create Report.

Step 6 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the report output, see the "Output of the Port Utilization Report Page" section on page C-119.



Related Topics

Fields on the Port Utilization Report Page, page C-118

About Report Destinations

About This Page: Billing Report, page C-30

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Running a Report about Disk Usage

This topic describes how to run a report about disk usage, which tracks available space in current disks and indicates problems when the recording space is filled.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click Disk Usage Report.

Step 4 Configure the fields, which are described in the "Fields on the Disk Usage Report Page" section on page C-45.

Step 5 Click Create Report.

Step 6 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the report output, see the "Output Fields of the Disk Usage Report Page" section on page C-46.



Related Topics

About Report Destinations

About This Page: Disk Usage Report, page C-44

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Displaying the E-Mail Notification Queue

This topic describes how to display any e-mail notifications that are waiting to be sent to end users. If necessary, you can delete e-mail notifications in the queue.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click E-Mail Notification Queue Status Report.

Any e-mail notifications that are waiting to be sent are displayed.

Step 4 (Optional) On the E-Mail Notification Queue Status Report page, you can do the following:

To delete one or more e-mail notifications in the queue, select those you want to delete, and click Delete Notification(s).

To delete all e-mail notifications in the queue, click Delete All.

To export the e-mail notifications, click Export to File.


Related Topics

About This Page: E-Mail Notification Queue Status Report, page C-61

Deleting E-Mail Notifications in the Queue

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information to a File

Monitoring Meetings in Session

This topic describes how to display information for meetings that are currently in session.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click In-Session Monitoring.

The In-Session Monitoring page lists information for all meetings that are currently in session. Click a meeting ID to see the participant list for that meeting.


Related Topics

About This Page: In-Session Monitoring, page C-83

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Exporting Information about Outgoing Calls

This topic describes how to export information about outgoing calls that were made from Cisco Unified MeetingPlace Express during a specified range of dates.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Maintenance.

b. Click Export Information.

c. Click Outgoing Calls Information.

Step 4 On the Outgoing Calls Information page:

a. Choose the output destination from the Destination drop-down list.

b. Choose whether to include field header names in the output.

c. Specify the range of dates for which you want to export information about outgoing calls.

d. Click Create Report.

Step 5 The system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.

Depending on the destination you chose, you can view, print, or export the data to a file.


Note For help interpreting the exported data, see the "Output Fields of the Outgoing Calls Information Page" section on page C-116.



Related Topics

About Export Destinations

About This Page: Outgoing Calls Information, page C-115

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express

Running a Report about the Audio Mixer and Video Mixer

This topic describes how to run a report that is useful for troubleshooting the software audio and video mixers in Cisco Unified MeetingPlace Express.

Restrictions

The fields that display only video information do not appear in report output if no video calls are received.

Procedure


Step 1 Log in to Cisco Unified MeetingPlace Express.

Step 2 At the top of the page, click Administration.

Step 3 On the left side of the page:

a. Click Reports.

b. Click Media Statistics Reports.

Step 4 Click the radio button for one of the following report options:

Conference Statistics Report—Displays two sets of mixer data:

Global statistics—Contains historical data that applies to all voice meetings and video conferences handled by the mixers since initialization.

Conference statistics—Contains information about voice meetings and video conferences that are currently active.

Channel Statistics Report—Displays mixer statistics for each voice call and video connection that is currently active.

Channel Status Report—Displays mixer status information about each voice call and video connection that is currently active.

Step 5 Click Create Report.


Note For help interpreting the report output, see the following sections:

Output Fields of the Media Statistics Reports Page: Conference Statistics Report, page C-89

Output Fields of the Media Statistics Reports Page: Channel Statistics Report, page C-91

Output Fields of the Media Statistics Reports Page: Channel Status Report, page C-93



Related Topics

Configuring Audio Parameters

Information About the Audio Mixer

About This Page: Media Statistics Reports, page C-88

Running Reports and Exporting Data from Cisco Unified MeetingPlace Express