ActivityLog Table
The Activity Log table contains detailed information on each entry received
from the Web server.
Columns
logID
logTimestamp
hourOfDay
webServerID
resultID
domainNameID
reversedSubDomainID
clientDomainID
URLID
pathArgsID
searchArgsID
methodID
agentID
webUserID
emailID
refererID
bytesSent
transferTime
Indices
Unique
- logID
Non-Unique
- logTimestamp
- hourOfDay
- webServerID
- webUserID
- clientDomainID
- URLID, domainNameID, logTimestamp
- agentID
Column Definitions
logID
The unique ID assigned to this log entry received from a Web server.
logTimestamp
Date and Time from this log entry received from the Web server.
hourOfDay
Hour of the day based on logTimestamp.
webServerID
The unique ID of Web server that sent the log entry. The corresponding Web
Server can be found in the WebServers table.
resultID
The unique ID of the Result code received as a result of the request. The
corresponding Result code can be found in the Results
table.
domainNameID
The unique ID of the Domain Name that initiated the request. The corresponding
Domain Name can be found in the DomainNames table.
reversedSubDomainID
The unique ID of the Reversed Sub Domain derived from the Domain Name. The
corresponding Reversed Sub Domain can be found in the ReversedSubDomains
table.
clientDomainID
The unique ID of the Client Domain derived from the Domain Name. The corresponding
Client Domain can be found in the ClientDomains
table.
URLID
The unique ID of the URL affected. The corresponding URL can be found in
the URLs table.
pathArgsID
The unique ID of the Path Arguments passed. The corresponding Path Argument
can be found in the PathArgs table. If no Path Arguments
are passed, a value of NULL will be entered.
searchArgsID
The unique ID of the Search Arguments passed. The corresponding Search Argument
can be found in the SearchArgs table. If no Search
Arguments are passed, a value of NULL will be entered.
methodID
The unique ID of the Method of retrieval requested by the Agent. The corresponding
Method can be found in the Methods table.
agentID
The unique ID of the Agent (Browser). The corresponding Agent can be found
in the Agents table.
webUserID
The unique ID of the Web User passed from registration. The corresponding
Web User can be found in the WebUsers table.
emailID
The unique ID of the e-mail address passed by the Agent. The corresponding
e-mail address can be found in the EMail table.
refererID
The unique ID of the location that referred the Domain Name to this Web
server. The corresponding Referer can be found in the Referers
table.
refererType
This field displays a boolean value of 1 if the URL has been accessed from
another site, a value of 0 if the URL was referred to internally, or a value
of 2 if there was no referer.
bytesSent
The total bytes sent as a result of the request.
transferTime
The total transfer time taken, in seconds with decimal precision.

Home Page - Reports