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
57747PageHitService Request2018-01-23T15:18:01.36-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
57746PageHit 2018-01-23T15:18:01.063-08:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.226.179.247web703
57745PageHit 2018-01-23T15:17:27.917-08:00CCBot/2.0 (http://commoncrawl.org/faq/)BlackScholes_European_Lookup.aspx54.226.179.247web703
57744PageHit 2018-01-23T15:16:54.057-08:00CCBot/2.0 (http://commoncrawl.org/faq/)USPS_ZipCodeLookup.aspx54.226.179.247web703
57743PageHit 2018-01-23T15:16:18.247-08:00CCBot/2.0 (http://commoncrawl.org/faq/)USPS_CityStateLookup.aspx54.226.179.247web703
57742PageHit 2018-01-23T15:14:45.593-08:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_Silverlight.aspx54.226.179.247web703
57741PageHit 2018-01-23T15:11:53.49-08:00CCBot/2.0 (http://commoncrawl.org/faq/)BlackScholes_European_Silverlight.aspx54.226.179.247web703
57740ErrorError 4042018-01-23T15:11:53.18-08:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.226.179.247web703
57739PageHit 2018-01-23T14:34:17.847-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)default.aspx188.163.79.63web703
57738PageHit 2018-01-23T14:34:15.903-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)default.aspx188.163.79.63web703
57737PageHit 2018-01-23T14:13:28.51-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.1.25 (KHTML, like Gecko) Version/8.0 Safari/600.1.25BlackScholes_European_Silverlight.aspx54.85.182.120web703
57736PageHitService Request2018-01-23T14:00:29.93-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
57735PageHit 2018-01-23T14:00:25.69-08:00Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like GeckoLogViewer_ws.aspx139.59.224.163web703
57734PageHit 2018-01-23T13:43:50.967-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; Win64; AMD64)default.aspx178.137.82.38web703
57733PageHit 2018-01-23T13:43:49.53-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; Win64; AMD64)default.aspx178.137.82.38web703
57732PageHit 2018-01-23T13:43:47.52-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; Win64; AMD64)default.aspx178.137.82.38web703
57731PageHit 2018-01-23T13:35:56.66-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)default.aspx77.75.76.161web703
57730ErrorError 4042018-01-23T13:35:53.477-08:00Mozilla/5.0 (compatible; SeznamBot/3.2; +http://napoveda.seznam.cz/en/seznambot-intro/)Error404.aspx77.75.76.161web703
57729PageHit 2018-01-23T13:35:39.18-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ru) Opera 8.01default.aspx37.115.184.155web703
57728PageHit 2018-01-23T13:35:37.613-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ru) Opera 8.01default.aspx37.115.184.155web703
57727ErrorError 4042018-01-23T13:26:45.6-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx5.255.250.118web703
57726PageHit 2018-01-23T13:24:28.1-08:00Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)default.aspx188.163.79.63web703
57725PageHit 2018-01-23T13:24:26.843-08:00Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)default.aspx188.163.79.63web703
57724PageHit 2018-01-23T13:24:26.01-08:00Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)default.aspx188.163.79.63web703
57723PageHit 2018-01-23T10:26:23.72-08:00Mozilla/5.0 (compatible; AhrefsBot/5.2; +http://ahrefs.com/robot/)USPS_CityStateLookup.aspx54.36.149.9web703
57722ErrorError 4042018-01-23T10:26:23.05-08:00Mozilla/5.0 (compatible; AhrefsBot/5.2; +http://ahrefs.com/robot/)Error404.aspx54.36.150.164web703
57721PageHitService Request2018-01-23T09:51:38.65-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
57720PageHit 2018-01-23T09:51:38.637-08:00Mozilla/5.0 (Windows NT 6.3; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0LogViewer_ws.aspx107.172.95.246web703
57719PageHit 2018-01-23T09:50:59.867-08:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36BlackScholes_European_Silverlight.aspx185.206.81.131web703
57718PageHitService Request2018-01-23T09:50:59.227-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
57717PageHit 2018-01-23T09:50:58.81-08:00Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36LogViewer_ws.aspx185.206.81.131web703
57716PageHit 2018-01-23T09:44:00.407-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx141.8.144.6web703
57715PageHit 2018-01-23T09:43:59.917-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)default.aspx5.255.250.17web703
57714ErrorError 4042018-01-23T09:43:56.257-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx84.201.133.14web703
57713ErrorError 4042018-01-23T09:43:55.893-08:00Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)Error404.aspx77.88.5.46web703
57712ErrorError 4042018-01-23T09:38:47.457-08:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Error404.aspx66.249.79.23web703
57711PageHit 2018-01-23T09:10:08.477-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.86 Safari/537.36BlackScholes_European_Silverlight.aspx118.200.118.214web703
57710PageHitService Request2018-01-23T09:10:07.607-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703
57709PageHit 2018-01-23T09:10:07.043-08:00Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.86 Safari/537.36LogViewer_ws.aspx118.200.118.214web703
57707ArchiveLog archived2018-01-23T08:28:45.96-08:00NANANANA
57708PageHitService Request2018-01-23T08:28:45.96-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.8762)LogViewer_ws.asmx209.67.188.9web703