Help with SQL Statement
Posted on 2009-04-06
Hello, I need help with a particular SQL statement. I'm trying to search through my log files using Logparser and I'm not to sure about the syntax for what I'm needing. I need to be able to parse through my log file and for it to check each user and their IP address, and if there is a variation in user IP then it would note that in my output.
This is what I have so far for my SQL statement. Forget the fact that I'm using Logparser, I don't want to complicate the question any further. Just concentrate on the SQL statement.
"SELECT * FROM \\mydc\logs\myfile.csv WHERE EVTID = '540' AND DOMAIN = 'TESTDC' AND LOGONTYPE = '3'"
Any help with this statement would be greatly appreciated. Thanks.