I've got a MS ISA 2000 Firewall running, and it logs all web proxy requests to a SQL2000 database. So now I'm trying to create a report based off this, but the logs contain so much data, 1 days worth produces 3000 pages. When I look at the report, the firewall logs all sorts of sites, such as ads and popups, etc that the user doesn't actually click on.
Is there template or something on how to filter out these rows so that I only get the real traffic of a user, what they actualy navigate to? I would think BO would have a template for this, since I'm guessing it's a relatively common task?
I tried just displaying any request that starts with "www" but sites like "Hotmail" don't use a it. Any help is greatly appreciated, thanks!!
Is there template or something on how to filter out these rows so that I only get the real traffic of a user, what they actualy navigate to? I would think BO would have a template for this, since I'm guessing it's a relatively common task?
I tried just displaying any request that starts with "www" but sites like "Hotmail" don't use a it. Any help is greatly appreciated, thanks!!