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
50970PageHitService Request2017-11-17T09:31:39.793-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50969PageHit 2017-11-17T09:31:39.493-08:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.162.241.40web703
50968PageHit 2017-11-17T09:31:24.837-08:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_Silverlight.aspx54.162.241.40web703
50967PageHit 2017-11-17T09:31:10.47-08:00CCBot/2.0 (http://commoncrawl.org/faq/)BlackScholes_European_Silverlight.aspx54.162.241.40web703
50966PageHit 2017-11-17T09:30:20.79-08:00CCBot/2.0 (http://commoncrawl.org/faq/)USPS_ZipCodeLookup.aspx54.162.241.40web703
50965PageHit 2017-11-17T09:30:05.873-08:00CCBot/2.0 (http://commoncrawl.org/faq/)USPS_CityStateLookup.aspx54.162.241.40web703
50964PageHit 2017-11-17T09:29:49.727-08:00CCBot/2.0 (http://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx54.162.241.40web703
50963PageHit 2017-11-17T09:29:35.013-08:00CCBot/2.0 (http://commoncrawl.org/faq/)default.aspx54.162.241.40web703
50962ErrorError 4042017-11-17T09:29:34.71-08:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.162.241.40web703
50961PageHit 2017-11-17T08:58:51.503-08:00Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0default.aspx146.185.223.26web703
50960PageHit 2017-11-17T07:57:26.67-08:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36default.aspx202.46.54.199web703
50959PageHitService Request2017-11-17T07:53:20.997-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50958PageHit 2017-11-17T07:53:20.733-08:00Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.19) Gecko/20081217 K-Meleon/1.5.2LogViewer_ws.aspx174.139.205.218web703
50957ErrorError 4042017-11-17T07:51:52.867-08:00Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36Error404.aspx193.111.156.58web703
50956ErrorError 4042017-11-17T07:51:52.21-08:00Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36Error404.aspx193.111.156.58web703
50955PageHitService Request2017-11-17T06:31:52.907-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50954PageHit 2017-11-17T06:31:52.813-08:00Mozilla/5.0 (Windows; U; Windows NT 5.0; en) AppleWebKit/522.12.1 (KHTML, like Gecko) Version/3.0.1 Safari/522.12.2LogViewer_ws.aspx198.20.164.43web703
50953PageHitService Request2017-11-17T05:52:46.35-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50952PageHit 2017-11-17T05:52:46.34-08:00Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2pre) Gecko/20061230 Minefield/3.0a2preLogViewer_ws.aspx174.139.205.218web703
50951PageHitService Request2017-11-17T05:50:51.503-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50950PageHit 2017-11-17T05:50:51.203-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36LogViewer_ws.aspx103.12.161.11web703
50949ErrorError 4042017-11-17T03:12:32.64-08:00Mozilla/5.0 (compatible; SemrushBot/1.2~bl; +http://www.semrush.com/bot.html)Error404.aspx46.229.164.101web703
50948ErrorError 4042017-11-17T02:12:18.957-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36Error404.aspx85.17.26.8web703
50947ErrorError 4042017-11-17T02:12:18.077-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36Error404.aspx85.17.26.8web703
50946ErrorError 4042017-11-17T02:12:17.2-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36Error404.aspx85.17.26.8web703
50945PageHit 2017-11-17T02:03:00.83-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)USPS_ZipCodeLookup.aspx66.249.79.54web703
50944PageHit 2017-11-17T02:01:34.19-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)CodeDotNetApp.aspx66.249.79.48web703
50943PageHit 2017-11-17T02:01:09.66-08:00Mozilla/3.0 (compatible; WebCapture 2.0; Auto; Windows)default.aspx46.118.119.80web703
50942PageHit 2017-11-17T02:01:08.6-08:00Mozilla/3.0 (compatible; WebCapture 2.0; Auto; Windows)default.aspx46.118.119.80web703
50941PageHit 2017-11-17T02:01:07.14-08:00Mozilla/3.0 (compatible; WebCapture 2.0; Auto; Windows)default.aspx46.118.119.80web703
50940ErrorError 4042017-11-17T02:00:52.337-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36Error404.aspx54.162.189.59web703
50939PageHit 2017-11-17T02:00:51.39-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36default.aspx54.162.189.59web703
50938PageHit 2017-11-17T02:00:46.777-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Default.aspx66.249.79.48web703
50937PageHit 2017-11-17T01:54:57.077-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx66.249.79.54web703
50936PageHit 2017-11-17T00:47:25.87-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; TheFreeDictionary.com; .NET CLR 1.1.4322; .NET CLR 1.0.3705; .NET CLR 2.0.50727)default.aspx46.118.119.80web703
50935PageHit 2017-11-17T00:47:24.797-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; TheFreeDictionary.com; .NET CLR 1.1.4322; .NET CLR 1.0.3705; .NET CLR 2.0.50727)default.aspx46.118.119.80web703
50934PageHit 2017-11-17T00:47:23.85-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; TheFreeDictionary.com; .NET CLR 1.1.4322; .NET CLR 1.0.3705; .NET CLR 2.0.50727)default.aspx46.118.119.80web703
50933PageHit 2017-11-16T23:58:59.52-08:00Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)LogViewer_Silverlight.aspx66.249.79.54web703
50932PageHit 2017-11-16T23:21:26.81-08:00Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)BlackScholes_European_Silverlight.aspx66.249.79.48web703
50931PageHit 2017-11-16T22:59:24.647-08:00Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)AboutMe.aspx66.249.79.54web703
50930ErrorError 4042017-11-16T22:59:24.38-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.54web703
50929PageHit 2017-11-16T20:44:03.267-08:00Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)default.aspx134.249.80.20web703
50928PageHit 2017-11-16T20:44:02.073-08:00Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)default.aspx134.249.80.20web703
50927PageHit 2017-11-16T20:44:01.157-08:00Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)default.aspx134.249.80.20web703
50926PageHit 2017-11-16T19:26:13.923-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Opera 7.54 [en]default.aspx46.118.226.97web703
50925PageHit 2017-11-16T19:26:12.883-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Opera 7.54 [en]default.aspx46.118.226.97web703
50924PageHit 2017-11-16T19:26:11.767-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Opera 7.54 [en]default.aspx46.118.226.97web703
50923PageHit 2017-11-16T19:25:47.54-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Babya Discoverer 8.0:default.aspx46.118.226.97web703
50922PageHit 2017-11-16T19:25:46.147-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Babya Discoverer 8.0:default.aspx46.118.226.97web703
50921PageHit 2017-11-16T19:25:44.72-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Babya Discoverer 8.0:default.aspx46.118.226.97web703
50920PageHit 2017-11-16T19:24:59.15-08:00Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.21 (KHTML, like Gecko) Chrome/11.0.678.0 Safari/534.21default.aspx213.183.59.43web703
50919PageHit 2017-11-16T18:34:29.897-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0BlackScholes_European_Silverlight.aspx118.200.118.214web703
50918PageHitService Request2017-11-16T18:34:29.083-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50917PageHit 2017-11-16T18:34:29.07-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0LogViewer_ws.aspx118.200.118.214web703
50916PageHit 2017-11-16T18:30:27.56-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx77.88.47.18web703
50915PageHitService Request2017-11-16T18:13:13.143-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
50914PageHit 2017-11-16T18:13:13.123-08:00Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0LogViewer_ws.aspx204.44.112.196web703
50913PageHit 2017-11-16T17:53:10.417-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx5.255.250.53web703
50912PageHit 2017-11-16T17:53:09.487-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx141.8.144.6web703
50911ErrorError 4042017-11-16T17:53:06.017-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx5.255.250.118web703
50910ErrorError 4042017-11-16T17:53:05.29-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx84.201.133.72web703
50909PageHit 2017-11-16T17:47:00.47-08:00Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Geckodefault.aspx172.82.185.210web703
50907ArchiveLog archived2017-11-16T17:45:04.76-08:00NANANANA
50908PageHitService Request2017-11-16T17:45:04.76-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703