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
67395PageHitService Request2018-04-24T17:28:40.003-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67394PageHit 2018-04-24T17:28:39.947-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.156.37.174web703
67393PageHit 2018-04-24T17:28:05.947-07:00CCBot/2.0 (http://commoncrawl.org/faq/)default.aspx54.156.37.174web703
67392ErrorError 4042018-04-24T17:28:05.627-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.156.37.174web703
67391PageHitService Request2018-04-24T16:55:23.23-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67390PageHit 2018-04-24T16:55:23.007-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0LogViewer_ws.aspx82.211.24.92web703
67389PageHitService Request2018-04-24T16:34:03.597-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67388PageHit 2018-04-24T16:34:03.543-07:00Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36LogViewer_ws.aspx79.115.13.198web703
67387PageHitService Request2018-04-24T15:54:23.543-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67386PageHit 2018-04-24T15:54:23.353-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like GeckoLogViewer_ws.aspx188.240.208.26web703
67385PageHit 2018-04-24T14:55:47.687-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36default.aspx54.67.59.131web703
67384PageHit 2018-04-24T13:45:41.237-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Default.aspx77.88.5.46web703
67383ErrorError 4042018-04-24T13:45:37.75-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.46web703
67382PageHitService Request2018-04-24T13:05:32.677-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67381PageHit 2018-04-24T13:05:32.433-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36LogViewer_ws.aspx198.20.167.55web703
67380ErrorError 4042018-04-24T12:52:15.65-07:00Mozilla/5.0 (compatible; SemrushBot/1.2~bl; +http://www.semrush.com/bot.html)Error404.aspx46.229.168.81web703
67379PageHit 2018-04-24T12:25:57.46-07:00Mozilla/5.0 (Windows NT 5.1; rv:9.0.1) Gecko/20100101 Firefox/9.0.1default.aspx176.210.80.31web703
67378PageHit 2018-04-24T11:46:13.52-07:00Xenu Link Sleuth/1.3.8default.aspx5.89.36.212web703
67377PageHitService Request2018-04-24T11:45:43.14-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67376PageHit 2018-04-24T11:45:42.83-07:00Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36LogViewer_ws.aspx103.47.132.28web703
67375ErrorError 4042018-04-24T11:28:47.063-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36Error404.aspx123.125.67.219web703
67374PageHit 2018-04-24T10:52:47.42-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx5.255.250.118web703
67373ErrorError 4042018-04-24T10:52:43.83-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.46web703
67372ErrorError 4042018-04-24T10:29:48.603-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx5.255.250.118web703
67371PageHit 2018-04-24T09:44:42.14-07:00Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36BlackScholes_European_Silverlight.aspx212.22.85.235web703
67370PageHitService Request2018-04-24T09:44:41.253-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67369PageHit 2018-04-24T09:44:41.16-07:00Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36LogViewer_ws.aspx212.22.85.235web703
67368ErrorError 4042018-04-24T08:50:26.863-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36Error404.aspx184.152.9.25web703
67367PageHit 2018-04-24T08:50:20.96-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36default.aspx184.152.9.25web703
67366PageHit 2018-04-24T08:24:40.407-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36BlackScholes_European_Silverlight.aspx42.114.229.212web703
67365PageHitService Request2018-04-24T08:24:39.567-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67364PageHit 2018-04-24T08:24:39.347-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36LogViewer_ws.aspx42.114.229.212web703
67363PageHit 2018-04-24T08:20:33.59-07:00Mozilla/5.0 (compatible; AlphaBot/3.2; +http://alphaseobot.com/bot.html)default.aspx23.237.4.26web703
67362PageHit 2018-04-24T06:48:17.467-07:00Mozilla/5.0 (compatible; MojeekBot/0.6; +https://www.mojeek.com/bot.html)CodeDotNetApp.aspx5.102.173.71web703
67361ErrorError 4042018-04-24T06:48:16.9-07:00Mozilla/5.0 (compatible; MojeekBot/0.6; +https://www.mojeek.com/bot.html)Error404.aspx5.102.173.71web703
67360PageHitService Request2018-04-24T05:32:14.283-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67359PageHit 2018-04-24T05:32:14.223-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36 OPR/49.0.2725.64LogViewer_ws.aspx118.96.138.80web703
67358PageHitService Request2018-04-24T05:02:38.303-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67357PageHit 2018-04-24T05:02:37.847-07:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36LogViewer_ws.aspx103.10.52.83web703
67356PageHit 2018-04-24T04:38:28.32-07:00Mozilla/5.0 (compatible; Plukkie/1.6; http://www.botje.com/plukkie.htm)default.aspx93.180.64.220web703
67355ErrorError 4042018-04-24T04:38:27.847-07:00Mozilla/5.0 (compatible; Plukkie/1.6; http://www.botje.com/plukkie.htm)Error404.aspx93.180.64.220web703
67354PageHit 2018-04-24T04:19:13.803-07:00Go-http-client/1.1default.aspx51.15.70.23web703
67353PageHit 2018-04-24T04:17:55.913-07:00Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.99 Safari/533.4default.aspx88.151.101.15web703
67352PageHit 2018-04-24T04:17:52.337-07:00Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.99 Safari/533.4default.aspx88.151.101.15web703
67351PageHit 2018-04-24T04:17:32.54-07:00Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.99 Safari/533.4default.aspx88.151.101.15web703
67350PageHit 2018-04-24T04:17:27.913-07:00Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.99 Safari/533.4default.aspx88.151.101.15web703
67349PageHitService Request2018-04-24T03:16:11.103-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67348PageHit 2018-04-24T03:16:11.067-07:00Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0LogViewer_ws.aspx95.110.194.245web703
67347PageHit 2018-04-24T03:09:51.99-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36BlackScholes_European_Silverlight.aspx62.201.225.42web703
67346PageHitService Request2018-04-24T03:09:50.46-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67345PageHit 2018-04-24T03:09:50.217-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36LogViewer_ws.aspx62.201.225.42web703
67344PageHit 2018-04-24T02:48:41.987-07:00Mozilla/5.0 (iPhone; CPU iPhone OS 7_0 like Mac OS X) AppleWebKit/537.51.1 (KHTML, like Gecko) Version/7.0 Mobile/11A465 Safari/9537.53 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)default.aspx40.77.167.5web703
67343ErrorError 4042018-04-24T01:44:19.087-07:00Mozilla/5.0 (compatible; DotBot/1.1; http://www.opensiteexplorer.org/dotbot, help@moz.com)Error404.aspx216.244.66.246web703
67342PageHitService Request2018-04-24T01:28:58.943-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67341PageHit 2018-04-24T01:28:58.723-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like GeckoLogViewer_ws.aspx107.172.206.3web703
67340PageHit 2018-04-24T00:02:43.66-07:00Mozilla/5.0 (iPhone; CPU iPhone OS 7_0 like Mac OS X) AppleWebKit/537.51.1 (KHTML, like Gecko) Version/7.0 Mobile/11A465 Safari/9537.53 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)USPS_ZipCodeLookup.aspx157.55.39.134web703
67339PageHitService Request2018-04-23T23:24:40.933-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67338PageHit 2018-04-23T23:24:40.91-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36LogViewer_ws.aspx123.17.134.87web703
67337PageHitService Request2018-04-23T23:06:14.597-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67336PageHit 2018-04-23T23:06:14.327-07:00Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0LogViewer_ws.aspx180.211.191.74web703
67335PageHitService Request2018-04-23T22:26:10.827-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67334PageHit 2018-04-23T22:26:10.803-07:00Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36LogViewer_ws.aspx115.73.14.213web703
67333PageHitService Request2018-04-23T22:09:14.037-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67332PageHit 2018-04-23T22:09:13.973-07:00Mozilla/5.0 (Windows NT 6.1; rv:57.0) Gecko/20100101 Firefox/57.0LogViewer_ws.aspx165.231.234.120web703
67331PageHit 2018-04-23T21:36:17.337-07:00Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1default.aspx118.24.1.220web703
67330PageHit 2018-04-23T21:36:13.773-07:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)Chrome/37.0.2062.124 Safari/537.36default.aspx118.24.1.220web703
67329PageHitService Request2018-04-23T21:32:17.837-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67328PageHit 2018-04-23T21:32:17.57-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36LogViewer_ws.aspx175.138.73.70web703
67327ErrorError 4042018-04-23T20:52:10.1-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx40.77.167.3web703
67326PageHit 2018-04-23T20:51:58.45-07:00Mozilla/5.0 (iPhone; CPU iPhone OS 7_0 like Mac OS X) AppleWebKit/537.51.1 (KHTML, like Gecko) Version/7.0 Mobile/11A465 Safari/9537.53 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)default.aspx40.77.167.5web703
67325ErrorError 4042018-04-23T20:51:56.43-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.14web703
67324PageHitService Request2018-04-23T20:27:35.683-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67323PageHit 2018-04-23T20:27:35.633-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36LogViewer_ws.aspx80.241.47.126web703
67322PageHitService Request2018-04-23T19:59:53.45-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67321PageHit 2018-04-23T19:59:53.257-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36 OPR/49.0.2725.64LogViewer_ws.aspx101.96.120.28web703
67320PageHit 2018-04-23T19:39:28.52-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0default.aspx163.172.4.153web703
67319ErrorError 4042018-04-23T19:11:48.403-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.117web703
67318PageHitService Request2018-04-23T18:11:50.883-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67317PageHit 2018-04-23T18:11:50.593-07:00Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0LogViewer_ws.aspx104.202.42.97web703
67316PageHit 2018-04-23T16:48:07.19-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36blackscholes_european_lookup.aspx35.195.25.199web703
67315PageHit 2018-04-23T16:47:53.96-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36default.aspx35.195.25.199web703
67314PageHit 2018-04-23T16:47:53.54-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36blackscholes_european_silverlight.aspx35.195.25.199web703
67313PageHitService Request2018-04-23T16:47:53.49-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
67312PageHit 2018-04-23T16:47:53.343-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36logviewer_ws.aspx35.195.25.199web703
67311PageHit 2018-04-23T16:47:52.39-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36usps_citystatelookup.aspx35.195.25.199web703
67310PageHit 2018-04-23T16:47:45.01-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36usps_zipcodelookup.aspx35.195.25.199web703
67309PageHit 2018-04-23T16:47:44.68-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36aboutme.aspx35.195.25.199web703
67307ArchiveLog archived2018-04-23T16:47:01.603-07:00NANANANA
67308PageHit 2018-04-23T16:47:01.603-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36default.aspx35.195.25.199web703