While gpl's batch file certain should work for you. I just had to prove you could do it with Log Parser: ping <machinename> | logparser "select extract_token(extract_token(text,-1,' '),0,'m') from stdin where text like '%Average%' With stdin, you are dealing with textline input, so just filter...

Something like this would do it Graham :: store the PING output in a temp file and grab the line containing Average Ping -n 3 -w 6 www.yahoo.com | Find "Average">$temp$ :: insert the contents of the file (1 line) into a variable Set /P Av=<$temp$ :: remove the temp file Del $temp$ :: remove everything...

To be honest, LP isnt really geared up to deal with a query spanning multiple lines. Id use a batch file to strip the wanted line then use string manipulation to extract the wanted value, I think it would be quicker than trying to force LP to do it Graham

I want to get just the numeric value of the Average from a Ping so I can put it into a RRDTOOL database for later graphing. If I do a ping -n 3 -w 6 www.yahoo.com it returns something like Pinging www.yahoo.com [209.191.93.52] with 32 bytes of data: Reply from 209.191.93.52: bytes=32 time<1ms TTL...

how to delete it?

hi guys

Hi. I need some help please. In the LP Tool Kit, on page 29 an example is given which reads select top 50 sourcename, message, timegenerated into eventmonitor.html from system where eventtype = 1 and it works as expected. now if i want to read the the contents of a text file and send the data to a test...

Because of the way it was designed. From the begining the "join" approach has not been supported. If you want to use the IN approach, it should work fine - though it does require you to run 2 queries, as mentioned before.

hello Why cant I use an IN-subquery to get the result?? here is my query. SELECT LogFilename FROM 'c:\temp\log\order\*.txt' where substr(logfilename,24) IN (SELECT substr(Text,3) FROM 'C:\temp\log\error\2007-01_*.txt' where text like '%FDT%') If I use the querys by themself i get the result i want. SELECT...

You pretty much just can't do something like that solely inside LP. You'll need to run your first query that gets the name, parse and strip that name down to just the part you want, store it in a variable and then create your second query by placing the contents of that variable inside the right part...