How can I create script that will put event logs into excel?

microsoft.public.windows.server.scripting

11 Mar 2007 7:25 AM

Mike

I am looking for a script that will collect event logs between certain dates
and only collect the error number and its description and put those in
columns 2 and 3 respectfully in an xls file.

I would also like the script to fill column 1 with the name of the log it
searched:
for example: "Sec", "App", "Sec", "AD"

Thanks

Mike

13 Mar 2007 5:11 AM

On Mar 11, 2:25 am, Mike <M***@discussions.microsoft.com> wrote:

> I am looking for a script that will collect event logs between certain dates
> and only collect the error number and its description and put those in
> columns 2 and 3 respectfully in an xls file.
>
> I would also like the script to fill column 1 with the name of the log it
> searched:
> for example: "Sec", "App", "Sec", "AD"
>
> Thanks
>
> Mike

have you tried useing dumpel.exe? you should be able to get the
events in a formatted file (csv, tab-delimited) and import it into
excel.

you can get dumpel from the url below:
http://support.microsoft.com/kb/927229