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
146685PageHitService Request2020-02-26T08:46:03.69-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
146684PageHit 2020-02-26T08:46:03.573-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_ws.aspx3.226.122.74web703
146683PageHit 2020-02-26T08:33:35.58-08:00CCBot/2.0 (https://commoncrawl.org/faq/)default.aspx3.226.122.74web703
146682PageHit 2020-02-26T08:33:02.767-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_Silverlight.aspx3.226.122.74web703
146681PageHit 2020-02-26T08:32:30.897-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Silverlight.aspx3.226.122.74web703
146680PageHit 2020-02-26T08:03:29.293-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx3.226.122.74web703
146679PageHit 2020-02-26T07:34:34.99-08:00CCBot/2.0 (https://commoncrawl.org/faq/)USPS_ZipCodeLookup.aspx3.226.122.74web703
146678ErrorError 4042020-02-26T07:15:49.043-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.42web703
146677PageHit 2020-02-26T07:07:04.223-08:00CCBot/2.0 (https://commoncrawl.org/faq/)CodeDotNetApp.aspx3.226.122.74web703
146676ErrorError 4042020-02-26T07:03:31.783-08:00CCBot/2.0 (https://commoncrawl.org/faq/)Error404.aspx3.226.122.74web703
146675PageHit 2020-02-26T06:46:07.42-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)default.aspx157.55.39.51web703
146674PageHitService Request2020-02-26T05:38:04.353-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
146673PageHit 2020-02-26T05:38:04.277-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.79 Safari/537.36 Maxthon/5.2.1.6000LogViewer_ws.aspx107.183.21.86web703
146672ErrorError 4042020-02-26T05:17:36.457-08:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0Error404.aspx103.86.50.211web703
146671ErrorError 4042020-02-26T05:13:16.77-08:00Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)Error404.aspx5.9.70.117web703
146670PageHit 2020-02-26T05:03:20.65-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)LogViewer_Silverlight.aspx40.77.167.154web703
146669ErrorError 4042020-02-26T03:57:00.897-08:00Googlebot-Image/1.0Error404.aspx66.249.65.139web703
146668ErrorError 4042020-02-26T03:56:21.677-08:00Googlebot-Image/1.0Error404.aspx66.249.65.137web703
146667ErrorError 4042020-02-26T03:13:33.313-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx100.43.91.102web703
146666PageHit 2020-02-26T03:13:05.84-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)default.aspx54.36.129.48web703
146665ErrorError 4042020-02-26T03:07:31.15-08:00Googlebot-Image/1.0Error404.aspx66.249.65.139web703
146664ErrorError 4042020-02-26T02:50:54.06-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx39.104.73.141web703
146663PageHit 2020-02-26T02:32:50.51-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)default.aspx66.249.65.139web703
146662PageHit 2020-02-26T02:32:30.3-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx66.249.65.141web703
146661ErrorError 4042020-02-26T02:32:30.09-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.65.139web703
146660PageHit 2020-02-25T22:43:44.73-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36default.aspx14.161.14.83web703
146659ErrorError 4042020-02-25T22:43:03.57-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36Error404.aspx14.161.14.83web703
146658PageHit 2020-02-25T22:35:33.303-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/17.17134BlackScholes_European.aspx45.137.184.71web703
146657PageHit 2020-02-25T22:12:21.99-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx35.185.93.72web703
146656PageHit 2020-02-25T22:12:20.22-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx35.185.93.72web703
146655PageHitService Request2020-02-25T22:10:52.25-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
146654PageHit 2020-02-25T22:10:52.217-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_ws.aspx35.185.93.72web703
146653PageHit 2020-02-25T22:08:49.48-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx35.185.93.72web703
146652PageHit 2020-02-25T22:08:41.54-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx35.185.93.72web703
146651PageHit 2020-02-25T21:59:11.907-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx35.185.93.72web703
146650PageHit 2020-02-25T21:57:26.107-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx35.185.93.72web703
146649PageHit 2020-02-25T21:53:00.947-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx35.185.93.72web703
146648PageHit 2020-02-25T21:50:31.583-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx35.185.93.72web703
146647PageHit 2020-02-25T21:50:19.753-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx35.185.93.72web703
146646PageHit 2020-02-25T21:50:17.673-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx35.185.93.72web703
146645ErrorError 4042020-02-25T21:50:07.73-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.185.93.72web703
146644PageHitService Request2020-02-25T21:43:03.07-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
146643PageHit 2020-02-25T21:43:02.963-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_ws.aspx35.185.93.72web703
146642PageHit 2020-02-25T21:41:47.373-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx35.185.93.72web703
146641PageHit 2020-02-25T21:41:25.357-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx35.185.93.72web703
146640PageHit 2020-02-25T21:40:53.427-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx35.185.93.72web703
146639PageHit 2020-02-25T21:40:52.1-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx35.185.93.72web703
146638PageHit 2020-02-25T21:40:50.437-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx35.185.93.72web703
146637PageHit 2020-02-25T21:40:47.64-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx35.185.93.72web703
146636ErrorError 4042020-02-25T21:40:47.33-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.185.93.72web703
146635PageHit 2020-02-25T21:28:59.747-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/604.5.6 (KHTML, like Gecko) Version/11.0.3 Safari/604.5.6default.aspx144.76.168.111web703
146634PageHit 2020-02-25T21:28:30.823-08:00Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0default.aspx88.99.27.172web703
146633ErrorError 4042020-02-25T20:49:10.23-08:00Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)Error404.aspx148.251.41.239web703
146632PageHit 2020-02-25T20:40:59.21-08:00Mozilla/5.0 (compatible; MojeekBot/0.7; +https://www.mojeek.com/bot.html)default.aspx5.102.173.71web703
146631ErrorError 4042020-02-25T20:40:58.607-08:00Mozilla/5.0 (compatible; MojeekBot/0.7; +https://www.mojeek.com/bot.html)Error404.aspx5.102.173.71web703
146630ErrorError 4042020-02-25T19:34:40.953-08:00Mozilla/5.0 (compatible; Linux x86_64; Mail.RU_Bot/2.0; +http://go.mail.ru/help/robots)Error404.aspx95.163.255.55web703
146629PageHit 2020-02-25T19:01:28.063-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx58.250.125.135web703
146628PageHit 2020-02-25T18:57:37.95-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)default.aspx157.55.39.51web703
146627PageHit 2020-02-25T17:51:12.067-08: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.10.113web703
146626PageHit 2020-02-25T17:34:47.887-08:00Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)BlackScholes_European.aspx54.36.148.120web703
146625PageHit 2020-02-25T17:34:02.67-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36default.aspx203.217.241.195web703
146624ErrorError 4042020-02-25T17:19:57.127-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx39.104.156.79web703
146623ErrorError 4042020-02-25T16:28:28.3-08:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0Error404.aspx106.14.192.27web703
146622PageHit 2020-02-25T15:56:53.41-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)default.aspx66.249.65.141web703
146621PageHit 2020-02-25T15:53:35.03-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Default.aspx141.8.144.6web703
146620PageHit 2020-02-25T15:53:31.223-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx5.255.250.118web703
146619ErrorError 4042020-02-25T15:53:27.62-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx37.9.87.163web703
146618PageHit 2020-02-25T15:18:38.75-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36default.aspx66.246.224.12web703
146617ErrorError 4042020-02-25T12:20:04.833-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.65.137web703
146616PageHit 2020-02-25T11:23:58.133-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.65 Safari/537.31default.aspx54.244.56.195web703
146614ArchiveLog archived2020-02-25T10:55:19.267-08:00NANANANA
146615PageHit 2020-02-25T10:55:19.267-08:00ZoominfoBot (zoominfobot at zoominfo dot com)default.aspx35.231.173.125web703