Configuration and Maintenance Guide for MeetingPlace 7.1 - Running Reports and Exporting Data [Cisco Unified MeetingPlace]

Table Of Contents

Running Reports and Exporting Data from Cisco Unified MeetingPlace

Reports and Exported Data

How To Run Reports and Export Data

Exporting User Groups

Exporting User Profiles

Exporting Video Terminal Profiles

Exporting Remote Servers

Exporting Meeting Categories

Exporting Meetings

Exporting Information about Continuous Meetings

Exporting Information about Meeting Participants

Exporting Information about When Participants Join and Leave Meetings

Exporting Information about Scheduling

Running a Report about Meeting Cancellations

Running a Report for Billing

Running Capacity Management Reports

Running a Report about Meetings

Exporting Information about Dial-Out Calls

Exporting the System Configuration

Viewing the E-Mail Notification Queue

Running Reports and Exporting Data from Cisco Unified MeetingPlace

Release 7.1

Revised: April 3, 2011 8:31 pm

Use reports for capacity management and to track resource usage. You can also export database tables in a raw format for analysis or reporting in other applications.

•Reports and Exported Data

•How To Run Reports and Export Data

Reports and Exported Data

Caution Cisco recommends that you do not run reports or backups during peak hours of use, such as on the hour. Doing so may cause the system to fail.

Report and export data enables you to monitor resource usage, monitor end-user activity, gather billing information, and watch for toll fraud. For example, you can use the data to determine whether the system has enough licenses and appropriate port and capacity configurations to support the number of calls being made by end users. Two areas of the Administration Center provide useful data that you can analyze and save:

•Reports

•Maintenance > Export Data

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.

Note Some export options are provided only in XML format. These export options are provided only to save a subset of configurations that you can later import. Do not modify the exported files before importing.

You choose the destination of the generated report output. Table 1 describes the destination options.

Table 1 Report and Export Destination Options

Destination

Description for Reports

Description for Exporting

Screen

The report output appears on the screen. From the screen output, you have the option to print the information.

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

The exported data appears on the screen. From the screen output, you have the option to print the information.

Note Screen output is limited to 500 results. If the exported data exceeds 500 results, 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 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.

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 Microsoft Excel.

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, the report is sent to a file instead of being sent to a printer and appearing on the screen.

The exported data appears on the screen and the Print dialog box is displayed, giving you the option to print the data.

Note Printer output is limited to 500 results. If the exported data exceeds 500 results, 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

•How To Run Reports and Export Data

How To Run Reports and Export Data

•Exporting User Groups

•Exporting User Profiles

•Exporting Video Terminal Profiles

•Exporting Remote Servers

•Exporting Meeting Categories

•Exporting Meetings

•Exporting Information about Continuous Meetings

•Exporting Information about Meeting Participants

•Exporting Information about When Participants Join and Leave Meetings

•Exporting Information about Scheduling

•Running a Report about Meeting Cancellations

•Running a Report for Billing

•Running Capacity Management Reports

•Running a Report about Meetings

•Exporting Information about Dial-Out Calls

•Exporting the System Configuration

•Viewing the E-Mail Notification Queue

Exporting User Groups

Restrictions

Flex fields are not included in exported output.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Export User Groups.

Step 3 On the Group Information page:

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

If you plan to use the exported output to create an import file, then select File.

For restrictions and recommendations for each option, see Table 1.

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. Select Create Report.

Step 4 Select OK to proceed.

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

Related Topics

Topics in the Importing Data into Cisco Unified MeetingPlace module:

•Examples of Import Files

•Adding or Editing User Groups by Import

•Deleting User Groups by Import

What To Do Next

To interpret the exported data, see "Import and Export Data Specifications for User Profiles" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting User Profiles

Restrictions

•Flex Fields are not included in exported output.

•The following fields are left blank for Directory Service users, who are authenticated externally:

–User password (EncryptedUserPWD)

–Profile password (EncryptedProfilePWD)

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Export User Profiles.

Step 3 On the Profile Information page:

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

If you plan to use the exported output to create an import file, then select File.

For restrictions and recommendations for each option, see Table 1.

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

If you plan to use the exported output to create an import file, select Yes.

c. Select Create Report.

Step 4 Select OK to proceed.

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

Related Topics

•Configuring Cisco Unified MeetingPlace Directory Service module

Topics in the Importing Data into Cisco Unified MeetingPlace module:

•Examples of Import Files

•Adding or Editing User Profiles by Import

•Deleting User Profiles by Import

What To Do Next

To interpret the exported data, see "Import and Export Data Specifications for User Profiles" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting Video Terminal Profiles

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Export Video Terminal Profiles.

Step 3 On the Profile Information page:

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

If you plan to use the exported output to create an import file, then select File.

For restrictions and recommendations for each option, see Table 1.

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

