RZA-PT | KilroyPT
- Joined
- Aug 27, 2007
- Messages
- 936
- Reaction score
- 85
Hi All
i got sick of sifting through log files so I made this console app that will read and parse them to a database for you.
Database is simply:
- ID (INT) Identity,
- Checksum (NVARCHAR), Checksum of entry used to prevent duplicates
- Type (NVARCHAR), Log type (admin, debug, server, aging etc etc)
- Timestamp (DATETIME), log entry time
- Msg (NVARCHAR), Log message
First run will prompt you for database connection info, database and table names,
It will then create the tables in the chosen database.
It will also create logparser.ini which will hold those settings along with timeout and overwrite
set overwrite to "true" if you wish it to delete the files once they have been processed (it will only delete if it successfully processes the entire file.
This helps reduce run time of the task and saves storage space.
be default this is set to false.
timeout is the time in minutes between each passing, default is 5 minutes.
I find this useful cause then logs can be audited through a web interface tool and its much quicker than trying to process over the files every time.
I hope its of use to others
i got sick of sifting through log files so I made this console app that will read and parse them to a database for you.
Database is simply:
- ID (INT) Identity,
- Checksum (NVARCHAR), Checksum of entry used to prevent duplicates
- Type (NVARCHAR), Log type (admin, debug, server, aging etc etc)
- Timestamp (DATETIME), log entry time
- Msg (NVARCHAR), Log message
First run will prompt you for database connection info, database and table names,
It will then create the tables in the chosen database.
It will also create logparser.ini which will hold those settings along with timeout and overwrite
set overwrite to "true" if you wish it to delete the files once they have been processed (it will only delete if it successfully processes the entire file.
This helps reduce run time of the task and saves storage space.
be default this is set to false.
timeout is the time in minutes between each passing, default is 5 minutes.
You must be registered to see links
I find this useful cause then logs can be audited through a web interface tool and its much quicker than trying to process over the files every time.
I hope its of use to others