I have Windows2000 Application Event Log file in CSV format with all
kinds of entries However I need to process following types of records
for print logs and generate report:
9/19/2003,8:15:57 AM, Print, Information, None, 10, NT
AUTHORITY\SYSTEM, NTBOX112, Document 111, TestFile.doc owned by
MoJo(192.168.1.123) was printed on PRINTER1 via port PRINTER1. Size
in bytes: 3128; pages printed: 4
9/19/2003,8:19:32 AM, Print, Information, None, 10, NT
AUTHORITY\SYSTEM, NTBOX112, Document 111, Silver.xls owned by
FoKo(192.168.1.124) was printed on PRINTER2 via port PRINTER2. Size
in bytes: 1912; pages printed: 3
I am thinking of creating report in following format and export to
Excel:
Date,Printer,TotalJobs,TotalDataSizeOctets
9/19/2003,PRINTER1,1, 3128
9/19/2003,PRINTER2,1,1912