Get Current Date from TXT/LOG File
Last post Jun 04, 2018 08:49 PM by Xebarsis
Jun 04, 2018 08:49 PM|Xebarsis|LINK
Just started using LogParser recently, and I'm new to SQL queries.
I'm trying to get LogParser to find a log file with today's date, then outputting specific contents of the file into a text document. For example:
Select Text INTO D:\LogParser\output\BlahYYYY-MM-DD.txt
where Text like '%exception%'
How do I get my query to search for today's date in the file name, while keeping the YYYY-MM-DD format, and output to a text file with the same date and format?