Spinner Software logo Home News Products Buy online Solutions About
Sitemap Freelancers Download Support Services Contact us

Software Products

LogReader - Analyse feature.

The Analyse window enables you to fully analyse the contents of the imported log files. In addition to reviewing the raw data you can sort, filter, or group related records. A Rule is a simple filter, and a Category is a collection of Rules.

Screenshot of the Analyse window


There are 3 views defined: Raw data, Filtered Data, and Grouped Data.

Raw data

When viewing raw data, sorting, filtering and grouping is disabled. You have quick access to view every single entry in the collection.

Filtered data

When viewing filtered data, you can specify the period and sort order. You can also filter the data on a Rule, or a Category (collection of rules). See Categories and Rules for details.

Grouped data

When viewing Grouped Data, you can specify the period and sort order (Field value or Total). You can also use Rules or Categories to further filter the data to group. You can group by the following fields along the Y-axis: Date, Statuscode, Request type, User IP, Size, or Page. You can group by the following fields along the X-axis: (none), Day, Week, Month, Quarter, Year or Hour.

An example would be to group by Pages first, then by Day, within the period of July 2004 and filtered by a Rule specifying that the Port = 443. This would show you all records for July 2004 where the destination port was 443, with a single line for each page. Each line would have 33 columns : Page name | Total number of records for this page | 31 columns with the count for each day.

Sorting records

To sort the displayed records, you must be in the Filtered Data or Grouped Data view. Select the field you want to group by from the drop-down list, optionally choosing to sort in Ascending or Descending order. The list will automatically resort.

Refresh button

Click on the Refresh button to refilter the data and update the display.

Export button

Click on the Export button to export all data in the current view. This means that you can either export raw data, filtered data, or grouped data. You can export to text files (using simple templates), database tables, or office applications such as Microsoft Excel.

Report button

Click on the Report button to show the current overview of the displayed records (raw, filtered or grouped). Click on the Refresh button in the report to recalculate the totals based on the current view.

Categories button

Click on the Categories button to change your collections of predefined rules to filter on.

Rescan button

Click on the Rescan button to recheck every record for the rules in each Category. If all rules evaluate to True then the record is marked as belonging to the Category. You can select a category in the drop-down list to filter on records belonging to the selected category.

Period button

Click on the Period button to only show records from within the selected timeframe. You must be in the Filtered Data or Grouped Data view. You can select any period you'd like, but for Grouped Data a maximum of 100 columns must be made ; this, for example, means you cannot group together by page (Y-axis) then by day (X-axis) for a period that exceed 100 days.

Categories drop-down list

Select a category in the drop-down list to filter on records belonging to the selected category. If you have changed your Categories, you may have to click on the Rescan button to update the Category collection memberships.

Rule drop-down list

By selecting a rule in the drop-down list and entering a value in the text field to the right of the list, you can filter the records to display using the selected rule. You must be in the Filtered Data or Grouped Data view to use this feature.

The following rules are available for filtering: Comments, Invalid Records, File extension is [x], Date is [x], Resultcode is [x], Statuscode is [x], Port is [x], User Region is [x], Request Type is [x], HTTP Version is [x], Site IP Address is [x], User IP address is [x], Page is [x], Referer is [x], UserAgent is [x], File is [x], Record Number is [x], Server->Client bytes is [x], Client->Server bytes is [x], Time Taken is [x], Directory is [x], Page Filename is [x].

For all the rules mentioned above, [x] refers to the value entered in the text field. In addition to a value you can use the following mathematical criterias:

<	Less than
>	Greater than
<=	Less than or equal
>=	Greater than or equal
=	Equal to
!=	Not equal to
<>	Not equal to

Right mouse button

You can right-click with your mouse on an entry to get access to the quick filter menus. Using these menus you can automatically set a filter (Rule) that will match the current record. For example, right-clicking on an entry for a page with the name "page1.html" and selecting the "Page is page1.html" filter, will select a Rule for "Page = page1.html".

Invert button

The invert button selects all records that are currently not selected, thus inverting the current output selection.