« Previous Next »

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

Last post 05-29-2009 5:55 PM by gates1580. 0 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (1 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 05-29-2009, 5:55 PM

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

    Reply Contact

    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

Page 1 of 1 (1 items)
Microsoft Communities