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
809974PageHitService Request2015-01-28T04:04:16.493-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
809973PageHit 2015-01-28T04:04:16.487-08:00CCBot/2.0 (http://commoncrawl.org/faq/)LogViewer_ws.aspx54.161.185.244web703
809972ErrorError 4042015-01-28T04:04:16.21-08:00CCBot/2.0 (http://commoncrawl.org/faq/)Error404.aspx54.161.185.244web703
809971PageHitService Request2015-01-28T03:48:36.717-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
809970PageHit 2015-01-28T03:48:36.713-08:00Mozilla/5.0 (Windows NT 6.3; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0 AlexaToolbar/alxf-2.21LogViewer_ws.aspx62.210.113.241web703
809969PageHitfOfewnzDgHmDCre;JZiaQiJIcnDJE;New York;NY2015-01-28T03:48:17.28-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809968PageHit 2015-01-28T03:48:17.27-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809967PageHit 2015-01-28T03:48:17.263-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809966PageHit 2015-01-28T03:48:17.26-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809962PageHit 2015-01-28T03:48:16.58-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809963PageHit 2015-01-28T03:48:16.58-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809964PageHit 2015-01-28T03:48:16.58-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809965PageHitbATUfxxFYKTmlBRy;BrZIYasLAqo;New York;NY2015-01-28T03:48:16.58-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809958PageHit 2015-01-28T03:48:15.77-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809959PageHit 2015-01-28T03:48:15.77-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809960PageHit 2015-01-28T03:48:15.77-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809961PageHitniLJSFtCMq;AqsTzLkpUUhU;New York;NY2015-01-28T03:48:15.77-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809955PageHit 2015-01-28T03:48:14.957-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809956PageHit 2015-01-28T03:48:14.957-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809957PageHitQbxUUEiQLwobSKuHG;dRcYQEELfRsVaRRJ;New York;NY2015-01-28T03:48:14.957-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809954PageHit 2015-01-28T03:48:14.953-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809952PageHit 2015-01-28T03:48:14.203-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809953PageHitUvSXAvTlTyn;KReXkNlndSW;New York;NY2015-01-28T03:48:14.203-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809950PageHit 2015-01-28T03:48:14.2-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809951PageHit 2015-01-28T03:48:14.2-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809949PageHit 2015-01-28T03:48:10.583-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx188.165.233.138web703
809948PageHitAwmpJFpmrOUHLhMaVU;jjWqUIjkavox;New York;NY2015-01-28T03:47:21.323-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809947PageHit 2015-01-28T03:47:21.313-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809946PageHit 2015-01-28T03:47:21.307-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809945PageHit 2015-01-28T03:47:21.3-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809944PageHitrPJrAXYIsMgYe;krlMYKDvBrewDdHIUwR;New York;NY2015-01-28T03:47:20.563-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809943PageHit 2015-01-28T03:47:20.553-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809942PageHit 2015-01-28T03:47:20.543-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809941PageHit 2015-01-28T03:47:20.533-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809940PageHitsbvXAqffiyADu;EFocagqPiRJdSx;New York;NY2015-01-28T03:47:19.807-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809939PageHit 2015-01-28T03:47:19.803-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809938PageHit 2015-01-28T03:47:19.8-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809937PageHit 2015-01-28T03:47:19.797-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809933PageHit 2015-01-28T03:47:19.057-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809934PageHit 2015-01-28T03:47:19.057-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809935PageHit 2015-01-28T03:47:19.057-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809936PageHitKzDdzoXxxrDuxH;DsiziTHjccrNetn;New York;NY2015-01-28T03:47:19.057-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809932PageHitzhOpjCMuNN;KjuaZEufUGdLsMBy;New York;NY2015-01-28T03:47:18.143-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809931PageHit 2015-01-28T03:47:18.14-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809930PageHit 2015-01-28T03:47:18.137-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809929PageHit 2015-01-28T03:47:18.127-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809928PageHit 2015-01-28T03:47:17.263-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx62.210.142.7web703
809927PageHitService Request2015-01-28T03:39:38.83-08:00Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4253)LogViewer_ws.asmx209.67.188.9web703
809926PageHit 2015-01-28T03:39:38.54-08:00Mozilla/5.0 (Linux; Android 4.4.2; Nexus 5 Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.105 Mobile Safari/537.36LogViewer_ws.aspx120.198.243.99web703
809925PageHitQLwwwZljuqMyNJ;WedriVZtAdoph;New York;NY2015-01-28T03:38:02.66-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809922PageHit 2015-01-28T03:38:02.657-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809923PageHit 2015-01-28T03:38:02.657-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809924PageHit 2015-01-28T03:38:02.657-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809920PageHit 2015-01-28T03:38:02-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809921PageHitzDzaiCbPoDaOIECD;XFwYoHooPVnVzMKgC;New York;NY2015-01-28T03:38:02-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809918PageHit 2015-01-28T03:38:01.997-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809919PageHit 2015-01-28T03:38:01.997-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809917PageHitnDWBeSsykSmwO;HPocuwwmMCmJOA;New York;NY2015-01-28T03:38:01.563-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809914PageHit 2015-01-28T03:38:01.56-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809915PageHit 2015-01-28T03:38:01.56-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809916PageHit 2015-01-28T03:38:01.56-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809911PageHit 2015-01-28T03:38:01.063-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809912PageHit 2015-01-28T03:38:01.063-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809913PageHitKfEVyzQfdpWrHXkRGRM;LPVvoHAUUKtsbMso;New York;NY2015-01-28T03:38:01.063-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809910PageHit 2015-01-28T03:38:01.06-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809908PageHit 2015-01-28T03:37:55.93-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809909PageHitcDKbJnKmWFmseuQSkf;mUhXysfyLKI;New York;NY2015-01-28T03:37:55.93-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809907PageHit 2015-01-28T03:37:55.927-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809906PageHit 2015-01-28T03:37:55.923-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809905PageHit 2015-01-28T03:37:55.587-08:00Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)usps_zipcodelookup.aspx192.99.14.166web703
809904ArchiveLog archived2015-01-28T03:37:50.633-08:00NANANANA