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
72089PageHitService Request2018-06-23T05:10:41.507-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72088PageHit 2018-06-23T05:10:41.13-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.224.255.17web703
72087PageHit 2018-06-23T05:10:30-07:00CCBot/2.0 (http://commoncrawl.org/faq/)default.aspx54.224.255.17web703
72086ErrorError 4042018-06-23T05:10:29.697-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.224.255.17web703
72085ErrorError 4042018-06-23T01:58:51.807-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx5.255.250.47web703
72084ErrorError 4042018-06-23T01:39:34.33-07:00Mozilla/5.0 (compatible; ExtLinksBot/1.5; +https://extlinks.com/Bot.html)Error404.aspx142.4.200.37web703
72083PageHitService Request2018-06-23T01:07:22.63-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72082PageHit 2018-06-23T01:07:22.447-07:00Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101 Firefox/52.0LogViewer_ws.aspx196.245.218.133web703
72081ErrorError 4042018-06-22T23:48:50.693-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.145web703
72080PageHit 2018-06-22T23:38:07.563-07:00MauiBot (crawler.feedback+wc@gmail.com)BlackScholes_European.aspx18.233.63.172web703
72079PageHit 2018-06-22T23:38:07.283-07:00MauiBot (crawler.feedback+wc@gmail.com)AboutMe.aspx18.233.63.172web703
72078PageHitService Request2018-06-22T23:37:05.84-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72077PageHit 2018-06-22T23:37:04.567-07:00MauiBot (crawler.feedback+wc@gmail.com)LogViewer_ws.aspx18.233.63.172web703
72076PageHit 2018-06-22T23:37:04.317-07:00MauiBot (crawler.feedback+wc@gmail.com)BlackScholes_European_Lookup.aspx18.233.63.172web703
72075PageHit 2018-06-22T23:37:04.057-07:00MauiBot (crawler.feedback+wc@gmail.com)USPS_CityStateLookup.aspx18.233.63.172web703
72074PageHit 2018-06-22T23:36:33.807-07:00MauiBot (crawler.feedback+wc@gmail.com)USPS_ZipCodeLookup.aspx18.233.63.172web703
72073PageHit 2018-06-22T23:36:33.29-07:00MauiBot (crawler.feedback+wc@gmail.com)CodeDotNetApp.aspx18.233.63.172web703
72072PageHit 2018-06-22T23:36:33.037-07:00MauiBot (crawler.feedback+wc@gmail.com)LogViewer_Silverlight.aspx18.233.63.172web703
72071PageHit 2018-06-22T23:36:02.78-07:00MauiBot (crawler.feedback+wc@gmail.com)BlackScholes_European_Silverlight.aspx18.233.63.172web703
72070PageHit 2018-06-22T23:36:01.78-07:00MauiBot (crawler.feedback+wc@gmail.com)Default.aspx18.233.63.172web703
72069PageHit 2018-06-22T23:35:30.723-07:00MauiBot (crawler.feedback+wc@gmail.com)default.aspx18.233.63.172web703
72068ErrorError 4042018-06-22T23:35:30.43-07:00MauiBot (crawler.feedback+wc@gmail.com)Error404.aspx18.233.63.172web703
72067PageHitService Request2018-06-22T22:01:03.223-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72066PageHit 2018-06-22T22:01:03.007-07:00Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36LogViewer_ws.aspx193.0.217.18web703
72065ErrorError 4042018-06-22T21:48:36.963-07:00Mozilla/5.0 (Windows NT 6.1; rv:34.0) Gecko/20100101 Firefox/34.0Error404.aspx193.106.30.99web703
72064PageHit 2018-06-22T21:45:29.893-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.aspx5.9.10.150web703
72063PageHit 2018-06-22T21:45:21.42-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.aspx5.9.10.150web703
72062PageHit 2018-06-22T20:50:36.843-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36LogViewer_Silverlight.aspx202.46.52.161web703
72061PageHitService Request2018-06-22T20:40:26.293-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72060PageHit 2018-06-22T20:40:25.917-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36 OPR/49.0.2725.47LogViewer_ws.aspx46.161.9.3web703
72059ErrorError 4042018-06-22T20:29:27.987-07:00Mozilla/5.0 (compatible; DuckDuckGo-Favicons-Bot/1.0; +http://duckduckgo.com)Error404.aspx107.21.1.8web703
72058PageHit 2018-06-22T20:29:26.75-07:00Mozilla/5.0 (compatible; DuckDuckGo-Favicons-Bot/1.0; +http://duckduckgo.com)default.aspx107.21.1.8web703
72057PageHit 2018-06-22T20:23:37.07-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx106.38.241.128web703
72056ErrorError 4042018-06-22T20:23:36.407-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx106.38.241.128web703
72055PageHit 2018-06-22T20:10:54.86-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx93.158.161.200web703
72054ErrorError 4042018-06-22T20:10:40.73-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.200web703
72053PageHit 2018-06-22T18:53:23.903-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.aspx157.55.39.95web703
72052ErrorError 4042018-06-22T18:53:05.59-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.46web703
72051PageHitService Request2018-06-22T17:37:14.92-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72050PageHit 2018-06-22T17:37:14.62-07:00Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36LogViewer_ws.aspx154.16.53.214web703
72049ErrorError 4042018-06-22T17:04:35.59-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.190web703
72048ErrorError 4042018-06-22T17:04:35.433-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.190web703
72047ErrorError 4042018-06-22T17:04:35.28-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.190web703
72046ErrorError 4042018-06-22T17:04:35.12-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.190web703
72045ErrorError 4042018-06-22T17:04:34.863-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.190web703
72044PageHit 2018-06-22T17:04:30.953-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.214web703
72043ErrorError 4042018-06-22T14:17:40.53-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx84.201.133.10web703
72042ErrorError 4042018-06-22T12:43:48.66-07:00Mozilla/5.0 (compatible; MJ12bot/v1.4.7; http://www.majestic12.co.uk/bot.php?+)Error404.aspx178.128.171.101web703
72041PageHitService Request2018-06-22T10:40:04.06-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72040PageHit 2018-06-22T10:40:03.73-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.aspx82.193.109.241web703
72039ErrorError 4042018-06-22T09:48:52.783-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
72038PageHit 2018-06-22T08:16:32.1-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.aspx207.46.13.3web703
72037ErrorError 4042018-06-22T08:14:27.8-07:00Mozilla/5.0 (Windows NT 6.1; rv:34.0) Gecko/20100101 Firefox/34.0Error404.aspx193.106.30.99web703
72036PageHit 2018-06-22T07:28:16.127-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)BlackScholes_European_Lookup.aspx40.77.167.124web703
72035PageHit 2018-06-22T03:49:19.9-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.aspx52.53.201.78web703
72034PageHit 2018-06-22T03:33:03.807-07:00Mozilla/5.0 (compatible; Linux x86_64; Meta_Bot/1.1)default.aspx46.229.170.193web703
72033PageHit 2018-06-22T03:10:40.917-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Default.aspx5.255.250.113web703
72032PageHit 2018-06-22T02:32:37.553-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36AboutMe.aspx202.46.48.141web703
72031PageHit 2018-06-22T02:10:31.353-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx141.8.143.196web703
72030PageHit 2018-06-22T02:10:28.25-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx100.43.85.168web703
72029ErrorError 4042018-06-22T02:10:27.567-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx5.255.250.39web703
72028PageHit 2018-06-22T02:00:23.397-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx5.255.250.39web703
72027ErrorError 4042018-06-22T02:00:18.657-07:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx5.255.250.113web703
72026ErrorError 4042018-06-22T01:27:56.213-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.117web703
72025PageHit 2018-06-22T01:21:03.947-07:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36LogViewer_Silverlight.aspx202.46.54.109web703
72024PageHitService Request2018-06-22T00:37:14.44-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72023PageHit 2018-06-22T00:37:14.23-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.aspx49.146.9.11web703
72022ErrorError 4042018-06-21T22:42:17.38-07:00Mozilla/5.0 (compatible; AhrefsBot/5.2; +http://ahrefs.com/robot/)Error404.aspx54.36.150.40web703
72021PageHit 2018-06-21T22:39:46.46-07:00Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36default.aspx163.172.4.153web703
72020PageHitService Request2018-06-21T22:07:37.443-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72019PageHit 2018-06-21T22:07:37.247-07:00Mozilla/5.0 (Windows NT 6.0; Win64; rv:35.0) Gecko/20100101 Firefox/35.0LogViewer_ws.aspx46.161.9.56web703
72018PageHit 2018-06-21T21:36:38.42-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)blackscholes_european_silverlight.aspx40.77.167.124web703
72017ErrorError 4042018-06-21T21:09:16.107-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.aspx185.229.190.173web703
72016PageHit 2018-06-21T20:22:27.817-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx106.38.241.108web703
72015ErrorError 4042018-06-21T20:22:27.187-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx106.38.241.108web703
72014PageHit 2018-06-21T20:07:27.43-07:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36; 360Spiderdefault.aspx42.236.99.72web703
72013PageHit 2018-06-21T20:04:19.223-07:00CCBot/2.0 (http://commoncrawl.org/faq/)USPS_CityStateLookup.aspx54.224.235.183web703
72012ErrorError 4042018-06-21T20:04:18.927-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.224.235.183web703
72011PageHitService Request2018-06-21T19:01:53.747-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36415)LogViewer_ws.asmx209.67.188.9web703
72010PageHit 2018-06-21T19:01:52.46-07:00Mozilla/5.0 (Windows NT 7.1; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0LogViewer_ws.aspx46.161.9.56web703
72009ErrorError 4042018-06-21T18:24:53.21-07:00Mozilla/5.0 (Windows NT 6.1; rv:34.0) Gecko/20100101 Firefox/34.0Error404.aspx193.106.30.99web703
72007ArchiveLog archived2018-06-21T14:02:56.057-07:00NANANANA
72008PageHit 2018-06-21T14:02:56.057-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx66.249.79.121web703