[ Top | Up | Prev | Next | Map | Index ]

# Analog CE 6.0: Computer-readable output style

This section describes the computer-readable output style. You can select this style by the command

    OUTPUT COMPUTER

This style is designed to be easy to read into spreadsheets, or post-process with graphics creation tools, for example. You can find some programs which use this style on the helper applications page. However, the computer-readable output style is not suitable for reading back into analog to create later reports: for that job, use the cache files described in the next section.

Each line in the output is separated into fields by means of a special string. You can specify this string by means of the `COMPSEP` command; for example, you could use

    COMPSEP ,

for CSV (comma separated value) format. Or you can use

    COMPSEP \t

to separate fields with a tab. Make sure not to use anything that might occur in the output: for example, a single or double space would not be suitable.

Each line in the preformatted output begins with a letter indicating which report the line is part of. (The code letters for the reports are listed in the section on Configuring the Output.)

After that, there follows a field indicating the remaining columns in the report (using the letters `RrSsPpQqBbCcDdEeN` as usual). In hierarchical reports (including the reports which can show search arguments) there is an additional column `l` at the beginning, indicating the level in the hierarchy.

Finally there are the numerical data for each column and then the name of the item. Times actually take up several fields: year, month, date, hour & minute, or as many of those as are necessary to identify the time. (Year and quarter in the case of the Quarterly Report).

So here is an example line from the Domain Report, showing the third-level domain `cam.ac.uk` with 43 requests and 3.516% of the bytes.

    o     lRb     3     43     3.516     cam.ac.uk

The last line of most time reports indicates the busiest time period. After the report letter comes `*BT`, followed by the letter `R`, `P` or `B` for the `GRAPH` method, followed by the number of requests, pages or bytes respectively for the busiest time period, followed by the time period itself.

The first lines of non-time reports can also contain overall information about the report. First, if the `REPORTSPAN` for the report is wanted, it will be listed in lines with `*FR` and `*LR` instead of the normal column letters. Then there is a line listing the floor and sortby for the report. It has `*f` instead of the normal column letters, followed by the floor in the form it would be written for a `FLOOR` command, followed by the `SORTBY` using the code letters

`r`
  `REQUESTS`
`s`
  `REQUESTS`
`p`
  `PAGES`
`q`
  `PAGES`
`b`
  `BYTES`
`c`
  `BYTES`
`d`
  `DATE`
`a`
  `ALPHABETICAL`
`x`
  `RANDOM`

The general summary is a bit different. After an initial `x`, there is a two-character code saying what the line contains. The possible codes are

`VE`
  Version of analog
`HN`
  `HOSTNAME`
`HU`
  `HOSTURL`
`PS`
  Program start time
`FR`
  Time of first request
`LR`
  Time of last request
`E7`
  Time last 7 days ends
`SR`
  Total successful requests
`S7`
  Total successful requests in last 7 days
`PR`
  Total successful requests for pages
`P7`
  Total successful requests for pages in last 7 days
`FL`
  Total failed requests
`F7`
  Total failed requests in last 7 days
`RR`
  Total redirected requests
`R7`
  Total redirected requests in last 7 days
`NC`
  Logfile lines without status code
`C7`
  Lines without status code in last 7 days
`NF`
  Number of distinct files requested
`N7`
  Number of distinct files requested in last 7 days
`NH`
  Number of distinct hosts served
`H7`
  Number of distinct hosts served in last 7 days
`CL`
  Number of corrupt lines in the logfile
`UL`
  Number of unwanted lines in the logfile
`BT`
  Total number of bytes transferred
`B7`
  Total number of bytes transferred in last 7 days

Which lines are listed is still controlled by the `GENSUMLINES` command. This implies that if you turn a line off, you turn off its "last 7 days" version too.

Go to the Analog CE home page.

[ Top | Up | Prev | Next | Map | Index ]