Avaya VoIP Monitoring Manager Reference Release 3.1 Manual de usuario descargar pdf (Pagina 60)

Avaya VoIP Monitoring Manager Reference

Export Report Data (one session)

You can export the data from a single report to a comma separated value (csv) file by using the

Export button located on the Report dialog box.

Only the data from the selected report is exported (that is, the data that matches one session,

rather than a summary for multiple session).

The recommended spreadsheet is Excel. Exporting the data to Excel enables you to manipulate

the data so you can create your own statistical reports. Click this link to see an example (Adobe

Acrobat 5 or later required  the page has been split into three because of its width). You can use

the sorting, counting, and calculation features of Microsoft Excel to create your own reports from

this raw data.

The data exported is divided into 3 tables:

 Session Table

 Time-varying Data Table

 Trace Route Table

To Export Data from the Report Dialog

1. Click the Report button located on the Report dialog box. A Save dialog box opens.

2. Navigate to a folder.

3. In the File name: field, type a name for the file.

4. Click Save as. The file saves with the CSV extension.

5. From the spreadsheet program, open the file. From here you can build your own report.

Microsoft Excel only handles 65,536 rows of data. If you need to export

more data, you will need to write a script that allows you to export more

data or you could try exporting it to a database program such as Access.

Top

Creating Reports with Exported Data

You can export the data from the Result List and/or Report dialog boxes to Microsoft Excel. Using

Microsoft Excel you can create your own reports as shown in the linked example. This report was

created by using Microsoft Excel’s calculation features. It includes averaging results, counting the

number of sessions and unique participants, setting filters to determine the longest sessions, and

creating a line graph to visually demonstrate the information. You can create your own reports

from the exported data. click this link to see an example (Adobe Acrobat reader is required).

1 2 ... 55 56 57 58 59 60 61 62 63 64 65 ... 113 114

Sin comentarios

Avaya VoIP Monitoring Manager Reference Release 3.1 Manual de usuario Pagina 60