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
31491PageHitService Request2017-05-27T10:30:54.947-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31490PageHit 2017-05-27T10:30:54.94-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.81.44.47web703
31489PageHit 2017-05-27T10:30:35.91-07:00CCBot/2.0 (http://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx54.81.44.47web703
31488PageHit 2017-05-27T10:30:26.63-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_Silverlight.aspx54.81.44.47web703
31487PageHit 2017-05-27T10:30:06.293-07:00CCBot/2.0 (http://commoncrawl.org/faq/)CodeDotNetApp.aspx54.81.44.47web703
31486PageHit 2017-05-27T10:29:56.827-07:00CCBot/2.0 (http://commoncrawl.org/faq/)AboutMe.aspx54.81.44.47web703
31485ErrorError 4042017-05-27T10:29:56.533-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.81.44.47web703
31484PageHitService Request2017-05-27T10:22:11.887-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31483PageHit 2017-05-27T10:22:11.527-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)LogViewer_ws.aspx77.75.77.119web703
31482ErrorError 4042017-05-27T10:22:08.76-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.77.119web703
31481PageHit 2017-05-27T10:13:09.827-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36default.aspx202.46.50.159web703
31480PageHitService Request2017-05-27T09:27:40.25-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31479PageHit 2017-05-27T09:27:40.24-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx23.104.162.48web703
31478PageHitService Request2017-05-27T09:22:12.347-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31477PageHit 2017-05-27T09:22:12.337-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx118.172.45.192web703
31476PageHitService Request2017-05-27T09:19:26.007-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31475PageHit 2017-05-27T09:19:25.997-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)LogViewer_ws.aspx100.43.85.4web703
31474ErrorError 4042017-05-27T09:19:22.027-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx84.201.133.33web703
31473PageHitService Request2017-05-27T09:01:46.24-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31472PageHit 2017-05-27T09:01:45.887-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx5.135.96.54web703
31471ErrorError 4042017-05-27T08:30:40.327-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.76.165web703
31470ErrorError 4042017-05-27T07:35:42.62-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31469ErrorError 4042017-05-27T07:35:41.74-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31468ErrorError 4042017-05-27T07:35:40.823-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31467ErrorError 4042017-05-27T07:35:39.94-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31466ErrorError 4042017-05-27T07:35:39.073-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31465ErrorError 4042017-05-27T07:35:38.197-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31464ErrorError 4042017-05-27T07:35:37.313-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31463ErrorError 4042017-05-27T07:35:36.44-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31462ErrorError 4042017-05-27T07:35:35.55-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31461ErrorError 4042017-05-27T07:35:34.683-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31460ErrorError 4042017-05-27T07:35:33.803-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31459PageHit 2017-05-27T07:35:32.723-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32default.aspx202.29.172.145web703
31458ErrorError 4042017-05-27T07:35:31.837-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 OPR/36.0.2130.32Error404.aspx202.29.172.145web703
31457PageHit 2017-05-27T07:31:29.133-07:00Mozilla/5.0 (compatible; Plukkie/1.6; http://www.botje.com/plukkie.htm)default.aspx93.180.64.220web703
31456ErrorError 4042017-05-27T07:31:28.683-07:00Mozilla/5.0 (compatible; Plukkie/1.6; http://www.botje.com/plukkie.htm)Error404.aspx93.180.64.220web703
31455PageHitService Request2017-05-27T07:20:56.983-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31454PageHit 2017-05-27T07:20:56.57-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx101.109.99.212web703
31453ErrorError 4042017-05-27T07:10:13.957-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.78.160web703
31452PageHitService Request2017-05-27T06:38:01.697-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31451PageHit 2017-05-27T06:38:01.557-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx62.210.80.59web703
31450PageHitService Request2017-05-27T05:41:43.947-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31449PageHit 2017-05-27T05:41:43.607-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx118.71.59.156web703
31448PageHitService Request2017-05-27T04:12:21.593-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31447PageHit 2017-05-27T04:12:21.257-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx199.231.215.69web703
31446ErrorError 4042017-05-27T03:36:40.653-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.76.164web703
31445ErrorError 4042017-05-27T03:10:43.5-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.19web703
31444PageHit 2017-05-27T03:10:29.473-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)USPS_ZipCodeLookup.aspx40.77.167.52web703
31443PageHitService Request2017-05-27T02:31:49.733-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31442PageHit 2017-05-27T02:31:45.26-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx113.130.125.162web703
31441ErrorError 4042017-05-27T01:42:39.687-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.76.168web703
31440PageHitService Request2017-05-26T23:23:46.37-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31439PageHit 2017-05-26T23:23:46.227-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx1.1.248.245web703
31438PageHitService Request2017-05-26T22:45:59.293-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31437PageHit 2017-05-26T22:45:59.28-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx118.172.22.66web703
31436ErrorError 4042017-05-26T22:43:08.49-07:00Mozilla/5.0 (compatible, MSIE 11, Windows NT 6.3; Trident/7.0; rv:11.0) like GeckoError404.aspx185.117.154.64web703
31435ErrorError 4042017-05-26T22:43:08.49-07:00Mozilla/5.0 (compatible, MSIE 11, Windows NT 6.3; Trident/7.0; rv:11.0) like GeckoError404.aspx185.117.154.64web703
31434ErrorError 4042017-05-26T22:43:08.487-07:00Mozilla/5.0 (compatible, MSIE 11, Windows NT 6.3; Trident/7.0; rv:11.0) like GeckoError404.aspx185.117.154.64web703
31433ErrorError 4042017-05-26T22:43:08.483-07:00Mozilla/5.0 (compatible, MSIE 11, Windows NT 6.3; Trident/7.0; rv:11.0) like GeckoError404.aspx185.117.154.64web703
31432ErrorError 4042017-05-26T22:43:08.48-07:00Mozilla/5.0 (compatible, MSIE 11, Windows NT 6.3; Trident/7.0; rv:11.0) like GeckoError404.aspx185.117.154.64web703
31431PageHitService Request2017-05-26T22:40:24.65-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31430PageHit 2017-05-26T22:40:24.32-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx52.27.78.36web703
31429ErrorError 4042017-05-26T22:12:19.793-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx207.46.13.179web703
31428ErrorError 4042017-05-26T22:12:19.66-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx207.46.13.179web703
31427ErrorError 4042017-05-26T22:12:19.517-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx207.46.13.179web703
31426ErrorError 4042017-05-26T22:12:19.38-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx207.46.13.179web703
31425PageHit 2017-05-26T22:12:10.777-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.31web703
31424PageHitService Request2017-05-26T21:22:57.603-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31423PageHit 2017-05-26T21:22:57.457-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx1.1.248.245web703
31422PageHitService Request2017-05-26T20:40:48.947-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31421PageHit 2017-05-26T20:40:48.587-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx165.231.96.197web703
31420PageHitService Request2017-05-26T20:15:53.137-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31419PageHit 2017-05-26T20:15:52.973-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx144.217.90.243web703
31418PageHit 2017-05-26T19:33:54.287-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36default.aspx202.46.52.173web703
31417PageHit 2017-05-26T19:23:20.517-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36BlackScholes_European_Silverlight.aspx181.226.44.17web703
31416PageHitService Request2017-05-26T19:23:06.563-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31415PageHit 2017-05-26T19:23:06.213-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx181.226.44.17web703
31414ErrorError 4042017-05-26T18:02:33.997-07:00Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)Error404.aspx123.125.71.83web703
31413PageHitService Request2017-05-26T17:02:22.823-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31412PageHit 2017-05-26T17:02:22.417-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx118.172.22.66web703
31411ErrorError 4042017-05-26T16:12:11.58-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.85web703
31410PageHitService Request2017-05-26T15:58:05.2-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31409PageHit 2017-05-26T15:58:05.19-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.2.5 (KHTML, like Gecko) Version/8.0.2 Safari/600.2.5LogViewer_ws.aspx178.33.226.106web703
31408PageHitService Request2017-05-26T15:39:57.163-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
31406ArchiveLog archived2017-05-26T15:39:57.04-07:00NANANANA
31407PageHit 2017-05-26T15:39:57.04-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.2.5 (KHTML, like Gecko) Version/8.0.2 Safari/600.2.5LogViewer_ws.aspx107.175.81.38web703