Downloading Log and Trace Records 

Use

In any predefined or custom view, you can download all log and trace records that meet the filter criteria, you specified to a comma separated value (CSV) formatted file. For example, you can view log and trace records in a human-readable format on a computer system on which a Log Viewer is not running. In addition, you can take advantage of the analysis tools provided by Microsoft Excel, such as the tools to chart the data, which can help you understand the data.

The records are only extracted first. Then you can download them to a CSV formatted file and save it to the file system.

For list formatted log and trace records, the file includes only the columns that you selected during column customization.

For text formatted log and trace records, the file includes only the complete message text.

The maximum size of the extraction file is 5 MB. If this size is exceeded, you can download the records that have been extracted so far. Then you can continue with the extraction of the next portion of log and trace records.

Procedure

1. Extracting and Downloading the Content

       1.      Open the relevant view you want to extract and download.

       2.      Choose Download Content.

A dialog box appears.

       3.      To start extracting the log and trace records, choose Download.

       4.      To stop extracting the log and trace records, choose Stop.

You can still download the log and trace records that have been extracted so far.

       5.      To download log and trace records that have been extracted, choose here.

If the size of the extracted information exceeds 5 MB, the content will be downloaded in series.

       6.      Save the file to the file system.

2. Reading the File in Microsoft Excel

       1.      Open the file using Microsoft Excel.

       2.      Select column A.

       3.      From the Data menu, choose Text to Columns.

       4.      In the Convert Text to Columns Wizard – Step 1 of 3 dialog box, select the Delimited indicator and choose Next.

       5.      In the Convert Text to Columns Wizard – Step 2 of 3 dialog box, select the following indicators: Tab, Comma, and Treat consecutive delimiters as one.

       6.      From the Text qualifier dropdown box, select double quotation marks (“), and then choose Next.

       7.      In the Convert Text to Columns Wizard – Step 3 of 3 dialog box, select the General indicator and choose Finish.

Result

The log and trace records are displayed in a human-readable format in Microsoft Excel.