Hi, I have a problem when I try to combine the two things.
PS C:\Program Files (x86)\Log Parser 2.2> ./LogParser.exe "SELECT EXTRACT_PREFIX(remote-endpoint,0,':') as IP,REVERSEDNS(EXTRACT_PREFIX(remote-endpoint,0,':')) as Name, COUNT(*) AS Hits, TO_LOCALTIME(TO_TIMESTAMP(EXTRACT_PREFIX(TO_STRING([#Fields: date-time]),0,'T'), 'yyyy-MM-dd')) AS LogDate from c:\tools\*.log WHERE data LIKE '%EHLO%' GROUP BY IP ORDER BY Hits DESC" -i:CSV -nSkipLines:4 -rtp:-1
Error: Semantic Error: SELECT clause field-expression "LogDate" is not an aggregate function and does not contain GROUP BY field-expressions
I'm a new with log parser, but I'm stucked arround 6 days with this,