uniqueSummaryID
frequency
startTimestamp
cardinality
webServerID
emailID
hits
bytesSent
transferTime
percentHits
percentBytesSent
percentTransferTime
averageHits
averageBytesSent
averageTransferTime
Unique
- uniqueSummaryID
Non-Unique
- frequency, startTimestamp
- emailID
uniqueSummaryID
Each summary row has its own unique ID, which distinguishes it from other rows.
Description of rows entered for each summary frequency.
Hourly: Unique ID assigned to this summary row Daily: Unique ID assigned to this summary row Weekly: Unique ID assigned to this summary row Monthly: Unique ID assigned to this summary row
frequency
This column indicates the frequency of the summary row--hourly (H), daily (D), weekly (W) or monthly (M).
Description of rows entered for each summary frequency.
Hourly: H Daily: D Weekly: W Monthly: M
startTimestamp
The start date and time of a summary.
Description of rows entered for each summary frequency.
Hourly: The date and the hour of the day (eg. 02/22/1996 14:00:00) Daily: The date and the midnight hour (eg. 02/22/1996 00:00:00) Weekly: The date of first day of the week and the midnight hour (eg. 02/18/1996 00:00:00) Monthly: The date of the first day of the month and the midnight hour (eg. 02/01/1996 00:00:00)
cardinality
Depending on the frequency (hourly, daily, weekly or monthly), the number displayed indicates the exact hour, day, week or month at the time of the summary.
Description of rows entered for each summary frequency.
Hourly: Hour of the day (0-23) Daily: Day of the week (1-7, 1=Sunday) Weekly: Week of the year (1-52, or 53) Monthly: Month of the year (1-12)
webServerID
The unique ID of Web server that sent the log entry. The corresponding Web Server can be found in the WebServers table. This information is not affected by the summary frequency.
emailID
The unique e-mail ID. This information is not affected by the summary frequency.
hits
Hits indicates the how many times a certain Web page is accessed every hour, day, week or month.
Description of rows entered for each summary frequency.
Hourly: Total hits received for this hour Daily: Total hits received for this day Weekly: Total hits received for this week Monthly: Total hits received for this month
bytesSent
Bytes sent indicates the number of bytes transmitted every hour, day, week or month.
Description of rows entered for each summary frequency.
Hourly: Total bytes transmitted for this hour Daily: Total bytes transmitted for this day Weekly: Total bytes transmitted for this week Monthly: Total bytes transmitted for this month
transferTime
The number of seconds (with decimal precision) it takes to complete a transmission.
Description of rows entered for each summary frequency.
Hourly: Total time spent transmitting data for this hour Daily: Total time spent transmitting data for this day Weekly: Total time spent transmitting data for this week Monthly: Total time spent transmitting data for this month
percentHits
The percentage of hits per hour, day, week or month is indicated in this column.
Description of rows entered for each summary frequency.
Hourly: Percent of total hits per hour Daily: Percent of total hits per day Weekly: Percent of total hits per week Monthly: Percent of total hits per month
percentBytesSent
The percentage of bytes sent per hour, day, week or month is indicated in this column.
Description of rows entered for each summary frequency.
Hourly: Percent of total bytes sent per hour Daily: Percent of total bytes sent per day Weekly: Percent of total bytes sent per week Monthly: Percent of total bytes sent per month
percentTransferTime
The percentage of time sent transferring per hour, day, week or month is indicated in this column.
Description of rows entered for each summary frequency.
Hourly: Percent of total transfer time per hour Daily: Percent of total transfer time per day Weekly: Percent of total transfer time per week Monthly: Percent of total transfer time per month
averageHits
The total number of hits is averaged out for each day, week or month.
Description of rows entered for each summary frequency.
Hourly: N/A Daily: Average hits received per hour for this day Weekly: Average hits received per day for this week Monthly: Average hits received per day for this month
averageBytesSent
The total number of bytes sent is averaged out for each day, week or month.
Description of rows entered for each summary frequency.
Hourly: N/A Daily: Average bytes transmitted per hour for this day Weekly: Average bytes transmitted per day for this week Monthly: Average bytes transmitted per day for this month
averageTransferTime
The total amount of time spent transferring data is averaged out for each day, week and month.
Description of rows entered for each summary frequency.
Hourly: N/A Daily: Average time spent transmitting data per hour for this day Weekly: Average time spent transmitting data per day for this week Monthly: Average time spent transmitting data per day for this month