I'm working on a side job for a client and logistically it's fairly simple, take some IIS logs/email logs and dump them into a SQL database for easier querying.
In comes LogParser (a free Microsoft utility that they don't like to advertise because they don't support it, although it seems to process very quickly and is fairly flexible, making it one of the better log analyzing tools on the market). It's command prompt driven, and SQL syntax oriented.
For instance, imagine you want to pull out logs from a specific IP address, you can write a SQL query in the command line to execute against the log file and tell LogParser where you'd like to output the results (command prompt, windows GUI dialog, SQL server, CSV file, etc.)
More once I get further...
No comments:
Post a Comment