Submitted by em7add11 on Thu, 12/03/2009 - 11:25am
I wonder if there's a better way to accomplish this:
C:\Program Files\Log Parser 2.2>logparser "SELECT [#Fields: date-time],session-id,remote-endpoint,data FROM RECV200912*.log WHERE session-id = (SELECT DISTINCT session-id FROM RECV200912*.log WHERE data LIKE '%MAIL FROM%someguy@domain.com%')" -i:CSV -nSkipLines:4 -o:DATAGRID -q
My SQL experience amounts to the above text and two chapters of example problems from Learning SQL so I'm a bit on the novice side, to put it lightly.
