How To View Historical w3c Logs? (Full Version)

All Forums >> [ISA 2006 Firewall] >> Logging and Reporting



Message


dvizzle -> How To View Historical w3c Logs? (30.Dec.2009 4:02:15 PM)

I keep a few weeks of ISA logs. They have to be in the w3c format, not MSDE.

Now that I have the logs, what is the best way to query them?

If they were MSDE, I could just use a normal Monitoring query from within the ISA Management console but that doesn't work.

Is there a nice way I can view/query the logs without having to get into messy import processes with excel since there is too much data to put in one spreadsheet?

Maybe a way to import them into a SQL db?

Kinda lost here.




paulo.oliveira -> RE: How To View Historical w3c Logs? (30.Dec.2009 4:14:55 PM)

Hi,

do you want to generate reports for these logs or just analyze them?

Regards,
Paulo Oliveira.




dvizzle -> RE: How To View Historical w3c Logs? (30.Dec.2009 4:24:31 PM)

Analyze them myself.




wishfly -> RE: How To View Historical w3c Logs? (30.Dec.2009 4:31:24 PM)

you can try this software
http://www.netfeesoftware.com




paulo.oliveira -> RE: How To View Historical w3c Logs? (30.Dec.2009 4:51:30 PM)

quote:

ORIGINAL: dvizzle

Analyze them myself.

You can also use windows CLI named findstr or find. [;)]

Regards,
Paulo Oliveira.




richardhicks -> RE: How To View Historical w3c Logs? (30.Dec.2009 7:20:37 PM)

In addition to the other suggestions, the Microsoft Log Parser is another tool to consider - http://bit.ly/kpa9. Of course Notepad and Ctrl+F would work too. [;)]

You might also want to consider logging to a remote SQL server. From there you can analyze the data to your heart's content using whatever data analysis tool you wish.




dvizzle -> RE: How To View Historical w3c Logs? (4.Jan.2010 9:10:00 AM)

They are 2+ gb log files. Notepad doesn't work, and I haven't been able to find a working link to download big text viewer.




Page: [1]