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
2238597PageHitService Request2013-05-23T18:17:09.83-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238596PageHit 2013-05-23T18:17:09.817-07:00CCBot/2.0LogViewer_ws.aspx23.22.76.170web703
2238595ErrorError 4042013-05-23T18:17:09.567-07:00CCBot/2.0Error404.aspx23.22.76.170web703
2238594PageHitService Request2013-05-23T18:16:09.35-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238593PageHit 2013-05-23T18:16:09.34-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0LogViewer_ws.aspx37.59.179.252web703
2238592PageHitService Request2013-05-23T18:13:14.297-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238591PageHitService Request2013-05-23T18:12:44.39-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238590PageHit 2013-05-23T18:12:44.387-07:00Mozilla/5.0 (Linux; U; Android 2.2; fr-fr; Desire_A8181 Build/FRF91) App3leWebKit/53.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1LogViewer_ws.aspx37.59.184.112web703
2238589PageHitService Request2013-05-23T18:10:53.967-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238588PageHit 2013-05-23T18:10:33.13-07:00Mozilla/5.0 (compatible; Ezooms/1.0; ezooms.bot@gmail.com)LogViewer.aspx208.115.113.92web703
2238587PageHitService Request2013-05-23T18:07:43.367-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238586PageHit 2013-05-23T18:07:43.363-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0LogViewer_ws.aspx37.59.184.112web703
2238585PageHitService Request2013-05-23T18:07:28.07-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238584PageHit 2013-05-23T18:07:12.08-07:00Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0LogViewer.aspx94.23.16.73web703
2238583PageHitService Request2013-05-23T18:06:51.54-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238582PageHit 2013-05-23T18:06:51.52-07:00Mozilla/5.0 (Linux; U; Android 2.2; fr-fr; Desire_A8181 Build/FRF91) App3leWebKit/53.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1LogViewer_ws.aspx185.3.133.113web703
2238581PageHit 2013-05-23T18:06:05.977-07:00Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_1 like Mac OS X; en-us) AppleWebKit/532.9 (KHTML, like Gecko) Version/4.0.5 Mobile/8B117 Safari/6531.22.7 (compatible; Googlebot-Mobile/2.1; +http://www.google.com/bot.html)LogViewer_Silverlight.aspx66.249.73.195web703
2238580PageHitService Request2013-05-23T18:04:48.737-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238579PageHit 2013-05-23T18:04:48.727-07:00Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)LogViewer_ws.aspx37.59.179.252web703
2238578PageHitService Request2013-05-23T18:03:56.823-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238577PageHit 2013-05-23T18:03:56.82-07:00Opera/9.80 <a href="http://axlebook.com/profile/lelaharnes">Blackberry</a> (Windows NT 5.1; U; en) Presto/2.10.229 Version/11.60LogViewer_ws.aspx185.3.133.113web703
2238576PageHitService Request2013-05-23T18:03:55.027-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238575PageHit 2013-05-23T18:03:55.023-07:00Mozilla/5.0 (Linux; U; Android 2.2; fr-fr; Desire_A8181 Build/FRF91) App3leWebKit/53.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1LogViewer_ws.aspx185.3.133.113web703
2238574PageHitService Request2013-05-23T18:02:56.443-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238573PageHit 2013-05-23T18:02:56.433-07:00Mozilla/5.0 (Windows NT 6.0) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1LogViewer_ws.aspx37.59.184.112web703
2238572PageHitJKOcigPTbVZgVvtZ;zhqznvSHlAjvxqSlHLi;New York;NY2013-05-23T18:02:20.793-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238569PageHit 2013-05-23T18:02:20.79-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238570PageHit 2013-05-23T18:02:20.79-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238571PageHit 2013-05-23T18:02:20.79-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238566PageHit 2013-05-23T18:02:19.577-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238567PageHit 2013-05-23T18:02:19.577-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238568PageHitNXpyJwyjFKuZvXUyi;itXfIdNGkDsUHj;New York;NY2013-05-23T18:02:19.577-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238565PageHit 2013-05-23T18:02:19.573-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238563PageHit 2013-05-23T18:02:18.41-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238564PageHitiPoJnHWOEBe;YxONqUvgbIoxuV;New York;NY2013-05-23T18:02:18.41-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238561PageHit 2013-05-23T18:02:18.407-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238562PageHit 2013-05-23T18:02:18.407-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238559PageHit 2013-05-23T18:02:17.247-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238560PageHitHBtWYXmFxNvKBeOYJJS;clFUqjhokiTHIBJ;New York;NY2013-05-23T18:02:17.247-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238557PageHit 2013-05-23T18:02:17.243-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238558PageHit 2013-05-23T18:02:17.243-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238556PageHiteCDoGOJGsWjXsZaW;ZoyyOKCvtlkMaa;New York;NY2013-05-23T18:02:16.003-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238553PageHit 2013-05-23T18:02:16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238554PageHit 2013-05-23T18:02:16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238555PageHit 2013-05-23T18:02:16-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx217.16.255.159web703
2238552PageHit 2013-05-23T18:02:14.21-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)USPS_ZipCodeLookup.aspx78.159.112.128web703
2238551PageHit 2013-05-23T17:58:57.703-07:00Mozilla/5.0 (compatible; oBot/2.3.1; +http://filterdb.iss.net/crawler/)default.aspx206.253.226.23web703
2238550PageHit 2013-05-23T17:58:53.83-07:00Mozilla/5.0 (compatible; oBot/2.3.1; +http://filterdb.iss.net/crawler/)default.aspx206.253.226.23web703
2238549PageHitService Request2013-05-23T17:58:43.403-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238548PageHit 2013-05-23T17:58:43.4-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; .NET CLR 1.1.4322; PeoplePal 6.2)LogViewer_ws.aspx37.59.179.252web703
2238547PageHitService Request2013-05-23T17:58:19.907-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238546PageHitService Request2013-05-23T17:58:17.88-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238545PageHitService Request2013-05-23T17:57:42.16-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4234)LogViewer_ws.asmx209.67.188.9web703
2238544PageHit 2013-05-23T17:57:42.153-07:00Opera/9.80 (Windows NT 6.2; Win64; x64) Presto/2.12.388 Version/12.15LogViewer_ws.aspx37.59.184.112web703
2238543ArchiveLog archived2013-05-23T17:57:20.593-07:00NANANANA