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
181397PageHitService Request2020-11-24T21:53:16.34-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
181396PageHit 2020-11-24T21:53:16.257-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_ws.aspx18.213.192.104web703
181395PageHit 2020-11-24T21:42:07.72-08:00CCBot/2.0 (https://commoncrawl.org/faq/)default.aspx18.213.192.104web703
181394ErrorError 4042020-11-24T21:41:55.23-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181393ErrorError 4042020-11-24T21:41:54.8-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181392ErrorError 4042020-11-24T21:41:54.36-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181391ErrorError 4042020-11-24T21:41:53.743-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181390ErrorError 4042020-11-24T21:41:53.14-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181389ErrorError 4042020-11-24T21:41:52.64-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181388ErrorError 4042020-11-24T21:41:52.2-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0Error404.aspx185.234.216.247web703
181387PageHit 2020-11-24T21:41:31.503-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_Silverlight.aspx18.213.192.104web703
181386PageHit 2020-11-24T21:40:55.74-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Silverlight.aspx18.213.192.104web703
181385PageHit 2020-11-24T21:13:49.02-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx18.213.192.104web703
181384PageHit 2020-11-24T20:49:29.49-08:00CCBot/2.0 (https://commoncrawl.org/faq/)USPS_ZipCodeLookup.aspx18.213.192.104web703
181383ErrorError 4042020-11-24T20:24:47.35-08:00CCBot/2.0 (https://commoncrawl.org/faq/)Error404.aspx18.213.192.104web703
181382ErrorError 4042020-11-24T20:11:01.23-08:00Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0Error404.aspx34.68.97.70web703
181381ErrorError 4042020-11-24T19:48:21.523-08:00Mozilla/5.0 (compatible; DotBot/1.1; http://www.opensiteexplorer.org/dotbot, help@moz.com)Error404.aspx216.244.66.194web703
181380ErrorError 4042020-11-24T19:31:02.607-08:00(compatible;PetalBot;+https://aspiegel.com/petalbot)Error404.aspx114.119.156.115web703
181379PageHit 2020-11-24T19:20:54.267-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.101web703
181378PageHit 2020-11-24T18:17:44.153-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.117web703
181377ErrorError 4042020-11-24T18:09:31.173-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx47.92.241.24web703
181376ErrorError 4042020-11-24T16:51:48.377-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx39.98.49.33web703
181375ErrorError 4042020-11-24T16:21:41.94-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx39.98.49.33web703
181374ErrorError 4042020-11-24T16:21:35.897-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx39.98.49.33web703
181373ErrorError 4042020-11-24T16:21:35.87-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx39.98.49.33web703
181372PageHit 2020-11-24T15:55:13.373-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.174web703
181371PageHit 2020-11-24T15:32:17.533-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.65web703
181370ErrorError 4042020-11-24T14:46:20.593-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx39.98.49.33web703
181369ErrorError 4042020-11-24T14:46:20.59-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx39.98.49.33web703
181368PageHitService Request2020-11-24T14:27:50.897-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
181367PageHit 2020-11-24T14:27:50.83-08:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)LogViewer_ws.aspx54.36.148.203web703
181366PageHit 2020-11-24T14:19:06.2-08:00Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)CodeDotNetApp.aspx54.36.148.52web703
181365ErrorError 4042020-11-24T14:10:28.89-08:00python-requests/2.25.0Error404.aspx172.245.71.11web703
181364ErrorError 4042020-11-24T14:10:26.213-08:00python-requests/2.25.0Error404.aspx172.245.71.11web703
181363ErrorError 4042020-11-24T14:10:24.92-08:00python-requests/2.25.0Error404.aspx172.245.71.11web703
181362ErrorError 4042020-11-24T14:10:24.187-08:00python-requests/2.25.0Error404.aspx172.245.71.11web703
181361ErrorError 4042020-11-24T14:10:23.307-08:00python-requests/2.25.0Error404.aspx172.245.71.11web703
181360ErrorError 4042020-11-24T14:10:22.9-08:00python-requests/2.25.0Error404.aspx172.245.71.11web703
181359PageHit 2020-11-24T14:10:20.75-08:00python-requests/2.25.0default.aspx172.245.71.11web703
181358PageHit 2020-11-24T13:58:59.173-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; KTXN)default.aspx195.123.209.118web703
181357PageHit 2020-11-24T13:58:58.287-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; KTXN)default.aspx195.123.209.118web703
181356PageHit 2020-11-24T13:58:57.34-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; KTXN)default.aspx195.123.209.118web703
181355PageHit 2020-11-24T13:22:11.297-08:00Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://aspiegel.com/petalbot)LogViewer_Silverlight.aspx114.119.130.168web703
181354PageHit 2020-11-24T12:33:02.077-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx34.74.229.138web703
181353PageHit 2020-11-24T12:32:58.4-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx34.74.229.138web703
181352PageHitService Request2020-11-24T12:31:44.72-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
181351PageHit 2020-11-24T12:31:44.673-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_ws.aspx34.74.229.138web703
181350PageHit 2020-11-24T12:29:40.323-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx34.74.229.138web703
181349PageHit 2020-11-24T12:29:28.28-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx34.74.229.138web703
181348PageHit 2020-11-24T12:19:44.77-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx34.74.229.138web703
181347PageHit 2020-11-24T12:18:22.987-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx34.74.229.138web703
181346PageHit 2020-11-24T12:13:37.923-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx34.74.229.138web703
181345PageHit 2020-11-24T12:11:29.607-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx34.74.229.138web703
181344PageHit 2020-11-24T12:11:14.567-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx34.74.229.138web703
181343PageHit 2020-11-24T12:09:17.587-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx34.74.229.138web703
181342ErrorError 4042020-11-24T12:09:09.77-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx34.74.229.138web703
181341PageHitService Request2020-11-24T12:03:30.4-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
181340PageHit 2020-11-24T12:03:30.3-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_ws.aspx34.74.229.138web703
181339PageHit 2020-11-24T12:02:21.427-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx34.74.229.138web703
181338PageHit 2020-11-24T12:01:56.85-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx34.74.229.138web703
181337PageHit 2020-11-24T12:00:57.303-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx34.74.229.138web703
181336PageHit 2020-11-24T12:00:55.243-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx34.74.229.138web703
181335PageHit 2020-11-24T12:00:52.377-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx34.74.229.138web703
181334PageHit 2020-11-24T12:00:49.5-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx34.74.229.138web703
181333ErrorError 4042020-11-24T12:00:49.173-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx34.74.229.138web703
181332PageHit 2020-11-24T11:47:01.84-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36default.aspx61.129.8.179web703
181331ErrorError 4042020-11-24T11:39:42.56-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx207.46.13.104web703
181330PageHit 2020-11-24T11:28:46.963-08:00Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)LogViewer.aspx66.249.79.103web703
181329ErrorError 4042020-11-24T11:28:46.803-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.103web703
181328ErrorError 4042020-11-24T11:09:47.213-08:00Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9) Gecko/2008052906 Firefox/3.0Error404.aspx51.195.137.237web703
181327ErrorError 4042020-11-24T11:05:14.707-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx39.99.54.47web703
181326PageHit 2020-11-24T10:54:55.65-08:00Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://aspiegel.com/petalbot)BlackScholes_European_Silverlight.aspx114.119.141.93web703
181325PageHit 2020-11-24T10:52:16.783-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)default.aspx157.55.39.42web703
181324ErrorError 4042020-11-24T10:52:11.01-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx157.55.39.33web703
181323PageHit 2020-11-24T09:56:55.657-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.93web703
181322PageHit 2020-11-24T09:46:09.16-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.183.224.65web703
181321PageHit 2020-11-24T09:33:33.71-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64)AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36default.aspx54.212.221.10web703
181320PageHit 2020-11-24T08:45:47.973-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3432.3 Safari/537.36BlackScholes_European_Silverlight.aspx159.224.255.154web703
181319PageHit 2020-11-24T08:45:47.357-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3432.3 Safari/537.36default.aspx159.224.255.154web703
181318ErrorError 4042020-11-24T08:06:33.093-08:00Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)Error404.aspx54.36.148.179web703
181317ErrorError 4042020-11-24T07:53:26.297-08:00Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0Error404.aspx82.165.117.55web703
181316ErrorError 4042020-11-24T07:31:48.223-08:00Mozilla/5.0 (Windows NT 10.0; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0Error404.aspx110.229.218.64web703
181315ArchiveLog archived2020-11-24T07:31:48.22-08:00NANANANA