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
289234PageHitService Request2014-07-29T13:51:27.34-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289233PageHit 2014-07-29T13:51:27.337-07:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.198.42.213web703
289232ErrorError 4042014-07-29T13:51:27.067-07:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.198.42.213web703
289231PageHitService Request2014-07-29T13:51:20.86-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289230PageHit 2014-07-29T13:51:20.83-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289229PageHit 2014-07-29T13:50:41.063-07:00Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)LogViewer.aspx66.249.69.15web703
289228PageHitService Request2014-07-29T13:48:38.943-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289227PageHit 2014-07-29T13:48:38.94-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289226PageHitkFZKPiOPeWGEqbZWcZ;BlyLoUsHEKiDiz;New York;NY2014-07-29T13:47:57.673-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289225PageHit 2014-07-29T13:47:57.663-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289224PageHit 2014-07-29T13:47:57.653-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289223PageHit 2014-07-29T13:47:57.643-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289222PageHitSNCgreHrKrFJrug;GKBVgRfuhgc;New York;NY2014-07-29T13:47:55.773-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289221PageHit 2014-07-29T13:47:55.77-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289220PageHit 2014-07-29T13:47:55.767-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289219PageHit 2014-07-29T13:47:55.76-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289218PageHitaKQECbAEol;wQkfIVqlvPWlew;New York;NY2014-07-29T13:47:53.897-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289217PageHit 2014-07-29T13:47:53.893-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289216PageHit 2014-07-29T13:47:53.887-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289215PageHit 2014-07-29T13:47:53.88-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289214PageHitPaYlskmmmo;OBLzYCbYEp;New York;NY2014-07-29T13:47:45.217-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289212PageHit 2014-07-29T13:47:45.213-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289213PageHit 2014-07-29T13:47:45.213-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289211PageHit 2014-07-29T13:47:45.21-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289210PageHitgSoSLHVynAAwPoJVsD;MgowMifVgCCHWbdgqGi;New York;NY2014-07-29T13:47:40.893-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289208PageHit 2014-07-29T13:47:40.89-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289209PageHit 2014-07-29T13:47:40.89-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289207PageHit 2014-07-29T13:47:40.887-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx61.135.153.22web703
289206PageHit 2014-07-29T13:47:36.267-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx69.64.48.172web703
289205PageHitznqjseEtvNJeS;xYDxMyMCDsxSht;New York;NY2014-07-29T13:46:59.467-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289204PageHit 2014-07-29T13:46:59.45-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289203PageHit 2014-07-29T13:46:59.433-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289202PageHit 2014-07-29T13:46:59.427-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289201PageHitROtLwLGtyRVWFNof;EFGdvSUHqIhOTAdb;New York;NY2014-07-29T13:46:57.71-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289200PageHit 2014-07-29T13:46:57.69-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289199PageHit 2014-07-29T13:46:57.677-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289198PageHit 2014-07-29T13:46:57.67-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289197PageHitrIWWBJxdhtlfyZvM;KAozmZgBMzmkIEYe;New York;NY2014-07-29T13:46:56.923-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289196PageHit 2014-07-29T13:46:56.907-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289195PageHit 2014-07-29T13:46:56.89-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289194PageHit 2014-07-29T13:46:56.88-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289192PageHit 2014-07-29T13:46:56.17-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289193PageHitEwwPaVSeSvgz;pPTzbwMxFVnKEwNo;New York;NY2014-07-29T13:46:56.17-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289191PageHit 2014-07-29T13:46:56.17-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289190PageHit 2014-07-29T13:46:56.167-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289188PageHit 2014-07-29T13:46:55.277-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289189PageHitWpKtPklKZP;zdDldiaMubCi;New York;NY2014-07-29T13:46:55.277-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289186PageHit 2014-07-29T13:46:55.273-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289187PageHit 2014-07-29T13:46:55.273-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289185PageHit 2014-07-29T13:46:54.293-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx37.59.32.148web703
289184PageHitService Request2014-07-29T13:46:38.79-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289183PageHit 2014-07-29T13:46:38.78-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289182PageHitService Request2014-07-29T13:43:40.413-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289181PageHit 2014-07-29T13:43:40.403-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289180PageHitService Request2014-07-29T13:41:03.97-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289179PageHit 2014-07-29T13:41:03.957-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289178PageHitService Request2014-07-29T13:38:14.35-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289177PageHit 2014-07-29T13:38:14.347-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289176PageHitService Request2014-07-29T13:36:47.353-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289175PageHit 2014-07-29T13:36:47.343-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289174ErrorError 4042014-07-29T13:36:19.397-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727 ; .NET CLR 4.0.30319)Error404.aspx110.89.20.151web703
289173PageHitService Request2014-07-29T13:33:36.48-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289172PageHit 2014-07-29T13:33:36.477-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289171PageHitService Request2014-07-29T13:31:49.593-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289170PageHit 2014-07-29T13:31:49.59-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289169ErrorError 4042014-07-29T13:31:26.347-07:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.0.3705)Error404.aspx110.89.20.151web703
289168PageHitService Request2014-07-29T13:29:03.933-07:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4247)LogViewer_ws.asmx209.67.188.9web703
289167PageHit 2014-07-29T13:29:03.927-07:00Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36LogViewer_ws.aspx111.7.128.134web703
289166ArchiveLog archived2014-07-29T13:26:25.427-07:00NANANANA