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
215697PageHitService Request2021-07-23T12:59:18.107-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)LogViewer_ws.asmx96.31.33.47Web810
215696PageHit 2021-07-23T12:59:16.33-07:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_ws.aspx18.207.250.137Web810
215695PageHit 2021-07-23T12:44:49.05-07:00CCBot/2.0 (https://commoncrawl.org/faq/)default.aspx18.207.250.137Web810
215694ErrorError 4042021-07-23T12:44:48.78-07:00CCBot/2.0 (https://commoncrawl.org/faq/)Error404.aspx18.207.250.137Web810
215693ErrorError 4042021-07-23T12:16:36.04-07:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx8.142.31.111Web810
215692PageHit 2021-07-23T12:15:26.433-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)default.aspx54.36.149.42Web810
215691PageHit 2021-07-23T11:10:34.743-07:00Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.90 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx66.249.69.248Web810
215690ErrorError 4042021-07-23T11:10:34.08-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.69.250Web810
215689PageHit 2021-07-23T10:30:40.06-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36default.aspx34.213.41.122Web810
215688PageHit 2021-07-23T10:29:58.307-07:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36default.aspx54.190.193.163Web810
215687PageHit 2021-07-23T09:21:29.567-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)USPS_ZipCodeLookup.aspx207.46.13.81Web810
215686ErrorError 4042021-07-23T08:04:23.47-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36Error404.aspx49.7.20.28Web810
215685ErrorError 4042021-07-23T08:04:22.28-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.28Web810
215684ErrorError 4042021-07-23T08:04:19.593-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36Error404.aspx111.202.100.82Web810
215683ErrorError 4042021-07-23T08:04:19.223-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx111.202.100.82Web810
215682PageHit 2021-07-23T08:04:15.993-07:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36default.aspx93.158.91.231Web810
215681ErrorError 4042021-07-23T08:03:51.357-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215680ErrorError 4042021-07-23T07:50:54.34-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215679ErrorError 4042021-07-23T07:40:02.36-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215678ErrorError 4042021-07-23T07:33:18.407-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215677ErrorError 4042021-07-23T07:30:00.51-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215676ErrorError 4042021-07-23T07:27:59.347-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215675ErrorError 4042021-07-23T07:25:28.397-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215674ErrorError 4042021-07-23T07:22:11.333-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215673ErrorError 4042021-07-23T07:19:30.68-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx49.7.20.99Web810
215672PageHit 2021-07-23T06:40:59.97-07:00Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CNdefault.aspx42.236.10.75Web810
215671PageHit 2021-07-23T06:40:37.11-07:00Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CNdefault.aspx42.236.10.75Web810
215670PageHit 2021-07-23T06:23:15.35-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.57Web810
215669ErrorError 4042021-07-23T06:23:00.37-07:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx40.77.167.40Web810
215668PageHit 2021-07-23T05:49:35.2-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx207.99.46.205Web810
215667PageHit 2021-07-23T04:58:45.407-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx118.184.177.29Web810
215666ErrorError 4042021-07-23T04:21:14.833-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36Error404.aspx144.91.76.249Web810
215665ErrorError 4042021-07-23T04:20:40.97-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36Error404.aspx108.179.194.90Web810
215664PageHitService Request2021-07-23T04:15:20.903-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)LogViewer_ws.asmx96.31.33.47Web810
215663PageHit 2021-07-23T04:15:19.477-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)LogViewer_ws.aspx54.36.149.42Web810
215662PageHit 2021-07-23T03:56:42.39-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36default.aspx41.228.223.35Web810
215661PageHit 2021-07-23T03:23:10.277-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36default.aspx36.85.221.181Web810
215660PageHit 2021-07-23T02:33:25.107-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx118.184.177.29Web810
215659PageHit 2021-07-23T02:32:30.3-07:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.4.2661.102 Safari/537.36; 360Spiderdefault.aspx42.236.10.71Web810
215658PageHit 2021-07-23T01:20:19.803-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36default.aspx112.203.78.157Web810
215657PageHit 2021-07-23T01:18:13.373-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.95Web810
215656PageHit 2021-07-23T01:13:59.087-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215655PageHit 2021-07-23T01:13:58.82-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215654PageHit 2021-07-23T01:13:58.527-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215653PageHit 2021-07-23T01:13:58.21-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215652PageHit 2021-07-23T01:13:57.933-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215651PageHit 2021-07-23T01:13:57.647-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215650PageHit 2021-07-23T01:13:57.347-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215649PageHit 2021-07-23T01:13:56.6-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215648PageHit 2021-07-23T01:13:56.33-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215647PageHit 2021-07-23T01:13:56.06-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215646PageHit 2021-07-23T01:13:55.79-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215645PageHit 2021-07-23T01:13:54.05-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215644PageHit 2021-07-23T01:13:53.16-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215643PageHit 2021-07-23T01:13:52.873-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215642PageHit 2021-07-23T01:13:52.03-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215641PageHit 2021-07-23T01:13:51.747-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215640PageHit 2021-07-23T01:13:51.453-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215639PageHit 2021-07-23T01:13:49.447-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215638PageHit 2021-07-23T01:13:48.547-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215637PageHit 2021-07-23T01:13:48.237-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)default.aspx175.27.165.17Web810
215636ErrorError 4042021-07-23T01:13:43.737-07:00Apache-HttpClient/4.5.2 (Java/1.8.0_151)Error404.aspx175.27.165.17Web810
215635PageHit 2021-07-23T01:13:14.12-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.93Web810
215634PageHit 2021-07-23T00:10:19.983-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)LogViewer_Silverlight.aspx54.36.149.42Web810
215633PageHit 2021-07-23T00:01:54.66-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx118.184.177.29Web810
215632PageHitService Request2021-07-22T22:52:12.657-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)LogViewer_ws.asmx96.31.33.47Web810
215631PageHit 2021-07-22T22:52:11.627-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)LogViewer_ws.aspx77.75.79.36Web810
215630ErrorError 4042021-07-22T22:52:02.627-07:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.79.36Web810
215629PageHit 2021-07-22T22:32:51.81-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)default.aspx54.36.149.42Web810
215628PageHit 2021-07-22T20:56:40.91-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx118.184.177.30Web810
215627PageHit 2021-07-22T20:30:37.417-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.123Web810
215626PageHit 2021-07-22T20:10:26.9-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.95Web810
215625PageHit 2021-07-22T19:41:18.603-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.173Web810
215624PageHit 2021-07-22T19:29:51.027-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)default.aspx54.36.149.42Web810
215623ErrorError 4042021-07-22T18:57:34.503-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.72.226Web810
215622PageHit 2021-07-22T18:46:10.287-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)BlackScholes_European_Silverlight.aspx54.36.149.42Web810
215621PageHit 2021-07-22T18:44:01.05-07:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.173Web810
215620PageHit 2021-07-22T17:50:43.973-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)default.aspx54.36.149.42Web810
215619ErrorError 4042021-07-22T17:50:42.417-07:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)Error404.aspx54.36.148.242Web810
215618ErrorError 4042021-07-22T17:48:31.38-07:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36Error404.aspx3.81.3.41Web810
215617ArchiveLog archived2021-07-22T17:48:31.377-07:00NANANANA