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
  1. logID


Non-Unique
  1. logTimestamp
  2. hourOfDay
  3. webServerID
  4. webUserID
  5. clientDomainID
  6. URLID, domainNameID, logTimestamp
  7. 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