Write a script that analyzes the events in your windows System Security Log. Export your security log entries to a CSV file which will be used by the script to perform the analysis.

The script should count the number of success and failure audits logged, provide the count associated with each, and the most common event ID. The name of the program you write should be AuditCount. It should be invoked by simply typing its name with no parameters.

The CSV file should also be in the directory from which the AuditCount script executes. Prove that your script is working correctly by cross correlating with output from a common spreadsheet program.

The output for the script should be in the following format: Number of Audit Failures: 2469 failures of 19247 entries Most common Event ID: 5038 Number of Audit Successes: 16778 successes of 19247 entries Most common Event ID: 4624