Hello,
As a network administrator one of my duties is auditing the tons of log files that are created on a daily, weekly and monthly basis. Some of these log files are enormous in size, perhaps 20mb to 60mb in size. The log files are nothing more than simple comma delimited text files, nothing more. My problem is when I open it and have to audit User's or PC's it's like searching for a needle in a haystack, I need something that is going to make the process more efficient and can parse through this data quickly. This would save me tons of time.
All of the log files are in this general type of format (without the header)
User Date Time PC Name Domain Controller IP
xxxxxxxxx,xxxxxxx,xxxxxxxx,xxxxxxxxxxx,xxxxx-xxxxxxxxxxxxxxx,[login to view URL]
Some of the logs do contain other bits of information not listed here. My hope is to have a vbscript or a program that would allow me to customize my scripts to exactly what I'm needing as well as for it to add the logic behind the script. For example, let's take the above log, let's say I want to "flag" all user's that have tried to authenticate to the network but were unsuccessful in doing so so they were locked out. This particular log would tell me the user's that had tried to authenticate "3" times and then were locked out.
## Deliverables
Keep in mind though that this is just one type of log, I have many of them that I must be able to run these vbscripts on. That's why it's vital that the program or script is easily customizable.
The script or program would need to have the ability to produce results files i.e. Word, XLS, ACCESS ect. The results file would need to be very legiable as well as have the ability to show what accounts were flagged by the script/program so that they stand-out in the results file.
Again, I can't stress enough, it would need to be completely customizable so that someone with little scripting knowledge could go in and set the different arguments and logic with what they were needing with that particular log file, it would need the ability to flag objects as well as show those flags in the results file.
If you need further info, please do not hesitate to contact me. I need this done Immediately so turn-around time will have to be quick.