Domain Names Table


The Domain Names table contains detailed information on each domain name that accesses the Web server. This information is summarized to allow a variety of statistical reports to be generated.

The following terminology is used to refer to domain names, or parts of domain names.

SyntaxExample
Domain Namewww.everyware.com, watt.eng.uwaterloo.edu
Sub-Domaineveryware.com, eng.uwaterloo.edu
Reversed Sub-Domaincom.everyware, edu.uwaterloo.eng
Client Domaincom, edu

For IP Addresses that cannot be resolved, the IP Address will be broken down in a slightly different manner.

SyntaxExample
Domain Name205.189.228.106
Sub-Domain205.189.228
Reversed Sub-Domain205.189.228 (notice that the address is not reversed)
Client DomainUnresolved


Columns
domainNameID
webServerID
domainName
IPAddress
reversedSubDomainID
clientDomainID
firstHitTimestamp
lastHitTimestamp
hitsToDate
bytesSentToDate
transferTimeToDate





Indices

Unique
  1. domainNameID


Non-Unique
  1. webServerID, domainName
  2. webServerID, IPAddress
  3. reversedSubDomainID
  4. clientDomainID


Column Definitions

domainNameID

The unique ID of the Domain Name that initiated the request.


webServerID

The unique ID of Web server that sent the log entry. The corresponding Web Server can be found in the WebServers table.


domainName

The Domain Name that accesses the Web server. If the IP Address cannot be resolved, or if DNS Resolution is disabled, this value will default to the IP Address.


IPAddress

The TCP/IP address that accesses the Web server.


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.


firstHitTimestamp

The date and time of the first hit on the Web server.


lastHitTimestamp

The date and time of the last hit on the Web server.


hitsToDate

The total number of hits up to and including the present time.


bytesSentToDate

The total number of bytes sent up to and including the present time.


transferTimeToDate

The total time spent transmitting data up to and including the present time.


Home Page - Reports