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
939256PageHitService Request2015-03-01T16:53:41.327-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
939255PageHit 2015-03-01T16:53:41.32-08:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.144.237.48web703
939254ErrorError 4042015-03-01T16:53:41.057-08:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.144.237.48web703
939253PageHitService Request2015-03-01T16:47:38.547-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
939252PageHit 2015-03-01T16:47:38.54-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.4.600 Chrome/30.0.1599.101 Safari/537.36LogViewer_ws.aspx107.158.40.72web703
939251PageHitService Request2015-03-01T16:46:14.843-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
939250PageHit 2015-03-01T16:46:14.643-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Maxthon/4.4.3.4000 Chrome/30.0.1599.101 Safari/537.36LogViewer_ws.aspx69.12.81.131web703
939249ErrorError 4042015-03-01T16:42:04.417-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.125web703
939248PageHit 2015-03-01T16:38:20.843-08:00Mozilla/5.0 (iPhone; CPU iPhone OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5376e Safari/8536.25 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx66.249.69.239web703
939247PageHitECsIIZFTIZEEwshvbJ;kPWABymFEBxF;New York;NY2015-03-01T16:35:55.63-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939246PageHit 2015-03-01T16:35:55.617-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939245PageHit 2015-03-01T16:35:55.603-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939244PageHit 2015-03-01T16:35:55.593-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939241PageHit 2015-03-01T16:35:54.89-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939242PageHit 2015-03-01T16:35:54.89-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939243PageHitDMeMyZnTHHFwUEHDzWw;tmpJIERuBNYh;New York;NY2015-03-01T16:35:54.89-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939240PageHit 2015-03-01T16:35:54.887-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939239PageHitvceYhjHZcx;pvhMkSzOUecefRZa;New York;NY2015-03-01T16:35:54.16-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939237PageHit 2015-03-01T16:35:54.157-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939238PageHit 2015-03-01T16:35:54.157-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939236PageHit 2015-03-01T16:35:54.153-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939235PageHitfYPBRfJRaJ;EJUqYrhDPATN;New York;NY2015-03-01T16:35:53.313-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939234PageHit 2015-03-01T16:35:53.31-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939233PageHit 2015-03-01T16:35:53.307-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939232PageHit 2015-03-01T16:35:53.303-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939229PageHit 2015-03-01T16:35:52.44-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939230PageHit 2015-03-01T16:35:52.44-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939231PageHitIyDGoFMsrGuWIO;XKpcHxwuICiJkiBLC;New York;NY2015-03-01T16:35:52.44-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939228PageHit 2015-03-01T16:35:52.437-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939227PageHitaOqrqrdiXquBShNGi;mfrBOadTqbTArelpa;New York;NY2015-03-01T16:35:51.277-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939226PageHit 2015-03-01T16:35:51.267-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939225PageHit 2015-03-01T16:35:51.257-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939224PageHit 2015-03-01T16:35:51.25-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939223PageHitfEceCXggwXT;dGqQXbwpLnZwUZiC;New York;NY2015-03-01T16:35:50.393-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939222PageHit 2015-03-01T16:35:50.383-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939221PageHit 2015-03-01T16:35:50.373-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939220PageHit 2015-03-01T16:35:50.37-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939219PageHitmjEIytoOJfm;zcraSVcJmcJsZgmILzq;New York;NY2015-03-01T16:35:49.617-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939218PageHit 2015-03-01T16:35:49.607-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939217PageHit 2015-03-01T16:35:49.6-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939216PageHit 2015-03-01T16:35:49.597-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939215PageHitTnzHfedaoY;ScWwEeHTzHgaBWnu;New York;NY2015-03-01T16:35:48.767-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939214PageHit 2015-03-01T16:35:48.757-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939213PageHit 2015-03-01T16:35:48.743-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939212PageHit 2015-03-01T16:35:48.737-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939209PageHit 2015-03-01T16:35:47.703-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939210PageHit 2015-03-01T16:35:47.703-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939211PageHitwVLsELTEvrFH;lFHJsrBevVhFQN;New York;NY2015-03-01T16:35:47.703-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939208PageHit 2015-03-01T16:35:47.7-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939207PageHit 2015-03-01T16:35:47.073-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.213.170web703
939203PageHit 2015-03-01T16:24:40.53-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939204PageHit 2015-03-01T16:24:40.53-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939205PageHit 2015-03-01T16:24:40.53-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939206PageHitrLNaQkZGhgK;fBCdPjVJrk;New York;NY2015-03-01T16:24:40.53-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939199PageHit 2015-03-01T16:24:39.84-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939200PageHit 2015-03-01T16:24:39.84-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939201PageHit 2015-03-01T16:24:39.84-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939202PageHitQsKyunVDszDtCvrux;AXAXZDHkXjaShmN;New York;NY2015-03-01T16:24:39.84-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939198PageHitRufMNZbLOTpqtOgruM;IRxIWDsAcIC;New York;NY2015-03-01T16:24:39.033-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939197PageHit 2015-03-01T16:24:39.03-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939196PageHit 2015-03-01T16:24:39.02-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939195PageHit 2015-03-01T16:24:39.017-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939194PageHitphlhbOQTnKIytTdJat;KPvXEXXemxWzDiuqwc;New York;NY2015-03-01T16:24:37.84-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939193PageHit 2015-03-01T16:24:37.827-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939192PageHit 2015-03-01T16:24:37.813-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939191PageHit 2015-03-01T16:24:37.8-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939190PageHitkEewkXHlCHl;JMMwLKHmwGalZCUQHgc;New York;NY2015-03-01T16:24:36.787-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939189PageHit 2015-03-01T16:24:36.773-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939188PageHit 2015-03-01T16:24:36.76-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939187PageHit 2015-03-01T16:24:36.75-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939186PageHitrgQaCTKxTtYiW;ZBDaIuEkYoDx;New York;NY2015-03-01T16:24:35.983-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939183PageHit 2015-03-01T16:24:35.98-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939184PageHit 2015-03-01T16:24:35.98-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939185PageHit 2015-03-01T16:24:35.98-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939182PageHitbsyqzTaxZgelUNNWP;xnWfVPImcXp;New York;NY2015-03-01T16:24:35.29-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939181PageHit 2015-03-01T16:24:35.28-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939180PageHit 2015-03-01T16:24:35.273-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939179PageHit 2015-03-01T16:24:35.267-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939178PageHitBtbtNoDDolvbL;vfCQWAtZBtYJfofc;New York;NY2015-03-01T16:24:34.51-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939175PageHit 2015-03-01T16:24:34.507-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939176PageHit 2015-03-01T16:24:34.507-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939177PageHit 2015-03-01T16:24:34.507-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939174PageHitrfjPdauxYAEft;alPeMptsaEidkTawXEW;New York;NY2015-03-01T16:24:33.783-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939171PageHit 2015-03-01T16:24:33.78-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939172PageHit 2015-03-01T16:24:33.78-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939173PageHit 2015-03-01T16:24:33.78-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939170PageHitKcwMZvpKjcUPCHK;bXtizBusiC;New York;NY2015-03-01T16:24:32.89-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939169PageHit 2015-03-01T16:24:32.883-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939168PageHit 2015-03-01T16:24:32.873-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939167PageHit 2015-03-01T16:24:32.867-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939166PageHit 2015-03-01T16:24:32.047-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx94.23.222.184web703
939165ArchiveLog archived2015-03-01T16:10:28.293-08:00NANANANA