-
Administrator Guide for Cisco Unified MeetingPlace Audio Server Release 5.3
-
Preface
-
Introducing Cisco Unified MeetingPlace Audio Server
-
Setting Up Cisco Unified MeetingPlace Audio Server
-
Scheduling and Attending Meetings
-
Running Reports
-
Managing and Maintaining Cisco Unified MeetingPlace Audio Server
-
Troubleshooting the Cisco Unified MeetingPlace Audio Server System
-
Installing MeetingTime
-
File Import Specifications
-
Raw Data Export Specifications
-
Cisco Unified MeetingPlace SNMP
-
Cisco Unified MeetingPlace DCTS Addin
-
Creating, Uploading, and Deleting Custom Voice Prompts
-
Custom Voice Prompts
-
Feedback
Table Of Contents
Generating Reports from the Report Tab
Generating Batch Reports in Windows Batch Mode
Scheduled vs. Actual by User Report
Scheduling Activity by User Report
Meeting Attendance by User Report
Meeting Attachment Information Report
Question and Answer Usage Report
Billing Information (Summary) Report
Billing Information (Detail) Report
Setting Up the Target Database
Exporting Raw Data Reports into Microsoft Excel
Running Reports
This chapter describes the following topics:
About Reports
The Cisco Unified MeetingPlace system offers a set of standard reports that provide information on the level of system usage, user activity, and system parameters. Information in the reports can help you answer questions such as:
•
How frequently are people in my company using Cisco Unified MeetingPlace? How many conferences did a user schedule or attend?
•
•
Table 4-1 describes the various reports that Cisco Unified MeetingPlace provides.
Table 4-1 Cisco Unified MeetingPlace Report Types
System reports
Describes the hardware and software in the Cisco Unified MeetingPlace system. For more information, see the "About System Reports" section.
System usage reports
Describes meeting scheduling and attendance activities by user. Run these reports frequently to identify cases of system abuse and to document telephone billing charges. For more information, see the "About System Usage Reports" section.
Billing reports
Provides dialing and billing information. You can run billing reports weekly or biweekly to monitor outbound dialing by users and the total number of calls being made by users. For more information, see the "About Billing Reports" section.
Raw data reports
Consists of unformatted data that can be exported to other database or spreadsheet applications. You can then format this data to suit a wide variety of purposes. For more information, see the "About Raw Data Reports" section.
Generating Reports
You can generate reports in two ways:
•
•
You can also schedule report generation by using scheduling programs provided by other software vendors. For information and help in choosing such a program, see "Obtaining Technical Assistance" in the Guide to Cisco Conferencing Documentation and Support.
We recommend that you run reports during off-peak usage hours. Running reports during peak usage hours can affect performance.
Generating Reports from the Report Tab
Reports generated in MeetingTime display the conference server time zone. If the time zones for the user and the server are different, the dates and times in the report will differ from the dates and times displayed in MeetingTime for that user.
Step 1
Step 2
Do not select a report heading (in all uppercase letters). These are report types and cannot be selected.
Step 3
and ChooseView the report on your screen
Screen
Download report data to a file, to later import to a spreadsheet, database, or word-processing program, such as Microsoft Excel or Microsoft Word. (For more information, see the "Exporting Raw Data Reports into Microsoft Excel" section.)
File
Send the report directly to your local printer. You can also specify the number of copies and the printer, and change other print properties.
Note
Printer
Step 4
Step 5
A message displays, telling you that you may cancel the report generation after the server has received the query instructions.
Step 6
Depending on the size of your system, it may take several minutes for the report to generate. As the server processes your query instructions and retrieves the report data, you see a progress bar, the current size of the report file, the percentage of the job completed, and other report status information.
The generated report displays in the Report Viewer window.
Step 7
Generating Batch Reports in Windows Batch Mode
Step 1
Step 2
C:\Program Files\Cisco Systems\Mtgtime530\mtgtime.exe userid [user ID] userpwd [password] hostname [Cisco MeetingPlace host name] [report type parameter]For [report type parameter], use the information in Table 4-2.
Table 4-2 Parameters for Reports
Use the following information when entering parameters:
•
•
•
•
For information about storing login settings, see the "Editing and Storing MeetingTime Settings" section.
About System Reports
System reports provide system configuration information about Cisco Unified MeetingPlace—both the configuration of system hardware and software and the state of installed trunks.
Cisco Unified MeetingPlace offers the following five system reports:
System Options Report
The System Options report summarizes the ports, licenses, and options on the system. The report shows:
•
•
•
Port Attributes Report
The Port Attributes report shows the status of your server's installed ports.
User Information Report
The User Information report lists all the active and non-active users by group. Also included are billing code and type of user.
Group Information Report
The Group Information report lists each active and non-active group configured in the system. Also included are billing code and contact user ID for each group.
Team Information Report
The Team Information report provides details on all of the teams defined on the system. The report provides information about the team, such as the following:
•
•
•
•
•
•
•
•
•
•
License Information Report
The License Information report provides details about the Cisco Unified MeetingPlace licenses and system configuration, such as the following:
•
•
•
•
•
•
Info Capture Report
The Info Capture report provides details about the configuration and failure of the system during a particular time period. The generated report can then be given to Cisco TAC to troubleshoot problems.
The report can contain information about the Cisco Unified MeetingPlace 8106 or 8112 only, or include Cisco Unified MeetingPlace integration applications.
Table 4-3 describes the attributes for the Info Capture report.
Table 4-3 Info Capture Report Attributes
Include Gateway Info?
Whether to include information about Cisco Unified MeetingPlace integration applications.
No
Yes, No
Compress on transfer?
Whether to compress the report information when transferring it from the Cisco Unified MeetingPlace Audio Server database to MeetingTime.
No
Yes, No
Because report files can be as large as 100 MB, choose Yes if MeetingTime is connected to Cisco Unified MeetingPlace by modem.
Gateway unit (10-31)
If Include Gateway Info? is Yes, enter the number that corresponds to the gateway (Cisco Unified MeetingPlace integration application) to include in the report.
To determine the Gateway Unit value, you can run a license Info Capture report through MeetingTime. (See the "License Information Report" section.) Scroll to the bottom of the report to see the gateway identities.
10
Range is 10-31
Dr. Watson drive (A-Z)
Local drive on the computer on which the Cisco Unified MeetingPlace integration application resides.
C
—
Output file
Filename of the generated report.
infocap.txt
—
Start date
Start date for the report information.
Current date, unless current time is within one hour after midnight (in which case, default start date is yesterday)
—
Start time
Start time on Start Date for the report information.
One hour earlier than current time
—
End date
End date for the report information.
Current date
—
End time
End time on End Date for the report information.
Current time
—
About System Usage Reports
System usage reports provide administrative, scheduling, attachment, and outbound dialing information. Cisco Unified MeetingPlace provides the following system usage reports:
•
•
•
•
•
Scheduling Statistics Report
The Scheduling Statistics report, shows the number of meetings scheduled for a specified time period and the method used to schedule each meeting. This report also shows the number of successful and failed client connections.
Scheduling Failures Report
The Scheduling Failures report, gives information on how often users were unable to schedule a meeting for various reasons, such as a lack of available ports or meeting ID conflicts. This report also shows the date and time the scheduling attempt was made, when the meeting failure occurred, and requested statistics about the meeting. This information is useful in determining when to expand the system or free up recording disk space.
Scheduling failures are maintained in a database that is pre-allocated to hold 20,000 records. The database begins to overwrite the first records when the 20,000th record is reached.
Port Usage Report
The Port Usage report shows how each port is being used by the system—the number of incoming and outgoing calls. Run this report frequently to monitor problems with ports. Watch for large numbers of calls on one port, possibly an indication of unauthorized access or toll fraud. Also watch for no activity on a port, which might indicate that the port is bad.
Scheduled vs. Actual by User Report
The Scheduled vs. Actual by User report compares scheduled calls to completed calls for a specific day and time. It also shows the number of participants, allowing you to see if the organizers scheduled too few ports or too many.
The report shows the following information:
•
•
•
•
Scheduling Activity by User Report
The Scheduling Activity by User report shows the number of meetings scheduled by a user for a specified time period.
This report includes the following information:
•
•
•
•
•
Meeting Attendance by User Report
The Meeting Attendance by User report allows you to monitor the number of meetings attended by a specific user. This report lists information about a user for a specified time period. Included in this report are the number of meetings attended and the total number of calls in the specified time period.
Meeting Information Report
The Meeting Information report provides detailed information specific to a meeting, including:
•
•
•
•
•
•
Meeting Attachment Information Report
The Meeting Attachment Information report, provides details, for a specific time interval, about the meeting and the meeting attachments.
This report includes:
•
•
•
Permanent Meetings Report
The Permanent Meetings report displays information about meetings that remain after normal meeting information is purged from the system (continuous meetings or meetings that cannot be purged).
This report provides detailed information specific to permanent meetings and their recordings, including:
•
•
•
•
•
•
Question and Answer Usage Report
The Question and Answer Usage report provides details, for a specific time interval, about meetings in which one or more participants were granted the floor using the Q&A feature. This report is useful for analyzing dynamics of Q&A meetings held on your Cisco Unified MeetingPlace system.
Q&A Usage reports provide the following meeting information:
•
•
•
•
•
•
•
•
–
–
About Billing Reports
Billing reports list the usage associated with individual users or groups of users for billing purposes. These reports can be run monthly to provide a bill-back report for other groups in a company. The billing code is based on the billing code assigned to a meeting.
Billing reports include the following:
•
•
•
Billing Information (Summary) Report
The Billing Information (Summary) report provides information for a specific time interval. When running this report, users must enter a per-minute charge.
This report includes the following information:
•
•
•
Billing Information (Detail) Report
The Billing Information (Detail) report provides billing information by billing code and by user for a specific time interval.
This report includes the following information:
•
•
•
•
Disk Usage Information Report
Disk Usage Information reports break down disk consumption, in minutes, for each meeting. Information includes the server that the meeting was held on, and recording and attachment space used for the meeting.
Outbound Dialing Report
Outbound Dialing reports list outbound calls by user. They allow you to monitor the system and to watch for large numbers of calls, which can indicate unauthorized access or toll fraud.
This report includes:
•
•
•
•
•
About Raw Data Reports
Information stored in the Cisco Unified MeetingPlace Audio Server database is also available as raw data reports. These reports allow you to use the Report tab to export raw data to a spreadsheet or database program for further processing and formatting. Because the data in these reports is initially unformatted, you can format the information in various ways.
Setting Up the Target Database
When setting up the target spreadsheet or database, start by defining the fields in terms of the field names given in this section. When you are ready to export raw data from the system, be sure to name the raw data file using a filename extension that the target program recognizes, such as .csv. You may also find that macros are useful for managing tables and reading raw data as it is exported to your target file. You may also include the field names as the first record in your export file.
Because the data in raw data reports is related, the order in which data is exported to the target file can be important. One suitable sequence is the following: group information, user profiles, meeting participants, meeting outdial, system outdial.
Exporting Raw Data Reports into Microsoft Excel
Step 1
Step 2
Step 3
Step 4
For information about raw data export specifications, see "Raw Data Export Specifications."
Summary of Raw Data Reports
Cisco Unified MeetingPlace includes ten raw data reports, as described in Table 4-4.
Table 4-4 Summary of Raw Data Reports