Cisco Unified MeetingPlace, Release 7.0 -- How To Run Reports and Export Data

From DocWiki

Main page: Cisco Unified MeetingPlace, Release 7.0

Up one level: Maintenance Page

Caution!! We recommend 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.

Contents 1 Exporting User Groups 1.1 Restrictions 1.2 Procedure 1.3 Related Topics 1.4 What To Do Next 2 Exporting User Profiles 2.1 Restrictions 2.2 Procedure 2.3 Related Topics 2.4 What To Do Next 3 Exporting Video Terminal Profiles 3.1 Procedure 3.2 Related Topics 3.3 What To Do Next 4 Exporting Remote Servers 4.1 Procedure 4.2 Related Topics 5 Exporting Meeting Categories 5.1 Procedure 5.2 Related Topics 6 Exporting Meetings 6.1 Restrictions 6.2 Procedure 6.3 Table: Field Reference: Export Meetings Page 6.4 Related Topics 6.5 What To Do Next 7 Exporting Information about Continuous Meetings 7.1 Procedure 7.2 Table: Field Reference: Continuous Meetings Information Page 7.3 What To Do Next 8 Exporting Information about Meeting Participants 8.1 Procedure 8.2 What To Do Next 9 Exporting Information about When Participants Join and Leave Meetings 9.1 Procedure 9.2 What To Do Next 10 Exporting Information about Scheduling 10.1 Procedure 10.2 What To Do Next 11 Running a Report about Meeting Cancellations 11.1 Procedure 11.2 What To Do Next 12 Running a Report for Billing 12.1 Procedure 12.2 What To Do Next 13 Running Capacity Management Reports 13.1 Procedure 13.2 What To Do Next 14 Running a Report about Meetings 14.1 Procedure 14.2 What To Do Next 15 Exporting Information about Dial-Out Calls 15.1 Procedure 15.2 What To Do Next 16 Exporting the System Configuration 16.1 Procedure 16.2 Related Topics 17 Viewing the E-Mail Notification Queue 17.1 Procedure 17.2 Table: Output Field Reference: E-Mail Notification Queue Status Report Page 17.3 Related Topics

Exporting User Groups

Restrictions

Flex fields are not included in exported output.

Procedure

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export User Groups.
3. On the Group Information page:
   1. Choose the output destination from the Destination drop-down list.

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

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. 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.

   3. Click Create Report.
4. Click OK to proceed.
5. If you are exporting data to create an import file, save the file with a .csv extension.

Related Topics

• 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 Table: Import and Export Data Specifications for User Profiles.

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export User Profiles.
3. On the Profile Information page:
   1. Choose the output destination from the Destination drop-down list.

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

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. 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.

   3. Click Create Report.
4. Click OK to proceed.
5. If you are exporting data to create an import file, save the file with a .csv extension.

Related Topics

• Configuring Cisco Unified MeetingPlace Directory Service

• 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 Table: Import and Export Data Specifications for User Profiles.

Exporting Video Terminal Profiles

Procedure

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export Video Terminal Profiles.
3. On the Profile Information page:
   1. Choose the output destination from the Destination drop-down list.

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

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. 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.

   3. Click Create Report.
4. Click OK to proceed.
5. If you are exporting data to create an import file, save the file with a .csv extension.

Related Topics

• 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 Table: Import and Export Data Specifications for Video Terminal Profiles.

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export Remote Servers.
3. Click Create Report.
4. Save the file.

Related Topics

• Importing Remote Servers

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export Meeting Categories.
3. Click Create Report.
4. Save the file.

Related Topics

• Importing Meeting Categories

• Configuring Meeting Categories

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.

• 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, the SchedulerUid field is left blank in the meeting export file.

Procedure

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export Meetings.
3. Specify the output options, as described in Table: Field Reference: Export Meetings Page.

Table: Field Reference: Export Meetings Page

Field	Description
Destination	If you plan to use the exported output to create an import file, select File. For restrictions and recommendations for each option, see Table: Report and Export Destination Options.
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)

4. Click Create Report.

5. Click OK to proceed.

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

Related Topics

• Scheduling Meetings by Import

• Canceling Meetings by Import

• Setting Up an Import File

What To Do Next

