Is there a way to do this? I want to filter some logs using logparser but I want the output to look just like the input (except with the filtered-out lines missing). Thanks!
OK, maybe I should clarify a bit....if I'm doing a select *, the first two columns always seem to be LogFilename and RowNumber. If I explicitly specify the other columns (which requires me to know what the input log's columns are), I can suppress LogFilename
and RowNumber. However, I'd ideally like to have LogParser SQL that doesn't have the input log file's columns hard-coded. Ideally, I'd like a "select * without LogFilename and RowNumber"...can it be done?
Well, this is an old thread, but I had the same question.
lunadesign's reply helped me figure out that in my case I could do a SELECT TEXT instead of SELECT * so that I just got the output text and not the Logfilename and Index columns. Not sure if this helps in lunadesign's problem, but maybe this is the answer
to someone else's problem too.
lunadesign
4 Posts
Suppress output of LogFilename & RowNumber fields?
Jan 10, 2011 05:49 AM|LINK
Is there a way to do this? I want to filter some logs using logparser but I want the output to look just like the input (except with the filtered-out lines missing). Thanks!
lunadesign
4 Posts
Re: Suppress output of LogFilename & RowNumber fields?
Jan 10, 2011 06:00 AM|LINK
OK, maybe I should clarify a bit....if I'm doing a select *, the first two columns always seem to be LogFilename and RowNumber. If I explicitly specify the other columns (which requires me to know what the input log's columns are), I can suppress LogFilename and RowNumber. However, I'd ideally like to have LogParser SQL that doesn't have the input log file's columns hard-coded. Ideally, I'd like a "select * without LogFilename and RowNumber"...can it be done?
jmcconda
1 Post
Re: Suppress output of LogFilename & RowNumber fields?
Nov 27, 2012 09:32 PM|LINK
Well, this is an old thread, but I had the same question.
lunadesign's reply helped me figure out that in my case I could do a SELECT TEXT instead of SELECT * so that I just got the output text and not the Logfilename and Index columns. Not sure if this helps in lunadesign's problem, but maybe this is the answer to someone else's problem too.