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
393677PageHitService Request2014-09-02T23:57:30.57-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393676PageHit 2014-09-02T23:57:30.563-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx107.22.141.14web703
393675ErrorError 4042014-09-02T23:57:30.29-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx107.22.141.14web703
393674PageHitService Request2014-09-02T23:56:17.217-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393673PageHit 2014-09-02T23:56:17.213-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0LogViewer_ws.aspx192.64.55.136web703
393672PageHitService Request2014-09-02T23:54:55.777-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393671PageHit 2014-09-02T23:54:55.417-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:20.0) Gecko/20100101 Firefox/20.0LogViewer_ws.aspx189.1.97.44web703
393670PageHitService Request2014-09-02T23:51:07.08-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393669PageHit 2014-09-02T23:51:07.077-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:20.0) Gecko/20100101 Firefox/20.0LogViewer_ws.aspx189.1.97.44web703
393666PageHit 2014-09-02T23:49:14.3-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393667PageHit 2014-09-02T23:49:14.3-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393668PageHitHaKijEFlZWb;OuemjWouGh;New York;NY2014-09-02T23:49:14.3-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393665PageHit 2014-09-02T23:49:14.3-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393663PageHit 2014-09-02T23:49:13.383-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393664PageHitVOXueDjbuYez;OJwNtqLEYmAqiAvDd;New York;NY2014-09-02T23:49:13.383-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393661PageHit 2014-09-02T23:49:13.38-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393662PageHit 2014-09-02T23:49:13.38-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393658PageHit 2014-09-02T23:49:12.38-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393659PageHit 2014-09-02T23:49:12.38-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393660PageHitiQYTOhMGLZu;kLpNKSuddkooO;New York;NY2014-09-02T23:49:12.38-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393657PageHit 2014-09-02T23:49:12.377-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393656PageHitxOnDbdDVxXcDd;AyPCDXqlbCkhHVYaZJs;New York;NY2014-09-02T23:49:11.54-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393655PageHit 2014-09-02T23:49:11.537-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393654PageHit 2014-09-02T23:49:11.533-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393653PageHit 2014-09-02T23:49:11.527-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393651PageHit 2014-09-02T23:49:10.42-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393652PageHitpwEgFRmPWay;ICAFOXwMZeqCM;New York;NY2014-09-02T23:49:10.42-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393649PageHit 2014-09-02T23:49:10.417-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393650PageHit 2014-09-02T23:49:10.417-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393648PageHit 2014-09-02T23:49:09.727-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
393647PageHitService Request2014-09-02T23:47:53.947-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393646PageHit 2014-09-02T23:47:53.94-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:20.0) Gecko/20100101 Firefox/20.0LogViewer_ws.aspx189.1.97.44web703
393645PageHit 2014-09-02T23:44:15.057-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0LogViewer.aspx192.64.55.136web703
393641PageHit 2014-09-02T23:43:39.76-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.142.194web703
393642PageHit 2014-09-02T23:43:39.76-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.142.194web703
393643PageHit 2014-09-02T23:43:39.76-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.142.194web703
393644PageHitLrOvPoMSAi;GtOZVbEjuDWbNIj;New York;NY2014-09-02T23:43:39.76-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.142.194web703
393640PageHit 2014-09-02T23:43:39.167-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.142.194web703
393639PageHitService Request2014-09-02T23:39:25.467-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393638PageHit 2014-09-02T23:39:25.46-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0LogViewer_ws.aspx192.64.55.136web703
393637PageHitService Request2014-09-02T23:35:13.817-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393636PageHit 2014-09-02T23:35:13.813-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:20.0) Gecko/20100101 Firefox/20.0LogViewer_ws.aspx58.55.127.198web703
393635PageHitService Request2014-09-02T23:28:58.677-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4252)LogViewer_ws.asmx209.67.188.9web703
393634PageHit 2014-09-02T23:28:58.67-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:20.0) Gecko/20100101 Firefox/20.0LogViewer_ws.aspx118.97.32.226web703
393633PageHit 2014-09-02T23:26:58.513-07:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0LogViewer.aspx192.64.55.136web703
393630PageHit 2014-09-02T23:26:27.203-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393631PageHit 2014-09-02T23:26:27.203-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393632PageHitxuKsZVVPOXRAJLuclX;IdGuiTvHmENU;New York;NY2014-09-02T23:26:27.203-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393629PageHit 2014-09-02T23:26:27.2-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393626PageHit 2014-09-02T23:26:26.373-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393627PageHit 2014-09-02T23:26:26.373-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393628PageHitexkXREuShSZvk;CsRMnpZfGgRyRmfColw;New York;NY2014-09-02T23:26:26.373-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393625PageHit 2014-09-02T23:26:26.37-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393622PageHit 2014-09-02T23:26:25.7-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393623PageHit 2014-09-02T23:26:25.7-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393624PageHitfvSYdwWnouWlJV;TogFjsbVsK;New York;NY2014-09-02T23:26:25.7-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393621PageHit 2014-09-02T23:26:25.697-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393620PageHitJsluNGZodyXB;fhGkHCndlkx;New York;NY2014-09-02T23:26:24.95-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393619PageHit 2014-09-02T23:26:24.94-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393618PageHit 2014-09-02T23:26:24.93-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393617PageHit 2014-09-02T23:26:24.92-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393616PageHitjwQaKTjUJznZo;ilApkvXVpRSru;New York;NY2014-09-02T23:26:23.477-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393613PageHit 2014-09-02T23:26:23.473-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393614PageHit 2014-09-02T23:26:23.473-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393615PageHit 2014-09-02T23:26:23.473-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393612PageHitQggnWKgHVXqCfsWswm;VHBaMwIrDzjnBDSDTQ;New York;NY2014-09-02T23:26:23.463-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393611PageHit 2014-09-02T23:26:23.46-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393610PageHit 2014-09-02T23:26:23.437-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393609PageHit 2014-09-02T23:26:23.387-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393608PageHit 2014-09-02T23:26:22.883-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.187.89.77web703
393606PageHit 2014-09-02T23:26:22.57-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393607PageHitQecNadUjExYzriDw;qyfGUxqKrezU;New York;NY2014-09-02T23:26:22.57-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393605PageHit 2014-09-02T23:26:22.567-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393604PageHit 2014-09-02T23:26:22.56-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393603PageHitVAQuYMnxNZHFTsl;gsvMlMkNUtFDC;New York;NY2014-09-02T23:26:21.747-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393600PageHit 2014-09-02T23:26:21.743-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393601PageHit 2014-09-02T23:26:21.743-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393602PageHit 2014-09-02T23:26:21.743-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393598PageHit 2014-09-02T23:26:20.947-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393599PageHituIIOwTnOkTMGZn;uSRvqSLkwQkxhvUuuSH;New York;NY2014-09-02T23:26:20.947-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393596PageHit 2014-09-02T23:26:20.943-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393597PageHit 2014-09-02T23:26:20.943-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393594PageHit 2014-09-02T23:26:19.787-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393595PageHitbWbEDLYGbEVClWdRRW;VlLjYdGGVtsYfhfvAHo;New York;NY2014-09-02T23:26:19.787-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393592PageHit 2014-09-02T23:26:19.783-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393593PageHit 2014-09-02T23:26:19.783-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393591PageHit 2014-09-02T23:26:19.093-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.78.209web703
393590ArchiveLog archived2014-09-02T23:22:23.773-07:00NANANANA