If you plan to use the exported output to create an import file, select Yes.

c. Select Create Report.

Step 4 Select OK to proceed.

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

Related Topics

Topics in the Importing Data into Cisco Unified MeetingPlace module:

•Examples of Import Files

•Adding or Editing Video Terminal Profiles by Import

•Deleting Video Terminal Profiles by Import

What To Do Next

To interpret the exported data, see "Import and Export Data Specifications for Video Terminal Profiles" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting Remote Servers

An exported remote servers file can be used as a snapshot or backup copy of configured remote servers that you can later import to your system.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Export Remote Servers.

Step 3 Select Create Report.

Step 4 Save the file.

Related Topics

•Importing Remote Servers in the Importing Data into Cisco Unified MeetingPlace module

Exporting Meeting Categories

An exported meeting categories file can be used as a snapshot or backup copy of configured meeting categories that you can later import to your system.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Export Meeting Categories.

Step 3 Select Create Report.

Step 4 Save the file.

Related Topics

•Importing Meeting Categories in the Importing Data into Cisco Unified MeetingPlace module

•Configuring Meeting Categories in the Configuring Meetings for Cisco Unified MeetingPlace module

Exporting Meetings

Use this procedure to export meetings from the Cisco Unified MeetingPlace database for 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.

Restrictions

•If you export meetings to create a meeting import file, make sure that you specify a range of dates that includes all occurrences of recurring meetings that you want to import. The End date is optional. Also, see "Requirements for Importing Data" in the Importing Data into Cisco Unified MeetingPlace module.

•You cannot export meetings for a specific user, but the export 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 the Administration Center.

Step 2 Select Maintenance > Export Data > Export Meetings.

Step 3 Specify the output options, as described in Table 2.

Table 2 Field Reference: Export Meetings Page

Field

Description

Destination

If you plan to use the exported output to create an import file, then select File.

For restrictions and recommendations for each option, see Table 1.

Include field header names

Select Yes if you want to be able to use the exported file to import data.

Include ended meetings

Whether to include meetings that have already ended in the exported file.

Default: No

Start date

Default: yesterday (mm/dd/yyyy)

End date

If left blank, the exported output includes all future meetings.

Default: today (mm/dd/yyyy)

Step 4 Select Create Report.

Step 5 Select OK to proceed.

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

Related Topics

•Scheduling Meetings by Import in the Importing Data into Cisco Unified MeetingPlace module

•Canceling Meetings by Import in the Importing Data into Cisco Unified MeetingPlace module

•Setting Up an Import File in the Importing Data into Cisco Unified MeetingPlace module

What To Do Next

To interpret the exported data, see "Import and Export Data Specifications for Meetings" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting Information about Continuous Meetings

Use this procedure to export raw data about continuous meetings.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Continuous Meetings Information.

Step 3 Specify the output options, as described in Table 3.

Table 3 Field Reference: Continuous Meetings Information Page

Field

Description

Destination

Output destination. For restrictions and recommendations for each option, see Table 1.

Include ended meetings

Whether to include continuous meetings that were canceled.

When set to Yes, you can use the Start date field to include only meetings that were canceled after a specific date.

Default: No

Start date

Use this field to exclude continuous meetings that were canceled before a specific date.

This field is dimmed when Include ended meetings is set to No.

Default: yesterday (mm/dd/yyyy)

End date

Use this field to exclude continuous meetings that start after a specific date.

Default: today (mm/dd/yyyy)

Step 4 Select Create Report.

Step 5 Select OK.

What To Do Next

To interpret the exported data, see "Export Data Specifications—Continuous Meetings Information" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting Information about Meeting Participants

Use this procedure to export information about meeting participants who attended meetings during a specified range of dates.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Meeting Participant Information.

Step 3 On the Meeting Participants Report page:

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

For restrictions and recommendations for each option, see Table 1.

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. Select Create Report.

Step 4 Select OK.

What To Do Next

To interpret the exported data, see "Export Data Specifications—Meeting Participant Information" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting Information about When Participants Join and Leave Meetings

Use this procedure to export information about meeting participants who joined or left a Cisco Unified MeetingPlace meeting during a specified range of dates.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Meeting Participant Join Leave Information.

Step 3 On the Meeting Participant Join Leave Information page:

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

For restrictions and recommendations for each option, see Table 1.

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. Select Create Report.

Step 4 Select OK.

What To Do Next

To interpret the exported data, see "Export Data Specifications—Meeting Participant Join Leave Information" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting Information about Scheduling

Use this procedure to export information from the Cisco Unified MeetingPlace database about scheduling activity during a specified range of dates.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data.

Step 3 Select one of the following options:

•Scheduling Failures Information—Failed attempts to schedule meetings

•Scheduling Statistics Information—Which user interfaces were used to schedule meetings

