VBrick Systems ETV v4.1 manual Viewing the Access Logs

Global Settings

Viewing the Access Logs

The log files are saved in Program Files\VBrick\MCS\Logs.You can view these file using a standard editor like Notepad or you can use the Excel spreadsheet template provided by VBrick. The MCSS Access Log.xlt template file makes to easy to view and sort log files. You can also use this template to build Pivot Tables to analyze the log data in greater detail. Pivot Tables are a powerful tool used to analyze multi-dimensional data. Pivot Tables are beyond the scope of this document and are not explained here. For an introduction to Pivot Tables, there are a variety of resources on the web including the Microsoft Office online demo at http://office.microsoft.com/en-us/assistance/HA011989031033.aspx

TTo create a pivot table:

1.Navigate to C:\Program Files\VBrick\MCS\Utils and double-clickMCSS Access Log.xlt

2.When prompted, select Enable Macros.

3.Click Import Log(s) and navigate to the log files in Program Files\VBrick\MCS\Logs

4.Select one or more log files by holding down the Ctrl or Shift keys while selecting files.

5.Once the window is populated with log data (Figure 9) you can view or sort any of the

columns as necessary.

6.Click Pivot Table Wizard and follow the prompts to build a Pivot Table.

ETV Portal Server Admin Guide 63