CodeDotNet

When building this site, one of the first elements I allocated time for was a logging feature, both to collect error information for debugging, as well as user information. Below is a view of the log data stored, but called from a web service, using a mixture of VB.NET to return the data and transform the XML, and ASP.NET to display it.



LogIDTypeTypeMessageTimeStampBrowserInfoPagePathIPAddressDNSName
1209949PageHitService Request2015-05-27T02:29:55.71-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
1209948PageHit 2015-05-27T02:29:55.587-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.147.220.66web703
1209947ErrorError 4042015-05-27T02:29:55.31-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.147.220.66web703
1209946PageHitORoSzQFezMPbL;EsaFEEmTgObjYo;New York;NY2015-05-27T02:29:17.2-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209945PageHit 2015-05-27T02:29:17.193-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209944PageHit 2015-05-27T02:29:17.183-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209943PageHit 2015-05-27T02:29:17.177-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209942PageHitlkvoqSTislkg;lNqSAASuIODJqedfUFz;New York;NY2015-05-27T02:29:14.107-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209941PageHit 2015-05-27T02:29:14.1-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209940PageHit 2015-05-27T02:29:14.09-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209939PageHit 2015-05-27T02:29:14.083-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209938PageHitWYqFzzdaxqOCSZB;VIHFLMSojrr;New York;NY2015-05-27T02:29:10.64-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209937PageHit 2015-05-27T02:29:10.63-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209936PageHit 2015-05-27T02:29:10.623-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209935PageHit 2015-05-27T02:29:10.617-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209932PageHit 2015-05-27T02:29:07.44-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209933PageHit 2015-05-27T02:29:07.44-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209934PageHitOOHyOZInSTzIFn;GhmMHodlffe;New York;NY2015-05-27T02:29:07.44-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209931PageHit 2015-05-27T02:29:07.437-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209927PageHit 2015-05-27T02:29:05.16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209928PageHit 2015-05-27T02:29:05.16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209929PageHit 2015-05-27T02:29:05.16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209930PageHitFdFIZzgnky;JBSTdWEYHILNGBatTnz;New York;NY2015-05-27T02:29:05.16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209925PageHit 2015-05-27T02:29:01.74-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209926PageHitXEFtldsvlQs;GPjazkNOgoAKJkbqrtl;New York;NY2015-05-27T02:29:01.74-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209923PageHit 2015-05-27T02:29:01.737-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209924PageHit 2015-05-27T02:29:01.737-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209919PageHit 2015-05-27T02:28:59.01-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209920PageHit 2015-05-27T02:28:59.01-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209921PageHit 2015-05-27T02:28:59.01-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209922PageHitXfokBnKXfWQe;gUOaMIdCwckUmErAZZ;New York;NY2015-05-27T02:28:59.01-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209916PageHit 2015-05-27T02:28:55.227-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209917PageHit 2015-05-27T02:28:55.227-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209918PageHitSqwNkIjJObCCKQ;gkkMoGokONzyqC;New York;NY2015-05-27T02:28:55.227-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209915PageHit 2015-05-27T02:28:55.223-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209913PageHit 2015-05-27T02:28:51.933-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209914PageHitoIwJCBNvaFtEGMpX;QFiPaIbNCjIOKOygf;New York;NY2015-05-27T02:28:51.933-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209911PageHit 2015-05-27T02:28:51.93-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209912PageHit 2015-05-27T02:28:51.93-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209909PageHit 2015-05-27T02:28:48.067-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209910PageHitglOqYwphkcikpi;STnnrYkACWoQDVinW;New York;NY2015-05-27T02:28:48.067-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209907PageHit 2015-05-27T02:28:48.063-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209908PageHit 2015-05-27T02:28:48.063-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209906PageHit 2015-05-27T02:28:45.153-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.143.232.40web703
1209905ArchiveLog archived2015-05-27T02:20:19.84-07:00NANANANA