how to save Event logs into csv file

Question

I'm trying to save the result of log files that I get from Event viewer into a csv file and make sure its not duplicated

any suggestions please

this my code for reading the log file

    using System;
using System.Text;

class Program
{
    static void Main(string[] args)
    {
       
        System.Diagnostics.EventLog log = new
        System.Diagnostics.EventLog("System");


        foreach (System.Diagnostics.EventLogEntry entry in log.Entries)
        {


            {
                Console.WriteLine("Index:" + entry.Index);
                Console.WriteLine("source:"+entry.Source);
                Console.WriteLine("Level:"+entry.EntryType);
                Console.WriteLine("Event ID:"+entry.EventID);
                Console.WriteLine("TimeGenerated:"+entry.TimeGenerated);
                Console.WriteLine("User Name:"+entry.UserName);
                Console.WriteLine("Message:"+entry.Message);
                Console.WriteLine("--------");
            }
        }

        Console.WriteLine("Done");
        Console.ReadLine();

    }
}

Your problem is that you can't save to a csv file or that there are duplicates? — Patrick
– Patrick, Commented Aug 11, 2022 at 13:37
@Patrick i want to save it into csv and make sure no duplicated will happens — call out my name
– call out my name, Commented Aug 11, 2022 at 13:39

Patrick · Accepted Answer · 2022-08-11 13:53:10Z

1

To save your logs to a csv you can follow this answer: Writing data into CSV file in C#

In your case it should look something like this:

var log = new EventLog("System");
var csv = new StringBuilder();
foreach (EventLogEntry entry in log.Entries)
{
    csv.AppendLine($"{entry.Index};{entry.Source};{entry.EntryType};{entry.EntryType};{entry.TimeGenerated};{entry.UserName};{entry.Message}");
}
File.WriteAllText("test.csv", csv.ToString());

It can be that you ne "," instead of ";" to make it readable for excel for example.

But I still not get what you mean by it should not print duplicates. Each line has a different event id and timestamp, so even if the message is there multiple times, there are different instances.

answered Aug 11, 2022 at 13:53

Patrick

4074 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

call out my name Over a year ago

the code work good without error but the file still empty

Patrick Over a year ago

Did you also find the file? It is saved in the debug folder, you can also have another file path there like "C:/test.csv". It worked for me and wrote alle the logs into the file.

call out my name Over a year ago

last question is there anyway to separate events from each other on the file to make it readable

Deepak Ramesh Over a year ago

I have similar requirement to read evtx file and convert to csv, I tried above code and it does'nt work for me

Deepak Ramesh · Accepted Answer · 2023-01-28 22:48:45Z

0

I have attached the screenprint for tried sample code in online

answered Jan 28, 2023 at 22:48

Deepak Ramesh

4111 gold badge5 silver badges14 bronze badges

Collectives™ on Stack Overflow

how to save Event logs into csv file

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related