Cisco Unified MeetingPlace Release 6.1 -- About Raw Data Reports
From DocWiki
Cisco Unified MeetingPlace Release 6.1 > Cisco Unified MeetingPlace Audio Server > Maintaining > Running 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.
Contents |
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
Do the following procedure.
To Export Raw Data Reports to Excel
- Generate a Raw Data report (see the About Raw Data Reports).
- When the Report Viewer appears, click the Save to File button and save the file in .csv format.
- Launch Microsoft Excel, and open the raw data file.
- Click Finish .
- 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: Summary of Raw Data Reports.
Table: Summary of Raw Data Reports
| Raw Data Report | Description |
|---|---|
|
Raw Profile Information |
Lists all users and their attributes, including privileges and restrictions for each user. The report also specifies which attributes differ from those of each user group profile.
|
|
Raw Group Information |
Lists all the user groups and their attributes, including:
|
|
Raw Meeting Details Information |
Provides information about every Cisco Unified MeetingPlace meeting. You can specify a range of meetings to include in the report.
|
|
Raw Meeting Participant Information |
Lists all conference calls within a time period and shows information about conference participants. The Meeting Participant report shows the following information:
|
|
Raw Meeting Outdial Information (users) |
Lists all conference calls for a time period and shows information about outdialing to other users for each conference, including the destination, duration, and originator of each outdial.
|
|
Raw Meeting Outdial Information (servers) |
Lists all conference calls for a given time period and shows which servers were outdialed to for each conference, including the destination, duration, and originator of each outdial.
|
|
Raw Meeting Attachment Information |
Provides details about attachments submitted to a meeting, including the submitter name, attachment format, size, and file type, platform from which it was submitted, and how many people accessed the attachment.
|
|
Raw System Outdial Information |
Lists all outbound calls by the system within a time period. System outdials include alarms, blast outdials, and call transfers when no meeting has been identified. This report includes the type, destination, and duration of each call.
|
|
Raw Scheduling Failures |
Lists all scheduling failures. Included in this report is the user ID of the scheduler, the requested ID of the meeting, the date and time of each failure, and the cause of the failure. For reservationless meetings, this report also shows meetings that cannot be started due to a lack of resources.
|
|
Raw Participant Join Leave Information |
Provides a detailed account of when users join and leave a meeting. For PBXs that provide DNIS information, these digits are captured and can be used to identify the phone number and meeting participant dialed. Likewise, for PBXs that provide ANI information, these digits are captured and can be used to identify the caller. This report can be used to determine whether toll-free or local numbers were used to attend the meeting.
|
|
Raw Team Details Information |
Lists all information about the team. |
|
Raw Team Member Details Information |
Lists all information about all members of this team. Note: Before you can import team member information, you must first import team information, because team member information depends on the team information. |