Table Of Contents
Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
About Report Destinations
About Export Destinations
Exporting Information to a File
About User Information in Reports and Exported Data
Exporting Information about User Profiles
Exporting Information about User Groups
About Meeting Information in Reports and Exported Data
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
About Call Information in Reports and Exported Data
Exporting Information about Outgoing Calls
Running a Report about the Audio Mixer
Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
Revised: May 1, 2006, OL-6664-04
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?
See the following topics:
•About Report Destinations
•About Export Destinations
•Exporting Information to a File
•About User Information in Reports and Exported Data
•About Meeting Information in Reports and Exported Data
•About Call Information in Reports and Exported Data
About Report Destinations
When you run reports in Cisco Unified MeetingPlace Express, you can choose the destination of the generated report output. Table 8-1 describes the destination options.
Table 8-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.
|
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 8-2 describes the destination options.
Table 8-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
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
About User Information in Reports and Exported Data
The following sections describe how to gather information about your Cisco Unified MeetingPlace Express users:
•Exporting Information about User Profiles
•Exporting Information about User Groups
•Exporting Information about Meeting Participants
•Running a Report about Billing
•Exporting Information about When Participants Join and Leave Meetings
•Exporting Information about Outgoing Calls
•Exporting Information about Scheduling Failures
•Running a Report about Meeting Cancellations
•Running a Report about Disk Usage
•Displaying the E-Mail Notification Queue
•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. For descriptions of each option, see the "About Export Destinations" section.
b. Choose whether to include field header names in the output.
c. Click Create Report.
Step 5 The Cisco Unified MeetingPlace Express 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. For information about the output fields, see the "About This Page: Profile Information" section.
Related Topics
•About User Profiles
•About Export Destinations
•About This Page: Profile Information
•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. For descriptions of each option, see the "About Export Destinations" section.
b. Choose whether to include field header names in the output.
c. Click Create Report.
Step 5 The Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 6 Depending on the destination you chose, you can view, print, or export the data to a file. For information about the output fields, see the "About This Page: Group Information" section.
Related Topics
•About User Groups
•About Export Destinations
•About This Page: Group Information
•Exporting Information about User Profiles
•Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
About Meeting Information in Reports and Exported Data
The following sections describe how to gather information about meetings held on your Cisco Unified MeetingPlace Express system:
•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 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. In Releases 1.1.2 and later releases, the End date is optional. Also, see the "Restrictions for Imported 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. For descriptions of each option, see the "About Export Destinations" section.
b. Choose whether to include field header names in the output.
c. Specify the range of dates for which you want to export meeting details.
d. Click Create Report.
Step 5 The Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 6 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.
For information about the output fields, see the "About This Page: Meeting Information" section.
Related Topics
•Importing Meetings
•About This Page: Meeting Information
•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. For descriptions of each option, see the "About Export Destinations" section.
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 Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 6 Depending on the destination you chose, you can view, print, or export the data to a file. For information about the output fields, see the "About This Page: Meeting Participants Report" section.
Related Topics
•About Export Destinations
•About This Page: Meeting Participants Report
•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. For descriptions of each option, see the "About Export Destinations" section.
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 Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 6 Depending on the destination you chose, you can view, print, or export the data to a file. For information about the output fields, see the "About This Page: Meeting Participant Join Leave Information" section.
Related Topics
•About Export Destinations
•About This Page: Meeting Participant Join Leave Information
•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. For descriptions of each option, see the "About Export Destinations" section.
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 Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 6 Depending on the destination you chose, you can view, print, or export the data to a file. For information about the output fields, see the "About This Page: Scheduling Failures Information" section.
Related Topics
•About Export Destinations
•About This Page: Scheduling Failures Information
•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 Modify the Meeting Cancellation Report page, which is described in the "About This Page: Meeting Cancellation Report" section.
Step 5 Click Create Report.
Step 6 The Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 7 Depending on the destination you chose, you can view, print, or export the data to a file.
For information about the output fields, see the "About This Page: Meeting Cancellation Report" section.
Related Topics
•About Report Destinations
•About This Page: Meeting Cancellation Report
•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 Modify the Billing Report page, which is described in the "About This Page: Billing Report" section.
Step 5 Click Create Report.
Step 6 The Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 7 Depending on the destination you chose, you can view, print, or export the data to a file.
For information about the output fields, see the "About This Page: Billing Report" section.
Related Topics
•About Report Destinations
•About This Page: Billing Report
•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 Cisco Unified MeetingPlace Express 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 Modify the Port Utilization Report page, which is described in the "About This Page: Port Utilization Report" section.
Step 5 Click Create Report.
Step 6 The Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 7 Depending on the destination you chose, you can view, print, or export the data to a file.
For information about the output fields, see the "About This Page: Billing Report" section.
Related Topics
•About Report Destinations
•About This Page: Billing Report
•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 Modify the Disk Usage Report page, which is described in the "About This Page: Disk Usage Report" section.
Step 5 Click Create Report.
Step 6 The Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 7 Depending on the destination you chose, you can view, print, or export the data to a file. For information about the output fields, see the "About This Page: Disk Usage Report" section.
Related Topics
•About Report Destinations
•About This Page: Disk Usage Report
•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. See the "Exporting Information to a File" section.
Related Topics
•About This Page: E-Mail Notification Queue Status Report
•Deleting E-Mail Notifications in the Queue, page 12-5
•Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
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
•Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
About Call Information in Reports and Exported Data
The following sections describe how to gather information about calls on your Cisco Unified MeetingPlace Express system:
•Exporting Information about Outgoing Calls
•Running a Report about the Audio Mixer
•Running a Report about Billing
•Running a Report about Port Utilization
•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.
Note In Release 1.1.1 and earlier releases, the Outgoing Calls Information page is instead called the Meeting Outdial Information page.
Step 4 On the Outgoing Calls Information page:
a. Choose the output destination from the Destination drop-down list. For descriptions of each option, see the "About Export Destinations" section.
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 Cisco Unified MeetingPlace Express system displays a message that this operation might take a long time and asks if you want to proceed. Click OK.
Step 6 Depending on the destination you chose, you can view, print, or export the data to a file. For information about the output fields, see the "About This Page: Outgoing Calls Information" section.
Related Topics
•About Export Destinations
•About This Page: Outgoing Calls Information
•Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
Running a Report about the Audio Mixer
This topic describes how to run a report that is useful for troubleshooting the software audio mixer in Cisco Unified MeetingPlace Express.
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 Audio Mixer Statistics Reports.
Step 4 Click the radio button for one of the following report options:
•Conference Statistics Report—Displays two sets of audio mixer data:
–Global statistics—Contains historical data that applies to all voice meetings and all calls handled by the audio mixer since initialization.
–Conference statistics—Contains information about voice meetings that are currently active.
•Channel Statistics Report—Displays audio mixer statistics for each call that is currently active.
•Channel Status Report—Displays audio mixer status information about each call that is currently active.
Step 5 Click Create Report.
For information about the output fields, see the "About This Page: Audio Mixer Statistics Reports" section.
Related Topics
•Configuring Audio Parameters
•About the Audio Mixer
•About This Page: Audio Mixer Statistics Reports
•Running Reports and Exporting Data from Cisco Unified MeetingPlace Express
Feedback