To interpret the exported data, see Table: Import and Export Data Specifications for Meetings.

Exporting Information about Continuous Meetings

Use this procedure to export raw data about continuous meetings.

Procedure

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Continuous Meetings Information.
3. Specify the output options, as described in Table: Field Reference: Continuous Meetings Information Page.

Table: Field Reference: Continuous Meetings Information Page

Field	Description
Destination	Output destination. For restrictions and recommendations for each option, see Table: Report and Export Destination Options.
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)

4. Click Create Report.

5. Click OK.

What To Do Next

To interpret the exported data, see Table: Export Data Specifications-Continuous Meetings Information.

Exporting Information about Meeting Participants

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

Procedure

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Meeting Participant Information.
3. On the Meeting Participants Report page:
   1. Choose the output destination from the Destination drop-down list.

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. Choose whether to include field header names in the output.
   3. Specify the range of dates for which you want to export information about meeting participants.
   4. Click Create Report.
4. Click OK.

What To Do Next

To interpret the exported data, see Table: Export Data Specifications-Meeting Participant Information.

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Meeting Participant Join Leave Information.
3. On the Meeting Participant Join Leave Information page:
   1. Choose the output destination from the Destination drop-down list.

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. Choose whether to include field header names in the output.
   3. Specify the range of dates for which you want to export information about when meeting participants join and leave meetings.
   4. Click Create Report.
4. Click OK.

What To Do Next

To interpret the exported data, see Table: Export Data Specifications-Meeting Participant Join Leave Information.

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data.
3. Click 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
4. Configure the fields:
   1. Choose the output destination from the Destination drop-down list.

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. Choose whether to include field header names in the output.
   3. Specify the range of dates for which you want to export information about scheduling failures.
   4. Click Create Report.
5. Click OK.

What To Do Next

To interpret the exported data, see the following sections:

• Table: Export Data Specifications-Scheduling Failures Information

• Table: Export Data Specifications-Scheduling Statistics Information

• Table: 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

1. Log in to the Administration Center.
2. Click Reports > Meeting Cancellation Report.
3. Configure the fields on the Meeting Cancellation Report Page.
4. Click Create Report.
5. Click OK.

What To Do Next

To interpret the exported data, see Table: Field Reference: Meeting Cancellation Report Page.

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

1. Log in to the Administration Center.
2. Click Reports > Billing Report.
3. Configure the fields on the Billing Report Page.
4. Click Create Report.
5. Click OK.

What To Do Next

To interpret the exported data, see Table: Field Reference and Output Field Reference: Billing Report Page.

Running Capacity Management Reports

Procedure

1. Log in to the Administration Center.
2. Click Reports.
3. Click 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.

4. Configure the fields which affect the output.
5. Click Create Report.
6. Click OK.

What To Do Next

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

• Output Reference: Port Utilization Report

• Output Reference: Unattended Ports Report

Running a Report about Meetings

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

Procedure

1. Log in to the Administration Center.
2. Click Reports > Meeting Information Report.
3. Configure the fields on the Meeting Information Report Page.
4. Click Create Report.
5. Click OK.

What To Do Next

To interpret the exported data, see Table: Field Reference and Output Field Reference: Meeting Information Report Page.

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data.
3. Click Outgoing Calls Information.
4. Configure the fields:
   1. Choose the output destination from the Destination drop-down list.

      For restrictions and recommendations for each option, see Table: Report and Export Destination Options.

   2. Choose whether to include field header names in the output.
   3. Specify the range of dates for which you want to export information about outgoing calls.
   4. Click Create Report.
5. Click OK.

What To Do Next

To interpret the exported data, see Table: Export Data Specifications-Outgoing Calls Information.

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

1. Log in to the Administration Center.
2. Click Maintenance > Export Data > Export System Configuration.
3. Click Create Report.
4. Save the file.

Related Topics

• Importing the System Configuration

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

1. Log in to the Administration Center.
2. Click Reports > E-Mail Notification Queue Status Report.
3. To interpret the data, see Table: Output Field Reference: E-Mail Notification Queue Status Report Page.

Table: 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.

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

a. Check the relevant check box(es).

b. Click Delete Notification(s).

Related Topics

• Configuring E-Mail Notifications for Cisco Unified MeetingPlace