URLs Table


URLs are Uniform Resource Locators. These are used to locate files on various servers. The URLs table contains detailed information on each URL that is accessed. This information is summarized in the URLs Summary Table to allow a variety of statistical reports to be generated.



Columns
URLID
webServerID
URL
URLExtension
URLBytes
URLLogEnable
firstHitTimestamp
lastHitTimestamp
hitsToDate
bytesSentToDate
transferTimeToDate





Indices

Unique
  1. URLID


Non-Unique
  1. webServerID, URL
  2. URLExtension


Column Definitions

URLID

The unique ID of the URL affected.


webServerID

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


URL

The URL address.


URLExtension

The extension tag provided after a URL (eg: *.html, *.gif).


URLBytes

The number of bytes contained in a URL.


URLLogEnable

Used by URL Filtering, this boolean column contains either a True or False value.


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