Need SQL Query to parse security event log file for PCI Compliance

gates1580 — Fri, 29 May 2009 21:55:41 GMT

Hello Everyone

I have a requirement where I am using Log Parser 2.2 to parse security event log file in windows 2003 servers for PCI Compliance. Specifically, here is what I should be parsing -

1. Verify User identification is included in the log entries

2. Verify type of event is included in the log entries

3. Verify date and time stamp is included in the log entries

4. Verify success or failure indication is included in the log entries

5. Verify origination of event is included in the log entries

6. Verify identiy or name of affected data, system component or resources is included int he log entries.

I need some help with constructing a SQL query to output all or part of the above required data. I am not a sql expert. So, any help here would be appreciated.

Thanks

Gates1580

Input Formats

Need SQL Query to parse security event log file for PCI Compliance