Hi, I am using LogParser 2.2 (32 bit) on 64 bit Vista Operating System. I want to query the System32 folder using LogParser. I am using the below query from LogParser commandline. LogParser .exe -i:FS "SELECT PATH FROM "C:\Windows\System32\*.*"" But for the above query, LogParser...

I've been struggling to change a NULL value returned by Count(EventID) or Count(*) to zero. I'm outputting the the total number of EventID 16571 written in the application log for the last month in 8 hour segments. If no events were returned in the 8 hours segment, nothing is written to the csv...

Will the Time_Taken field help in this case? http://support.microsoft.com/kb/944884

If your running the query on the machine for which you want the comptername from you can use this: Select '%computername%' Or you can output to a file with the computername as the filename like this: INTO 'c:\directory\%ComputerName%.csv'

Jason, I don't believe you need it in the select statement. have you tried putting it in the order by without putting it in the select stement like this? ORDER BY TO_DATE(TO_TIMESTAMP(Date, 'dd/MMM/yyyy')) AS DateTimeStamp, TimeStamp, User Mike

I need to write a query that reads in a CSV file, does some magic, and then write an output CSV file. Specifically, I am merging two Blue Coat proxy server usage reports, removing duplicates, and cutting up some strings. Afterwards, I use a perl script to convert it to an Excel spreadsheet. My problem...