MeetingPlace Moderator: 1 revision

2011-03-28T21:11:28Z

1 revision

← Older revision

Revision as of 21:11, 28 March 2011

MeetingPlace Moderator: Created page with "Cisco Unified MeetingPlace Release 6.1 > [[Cisco Unified MeetingPlace Release 6.1 -- Cisco Unified MeetingPlace Audio Server, Release 6.1|Cisco Unified MeetingPlace A..."

2011-02-07T19:24:22Z

Created page with "Cisco Unified MeetingPlace Release 6.1 > [[Cisco Unified MeetingPlace Release 6.1 -- Cisco Unified MeetingPlace Audio Server, Release 6.1|Cisco Unified MeetingPlace A..."

New page

[[Cisco Unified MeetingPlace Release 6.1]] >
[[Cisco Unified MeetingPlace Release 6.1 -- Cisco Unified MeetingPlace Audio Server, Release 6.1|Cisco Unified MeetingPlace Audio Server]]
> [[Cisco Unified MeetingPlace Release 6.1 -- Maintaining the Audio Server|Maintaining]]
> [[Cisco Unified MeetingPlace Release 6.1 -- Running Reports|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.

== 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 [[Cisco Unified MeetingPlace Release 6.1 -- About Raw Data Reports#About Raw Data Reports|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 [[Cisco Unified MeetingPlace Release 6.1 -- Raw Data Export Specifications|Raw Data Export Specifications]]

== Summary of Raw Data Reports ==

Cisco Unified MeetingPlace includes ten raw data reports, as described in [[Cisco Unified MeetingPlace Release 6.1 -- About Raw Data Reports#Table: Summary of Raw Data Reports|Table: Summary of Raw Data Reports]].

===== Table: Summary of Raw Data Reports =====

{| border = 1
|-
!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.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Profile Information Data|Raw Profile Information Data]]
|-
|

Raw Group Information
|

Lists all the user groups and their attributes, including:
* Privileges and restrictions for each group's users
* Billing code for each group
* Attributes of meetings scheduled by each group's users

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Group Information Data|Raw Group Information Data]]
|-
|

Raw Meeting Details Information
|

Provides information about every Cisco Unified MeetingPlace meeting. You can specify a range of meetings to include in the report.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Meeting Details Information Data|Raw Meeting Details Information Data]]
|-
|

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:
* Time each participant spent in the voice, video, and web conference, and time spent listening to recorded meetings
* Whether a participant was a speaker in the conference
* Outdial calls initiated by each participant

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Meeting Participant Information Data|Raw Meeting Participant Information Data]]
|-
|

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.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Meeting Outdial (Users) Information Data|Raw Meeting Outdial (Users) Information Data]]
|-
|

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.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Meeting Outdial (Servers) Information Data|Raw Meeting Outdial (Servers) Information Data]]
|-
|

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.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Meeting Attachment Information|Raw Meeting Attachment Information]]
|-
|

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.

When users repeatedly enter an invalid profile, the system outdials to the attendant for user assistance. Outdials to the attendant can indicate someone trying to gain unauthorized access to a profile. Use this report to determine the time a profile has been unsuccessfully accessed.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw System Outdial Information Data|Raw System Outdial Information Data]]
|-
|

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.

This report gives a more detailed look at scheduling failures, which allows you to determine the current traffic on your system.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Scheduling Failures|Raw Scheduling Failures]]
|-
|

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.

This report also tracks profile caller information on recording playbacks. Details include who, when, which recording, and length of time spent listening to the recording. Guests who attend are indicated as guests in the record.

For details, see [[Cisco Unified MeetingPlace Release 6.1 -- Raw Participant Join Leave Information|Raw Participant Join Leave Information]]
|-
|

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

[[Category: Unified MeetingPlace Release 6.1]]

Cisco Unified MeetingPlace Release 6.1 -- About Raw Data Reports - Revision history

MeetingPlace Moderator: 1 revision

MeetingPlace Moderator: Created page with "Cisco Unified MeetingPlace Release 6.1 > [[Cisco Unified MeetingPlace Release 6.1 -- Cisco Unified MeetingPlace Audio Server, Release 6.1|Cisco Unified MeetingPlace A..."