Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an event view that I need to filter and pivot the data from.

I tried exporting the file as a CSV file, but that is missing the description.

I tried exporting the file as XML, but there was no schema, so excel opened it as a table and it was of little to no use.

Is there a way that I can open an event log in excel and be able to pivot / filter on the data, but still retain the description part of the log entries.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Have you looked at Microsoft LogParser?

Download here

With LogParser you can do the filtering you want on the Event log files and export to a type that you want. For Example the following command selects everything from the system event log, where type is not information (EventType 4 is "Information Event") and then outputs that data to csv.

LogParser "SELECT * INTO c:\report.csv FROM SYSTEM WHERE EventType <> 4" -i:EVT -o:CSV

You can filter by what you want by refining the query and the LogParser Helpfile is quite good. Plenty of help is available on the internet too :) You can even generate Charts if you like.

With the query above you can change 'FROM SYSTEM' to 'FROM c:\foldername*.evt' to parse multiple backed-up event log files at once.

Hope this info helps!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.