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
186497PageHitService Request2021-01-15T10:28:30.903-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
186496PageHit 2021-01-15T10:28:30.697-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_ws.aspx3.239.51.78web703
186495PageHit 2021-01-15T10:15:36.297-08:00CCBot/2.0 (https://commoncrawl.org/faq/)default.aspx3.239.51.78web703
186494PageHit 2021-01-15T10:15:08.87-08:00CCBot/2.0 (https://commoncrawl.org/faq/)LogViewer_Silverlight.aspx3.239.51.78web703
186493PageHit 2021-01-15T10:14:43.493-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Silverlight.aspx3.239.51.78web703
186492PageHit 2021-01-15T09:50:44.357-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.94web703
186491PageHit 2021-01-15T09:44:32.257-08:00CCBot/2.0 (https://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx3.239.51.78web703
186490PageHit 2021-01-15T09:19:51.79-08:00CCBot/2.0 (https://commoncrawl.org/faq/)USPS_ZipCodeLookup.aspx3.239.51.78web703
186489PageHit 2021-01-15T09:18:11.353-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64)AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36default.aspx34.220.11.172web703
186488PageHit 2021-01-15T08:51:22.983-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx106.38.241.67web703
186487ErrorError 4042021-01-15T08:46:22.343-08:00CCBot/2.0 (https://commoncrawl.org/faq/)Error404.aspx3.239.51.78web703
186486PageHit 2021-01-15T07:09:51.43-08:00Mozilla/5.0 (compatible; SemrushBot-BA; +http://www.semrush.com/bot.html)AboutMe.aspx85.208.98.22web703
186485ErrorError 4042021-01-15T07:09:25.603-08:00Mozilla/5.0 (compatible; SemrushBot-BA; +http://www.semrush.com/bot.html)Error404.aspx85.208.98.24web703
186484PageHit 2021-01-15T06:52:32.703-08:00Mozilla/5.0 (compatible; SemrushBot-BA; +http://www.semrush.com/bot.html)AboutMe.aspx85.208.98.20web703
186483ErrorError 4042021-01-15T06:52:09.637-08:00Mozilla/5.0 (compatible; SemrushBot-BA; +http://www.semrush.com/bot.html)Error404.aspx85.208.98.24web703
186482ErrorError 4042021-01-15T06:06:23.677-08:00python-requests/2.25.1Error404.aspx62.210.144.236web703
186481PageHit 2021-01-15T05:01:19.88-08:00python-requests/2.25.1default.aspx212.227.215.32web703
186480PageHit 2021-01-15T04:04:52.67-08:00python-requests/2.25.1default.aspx217.160.42.180web703
186479ErrorError 4042021-01-15T03:50:37.037-08:00python-requests/2.25.1Error404.aspx62.210.144.236web703
186478ErrorError 4042021-01-15T03:27:21.21-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx13.66.139.123web703
186477ErrorError 4042021-01-15T02:45:52.417-08:00python-requests/2.25.1Error404.aspx51.210.249.210web703
186476ErrorError 4042021-01-15T02:45:35.713-08:00python-requests/2.25.1Error404.aspx51.210.249.210web703
186475PageHit 2021-01-15T02:41:09.04-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.170 Safari/537.36 Ionic/2.16.8default.aspx160.116.243.76web703
186474PageHit 2021-01-15T02:41:08.01-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.170 Safari/537.36 Ionic/2.16.8AboutMe.aspx160.116.243.76web703
186473PageHit 2021-01-15T02:41:07.06-08:00Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.170 Safari/537.36 Ionic/2.16.8default.aspx154.12.163.169web703
186472PageHit 2021-01-15T02:34:39.493-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.94web703
186471ErrorError 4042021-01-15T02:01:53.343-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx27.128.230.74web703
186470ErrorError 4042021-01-15T02:01:53.327-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx27.128.230.74web703
186469ErrorError 4042021-01-15T02:01:53.317-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx27.128.230.74web703
186468ErrorError 4042021-01-15T02:01:53.287-08:00Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)Error404.aspx27.128.230.74web703
186467PageHit 2021-01-15T01:38:26.667-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx106.38.241.67web703
186466ErrorError 4042021-01-15T01:37:43.92-08:00python-requests/2.25.1Error404.aspx51.210.249.210web703
186465ErrorError 4042021-01-15T01:37:36.613-08:00python-requests/2.25.1Error404.aspx51.210.249.210web703
186464PageHit 2021-01-15T01:18:29.783-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36default.aspx34.77.108.104web703
186463ErrorError 4042021-01-15T00:55:44.23-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186462ErrorError 4042021-01-15T00:55:39.94-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186461ErrorError 4042021-01-15T00:55:37.047-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186460ErrorError 4042021-01-15T00:55:34.633-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186459ErrorError 4042021-01-15T00:55:32.713-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186458ErrorError 4042021-01-15T00:55:31.64-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186457ErrorError 4042021-01-15T00:55:30.71-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186456ErrorError 4042021-01-15T00:55:29.823-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186455ErrorError 4042021-01-15T00:55:28.913-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186454ErrorError 4042021-01-15T00:55:26.09-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186453ErrorError 4042021-01-15T00:55:25.193-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186452ErrorError 4042021-01-15T00:55:24.227-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186451ErrorError 4042021-01-15T00:55:23.283-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186450ErrorError 4042021-01-15T00:55:22.323-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186449ErrorError 4042021-01-15T00:55:21.377-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186448ErrorError 4042021-01-15T00:55:20.453-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186447PageHit 2021-01-15T00:55:19.39-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36default.aspx185.200.117.171web703
186446ErrorError 4042021-01-15T00:55:18.423-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186445ErrorError 4042021-01-15T00:55:14.48-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36Error404.aspx185.200.117.171web703
186444PageHit 2021-01-15T00:55:13.407-08:00Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36default.aspx185.200.117.171web703
186443PageHit 2021-01-14T20:32:59.613-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx49.7.21.94web703
186442PageHit 2021-01-14T20:13:00.793-08:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36 OPR/46.0.2597.57default.aspx192.3.93.254web703
186441PageHit 2021-01-14T20:07:35.543-08:00Mozilla/5.0 (Linux; U; Android 2.2; en-us; Nexus One Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1default.aspx42.83.147.202web703
186440PageHit 2021-01-14T19:40:06.9-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx106.38.241.67web703
186439PageHit 2021-01-14T19:32:33.357-08:00Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)default.aspx106.38.241.181web703
186438PageHit 2021-01-14T19:17:10.737-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx34.75.169.236web703
186437PageHit 2021-01-14T19:17:06.517-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx34.75.169.236web703
186436PageHitService Request2021-01-14T19:15:30.55-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
186435PageHit 2021-01-14T19:15:30.5-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_ws.aspx34.75.169.236web703
186434PageHit 2021-01-14T19:13:08.813-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx34.75.169.236web703
186433PageHit 2021-01-14T19:12:59.87-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx34.75.169.236web703
186432PageHit 2021-01-14T19:00:38.583-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx34.75.169.236web703
186431PageHit 2021-01-14T18:58:48.357-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx34.75.169.236web703
186430PageHit 2021-01-14T18:53:24.103-08:00ZoominfoBot (zoominfobot at zoominfo dot com)AboutMe.aspx34.75.169.236web703
186429PageHit 2021-01-14T18:50:19.99-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx34.75.169.236web703
186428PageHit 2021-01-14T18:50:03.06-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Default.aspx34.75.169.236web703
186427PageHit 2021-01-14T18:48:07.993-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx34.75.169.236web703
186426ErrorError 4042021-01-14T18:47:56.17-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx34.75.169.236web703
186425PageHitService Request2021-01-14T18:41:18.627-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.36543)LogViewer_ws.asmx209.67.188.9web703
186424PageHit 2021-01-14T18:41:18.503-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_ws.aspx34.75.169.236web703
186423PageHit 2021-01-14T18:39:59.06-08:00ZoominfoBot (zoominfobot at zoominfo dot com)CodeDotNetApp.aspx34.75.169.236web703
186422PageHit 2021-01-14T18:39:33.92-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_CityStateLookup.aspx34.75.169.236web703
186421PageHit 2021-01-14T18:38:07.657-08:00ZoominfoBot (zoominfobot at zoominfo dot com)LogViewer_Silverlight.aspx34.75.169.236web703
186420PageHit 2021-01-14T18:38:05.57-08:00ZoominfoBot (zoominfobot at zoominfo dot com)USPS_ZipCodeLookup.aspx34.75.169.236web703
186419PageHit 2021-01-14T18:38:03.62-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Silverlight.aspx34.75.169.236web703
186418PageHit 2021-01-14T18:38:01.973-08:00ZoominfoBot (zoominfobot at zoominfo dot com)BlackScholes_European_Lookup.aspx34.75.169.236web703
186417ErrorError 4042021-01-14T18:38:01.63-08:00ZoominfoBot (zoominfobot at zoominfo dot com)Error404.aspx34.75.169.236web703
186415ArchiveLog archived2021-01-14T17:41:34.937-08:00NANANANA
186416ErrorError 4042021-01-14T17:41:34.937-08:00Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)Error404.aspx13.66.139.123web703