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
99002PageHitService Request2019-02-20T06:09:03.463-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36470)LogViewer_ws.asmx209.67.188.9web703
99001PageHit 2019-02-20T06:09:03.013-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_ws.aspx54.226.23.160web703
99000PageHit 2019-02-20T05:58:50.43-08:00CCBot/2.0 (https://commoncrawl.org/faq/)default.aspx54.226.23.160web703
98999PageHit 2019-02-20T05:58:20.82-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_Silverlight.aspx54.226.23.160web703
98998PageHit 2019-02-20T05:58:15.08-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Silverlight.aspx54.226.23.160web703
98997PageHit 2019-02-20T05:34:47.947-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx54.226.23.160web703
98996PageHit 2019-02-20T05:26:33.127-08:00CCBot/2.0 (https://commoncrawl.org/faq/)USPS_ZipCodeLookup.aspx54.226.23.160web703
98995ErrorError 4042019-02-20T05:26:20.42-08:00CCBot/2.0 (https://commoncrawl.org/faq/)Error404.aspx54.226.23.160web703
98994ErrorError 4042019-02-20T00:31:41.59-08:00Googlebot-Image/1.0Error404.aspx66.249.69.117web703
98993PageHit 2019-02-20T00:31:31.033-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.69.121web703
98992PageHit 2019-02-19T20:19:09.837-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.55.21web703
98991ErrorError 5002019-02-19T19:23:57.157-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error500.aspx123.126.113.158web703
98990ErrorError 5002019-02-19T19:23:57.14-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error500.aspx123.126.113.158web703
98989PageHit 2019-02-19T19:16:43.873-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx123.126.113.158web703
98988ErrorError 4042019-02-19T19:10:58.74-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx123.126.113.158web703
98987PageHitService Request2019-02-19T19:06:45.49-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36470)LogViewer_ws.asmx209.67.188.9web703
98986PageHit 2019-02-19T19:06:45.203-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:62.0) Gecko/20100101 Firefox/62.0LogViewer_ws.aspx155.94.176.234web703
98985PageHit 2019-02-19T18:50:16.5-08:00Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20100101 Firefox/6.0.2default.aspx202.46.52.75web703
98984ErrorError 4042019-02-19T17:22:23.443-08:00Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36Error404.aspx178.137.90.28web703
98983PageHit 2019-02-19T15:51:33.267-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx35.185.66.21web703
98982PageHit 2019-02-19T15:48:31.413-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx35.185.66.21web703
98981PageHit 2019-02-19T15:40:05.977-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx35.185.66.21web703
98980PageHit 2019-02-19T15:38:49.993-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx35.185.66.21web703
98979PageHit 2019-02-19T15:35:17.817-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx35.185.66.21web703
98978PageHit 2019-02-19T15:33:33.937-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx35.185.66.21web703
98977PageHit 2019-02-19T15:33:21.753-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx35.185.66.21web703
98976PageHit 2019-02-19T15:33:13.29-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx35.185.66.21web703
98975ErrorError 4042019-02-19T15:33:12.987-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.185.66.21web703
98974PageHit 2019-02-19T15:26:32.47-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx35.185.66.21web703
98973PageHit 2019-02-19T15:26:16.537-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx35.185.66.21web703
98972PageHit 2019-02-19T15:25:42.44-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx35.185.66.21web703
98971PageHit 2019-02-19T15:25:40.513-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx35.185.66.21web703
98970PageHit 2019-02-19T15:25:38.65-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx35.185.66.21web703
98969PageHit 2019-02-19T15:25:37.327-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx35.185.66.21web703
98968ErrorError 4042019-02-19T15:25:37.017-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.185.66.21web703
98967ErrorError 4042019-02-19T14:39:49.433-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.69.111web703
98966PageHit 2019-02-19T14:18:45.83-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)LogViewer_Silverlight.aspx157.55.39.87web703
98965ErrorError 4042019-02-19T13:23:23.677-08:00Mozilla/5.0 (Windows NT 6.1; rv:34.0) Gecko/20100101 Firefox/34.0Error404.aspx193.106.30.98web703
98964PageHitService Request2019-02-19T12:36:52.887-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36470)LogViewer_ws.asmx209.67.188.9web703
98963PageHit 2019-02-19T12:36:52.683-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_2) AppleWebKit/537.36 (KHTML, like Gecho) Chrome/51.0.2704.84 Safari/537.36LogViewer_ws.aspx191.101.70.159web703
98962PageHit 2019-02-19T12:32:06.38-08:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36default.aspx204.141.42.194web703
98961ErrorError 4042019-02-19T12:32:05.993-08:00Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36Error404.aspx204.141.42.194web703
98960PageHit 2019-02-19T11:15:21.21-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:59.0) Gecko/20100101 Firefox/59.0default.aspx216.145.17.190web703
98959ErrorError 4042019-02-19T11:15:21.067-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:59.0) Gecko/20100101 Firefox/59.0Error404.aspx216.145.17.190web703
98958PageHit 2019-02-19T10:41:33.807-08:00ZoominfoBot (zoominfobot at zoominfo dot com)default.aspx35.227.56.236web703
98957ErrorError 4042019-02-19T10:41:33.51-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.227.56.236web703
98956PageHit 2019-02-19T10:36:41.82-08:00ZoominfoBot (zoominfobot at zoominfo dot com)default.aspx35.227.56.236web703
98955ErrorError 4042019-02-19T10:36:41.517-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.227.56.236web703
98954PageHit 2019-02-19T10:16:28.23-08:00ZoominfoBot (zoominfobot at zoominfo dot com)default.aspx35.231.44.128web703
98953ErrorError 4042019-02-19T10:16:27.92-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx35.231.44.128web703
98952PageHit 2019-02-19T09:18:49.217-08:00Mozilla/5.0 (X11; Datanyze; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36default.aspx45.55.128.239web703
98951ErrorError 4042019-02-19T09:01:05.45-08:00libwww-perl/6.08Error404.aspx74.208.58.100web703
98950ErrorError 4042019-02-19T09:01:05.157-08:00libwww-perl/6.08Error404.aspx74.208.58.100web703
98949PageHit 2019-02-19T08:52:30.027-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)default.aspx66.249.75.15web703
98948PageHitService Request2019-02-19T08:19:01.967-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36470)LogViewer_ws.asmx209.67.188.9web703
98947PageHit 2019-02-19T08:19:01.677-08:00Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.8.1.6) Gecko/20070817 IceWeasel/2.0.0.6-g3LogViewer_ws.aspx42.115.71.3web703
98946PageHitService Request2019-02-19T05:17:12.267-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36470)LogViewer_ws.asmx209.67.188.9web703
98945PageHit 2019-02-19T05:17:12.053-08:00Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)LogViewer_ws.aspx54.36.148.254web703
98944ErrorError 4042019-02-19T04:18:42.597-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.46web703
98943ErrorError 4042019-02-19T03:18:25.333-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.152 Safari/537.36Error404.aspx134.73.199.154web703
98942ErrorError 4042019-02-19T03:04:04.71-08:00Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)Error404.aspx54.36.148.59web703
98941ErrorError 4042019-02-19T02:13:49.623-08:00Mozilla/5.0 (compatible; Linux x86_64; Mail.RU_Bot/2.0; +http://go.mail.ru/help/robots)Error404.aspx95.163.255.58web703
98940ErrorError 4042019-02-19T01:44:49.463-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.75.16web703
98939PageHit 2019-02-19T00:18:02.513-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)default.aspx40.77.167.173web703
98938ErrorError 4042019-02-18T22:23:52.473-08:00Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1; 125LA; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)Error404.aspx193.169.254.83web703
98937ErrorError 4042019-02-18T22:23:52.067-08:00Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1; 125LA; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)Error404.aspx193.169.254.83web703
98936PageHit 2019-02-18T22:18:10.98-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)USPS_ZipCodeLookup.aspx77.75.79.32web703
98935ErrorError 4042019-02-18T22:18:08.07-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.79.32web703
98934PageHit 2019-02-18T22:11:08.25-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)USPS_ZipCodeLookup.aspx207.46.13.82web703
98933PageHit 2019-02-18T21:34:53.003-08: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.82web703
98932PageHit 2019-02-18T21:17:20.637-08:00Mozilla/5.0 (compatible; AlphaBot/3.2; +http://alphaseobot.com/bot.html)default.aspx23.237.4.26web703
98931PageHit 2019-02-18T21:07:11.797-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)BlackScholes_European.aspx77.75.79.17web703
98930ErrorError 4042019-02-18T21:07:08.607-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.79.17web703
98929PageHit 2019-02-18T21:02:02.34-08:00Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)BlackScholes_European_Lookup.aspx54.36.148.75web703
98928PageHit 2019-02-18T20:20:05.55-08:00Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20100101 Firefox/6.0.2default.aspx202.46.52.61web703
98927PageHit 2019-02-18T19:49:37.723-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx199.249.230.71web703
98926PageHit 2019-02-18T19:40:09.697-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)default.aspx77.75.77.17web703
98925ErrorError 4042019-02-18T19:40:06.71-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.77.17web703
98924PageHit 2019-02-18T19:29:33.883-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx199.249.230.72web703
98923ErrorError 4042019-02-18T19:27:51.507-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36Error404.aspx100.27.28.70web703
98922PageHit 2019-02-18T19:27:50.42-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36default.aspx100.27.28.70web703
98921PageHit 2019-02-18T19:23:33.85-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx218.30.103.174web703
98920ErrorError 4042019-02-18T19:17:26.477-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)Error404.aspx218.30.103.174web703
98919PageHit 2019-02-18T18:41:58.733-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx171.25.193.25web703
98918PageHit 2019-02-18T18:19:37.977-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx18.18.248.17web703
98917PageHit 2019-02-18T18:04:50.14-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx94.230.208.147web703
98916PageHit 2019-02-18T18:03:10.983-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx199.249.230.89web703
98915PageHit 2019-02-18T18:01:35.497-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx51.15.59.9web703
98914PageHit 2019-02-18T18:01:35.477-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx199.249.230.73web703
98913PageHit 2019-02-18T18:00:21.393-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx104.244.73.126web703
98912PageHit 2019-02-18T18:00:19.35-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx209.141.45.212web703
98910ArchiveLog archived2019-02-18T17:53:23.997-08:00NANANANA
98911PageHit 2019-02-18T17:53:23.997-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.89 Safari/537.36default.aspx199.249.230.74web703