Project DescriptionEvent Comb CSV is a console utility to gather event logs for a daily email. This helps support staff to become more aware of and proactive in resolving issues. It gathers Warnings and Errors then provides machine subtotals as well as pivot tables by ID and Source.
The CSV attachment can be easily opened with Excel and further analyzed with Filters, PivotTable, and PivotCharts to get a grasp on any pattern or repetition to an issue.
This EXE can be easily placed in Task Scheduler on just one machine in the AD domain and then remotely connect to read the eventlogs of other targeted machines before sending the SMTP email summary.
Benefits
- Fewer help desk calls
- Improved system stability
- Deep system awareness
- Team cross training
- Starts team discussions. Why does ... ? What is ... ?
Cool Diagram
How It WorksLINQ is used with the
EventLogEntryclass to gather data from the remote machines. The internal class MachineSummaryEntry holds the data points of interest and provides the counts. HTML is prepared in a table layout, the full details are written to CSV in %TEMP%, and SMTP is used to send the final email.
Enjoy and please leave a review. I'd like to hear what you think.
I'd like to thank
@jgarciama for his help on teaching me LINQ statements and the benefits on an internal class for better object collection memory usage. Also, the free disk feature uses logic from
Kristofer Gäfvert. Thank you both for your coding examples and willingness to share your ideas and time.
Please drop me a line via email
jeffmjones@gmail.com or Twitter
@spjeff with ideas. I'm always open to suggestions and improvements.
Best,
Jeff
http://www.spjeff.com