•Scheduling Activity By User Information—Which users schedule meetings

Step 4 Configure the fields:

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

For restrictions and recommendations for each option, see Table 1.

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. Select Create Report.

Step 5 Select OK.

What To Do Next

To interpret the exported data, see the following sections in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module:

•Export Data Specifications—Scheduling Failures Information

•Export Data Specifications—Scheduling Statistics Information

•Export Data Specifications—Scheduling Activity By User Information

Running a Report about Meeting Cancellations

Use this procedure to run a report that provides information about each meeting that was cancelled during a specified range of dates.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Reports > Meeting Cancellation Report.

Step 3 Configure the fields on the Meeting Cancellation Report Page.

Step 4 Select Create Report.

Step 5 Select OK.

What To Do Next

To interpret the exported data, see "Field Reference: Meeting Cancellation Report Page" in the Administration Center Page References for Cisco Unified MeetingPlace module.

Running a Report for Billing

Use this procedure to run a billing report for meetings held in a specified date range. You can run this report regularly to provide a bill-back report for departments in your company.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Reports > Billing Report.

Step 3 Configure the fields on the Billing Report Page.

Step 4 Select Create Report.

Step 5 Select OK.

What To Do Next

To interpret the exported data, see "Field Reference and Output Field Reference: Billing Report Page" in the Administration Center Page References for Cisco Unified MeetingPlace module.

Running Capacity Management Reports

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Reports.

Step 3 Select one of the following report options:

•Port Utilization Report—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 compare resource usage with available capacity during peak and off-peak periods.

•Unattended Ports Report—Shows what percentage of scheduled ports were not used during a specified time range. The output can help you determine the appropriate settings for your overbook and floater ports. This report option was introduced in Release 7.0.2.

•Monthly Usage Report—Shows the total number of minutes per month that were used on the system for voice conferencing (with or without video) by all users in all meetings. This report option was introduced in Release 7.0.2.

For example, a meeting in which 10 users each participated for 60 minutes would add 600 minutes for the month in which the meeting occurred.

Note The system must have been in use for at least one month before you can use this report.

Step 4 Configure the fields which affect the output.

Step 5 Select Create Report.

Step 6 Select OK.

What To Do Next

To interpret the exported data, see one of the following topics:

•Output Reference: Port Utilization Report in the Administration Center Page References for Cisco Unified MeetingPlace module

•Output Reference: Unattended Ports Report in the Administration Center Page References for Cisco Unified MeetingPlace module

Running a Report about Meetings

This report provides information about meetings that occur in the specified date range.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Reports > Meeting Information Report.

Step 3 Configure the fields on the Meeting Information Report Page.

Step 4 Select Create Report.

Step 5 Select OK.

What To Do Next

To interpret the exported data, see "Field Reference and Output Field Reference: Meeting Information Report Page" in the Administration Center Page References for Cisco Unified MeetingPlace module.

Exporting Information about Dial-Out Calls

Use this procedure to export information about outgoing calls that were placed by Cisco Unified MeetingPlace during a specified range of dates.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data.

Step 3 Select Outgoing Calls Information.

Step 4 Configure the fields:

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

For restrictions and recommendations for each option, see Table 1.

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. Select Create Report.

Step 5 Select OK.

What To Do Next

To interpret the exported data, see "Export Data Specifications—Outgoing Calls Information" in the Raw Data Export and Import Specifications for Cisco Unified MeetingPlace module.

Exporting the System Configuration

An exported system configuration file can be used as an import file if you need to replace your hardware or reinstall the complete Cisco Unified MeetingPlace system.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Maintenance > Export Data > Export System Configuration.

Step 3 Select Create Report.

Step 4 Save the file.

Related Topics

•Importing the System Configuration in the Importing Data into Cisco Unified MeetingPlace module

Viewing the E-Mail Notification Queue

This task describes how to view the e-mail notification queue and (if necessary) to delete any unsent notifications.

Procedure

Step 1 Log in to the Administration Center.

Step 2 Select Reports > E-Mail Notification Queue Status Report.

Step 3 To interpret the data, see Table 4.

Table 4 Output Field Reference: E-Mail Notification Queue Status Report Page

Field

Description

Meeting ID

Meeting ID, which uniquely identifies the meeting.

Date

Date and time of the scheduled meeting.

Requestor

User ID of the meeting owner.

Method

Always displays "E-mail."

Mailbox Number

Type of e-mail notification:

•2—IBM Lotus Notes

•3—SMTP

•4—Microsoft Exchange

Description

Describes the status in the queue, for example: New meeting scheduled. Queued for delivery.

Step 4 (Optional) To delete any unsent e-mail notifications:

a. Check the relevant check box(es).

b. Select Delete Notification(s).

Related Topics

•Configuring E-Mail Notifications for Cisco Unified MeetingPlace module