Skip to main content

Processing JMeter Results using awk

awk is Pattern scanning and processing language. Its name is derived from its authors “Aho, Weinberger, and Kernighan”.
Some of its features are:
  • Awk views a text file as records and fields
  • Awk has variables, conditionals and loops
  • Awk has arithmetic and string operators
  • Awk can generate formatted reports
Syntax:
awk '/search pattern1/ {Actions}
     /search pattern2/ {Actions}' file
Herein :
  • search pattern is a regular expression.
  • Actions – statement (s) to be performed.
  • several patterns and actions can be used in Awk.
  • file is the Input file.
  • Single quotes around program avoids shell interpreting any special characters.
Let’s Consider following jmeter summary file -


summary +    41 in  15.4s =    2.7/s Avg:  2234 Min:   383 Max:  6974 Err: 0 (0.00%)
summary +    57 in  21.5s =    2.6/s Avg:  2548 Min:   618 Max:  4528 Err: 0 (0.00%)
summary =    98 in  32.5s =    3.0/s Avg:  2416 Min:   383 Max:  6974 Err: 0 (0.00%)
summary +   108 in  21.8s =    5.0/s Avg:  1291 Min:   229 Max:  6317 Err: 0 (0.00%)
summary =   206 in  52.5s =    3.9/s Avg:  1827 Min:   229 Max:  6974 Err: 0 (0.00%)
Let’s assume that we want to print lines where avg response time is more than 2500ms
awk '{if($9>2500){print $0}}' file.txt


Herein $9 is the the 9th field in log file and $0 denotes all of record
Hence we would get following output -
summary +    57 in  21.5s =    2.6/s Avg:  2548 Min:   618 Max:  4528 Err: 0 (0.00%)
Or printing the records with avg response time more than 2400ms
awk '{if($9>2400){print $0}}' file.txt


And we would get following output -


summary +    57 in  21.5s =    2.6/s Avg:  2548 Min:   618 Max:  4528 Err: 0 (0.00%)
summary =    98 in  32.5s =    3.0/s Avg:  2416 Min:   383 Max:  6974 Err: 0 (0.00%)
Find the total number of record in jmeter.log file -


wc file.txt | awk ‘{print $0}’


Consider that you are logging custom variables on Jmeter log file (i.e. email address etc) and now you want to figure out which email address caused higher latency. Can you guess how you can achieve it?
Labels:

Popular posts from this blog

Verify email confirmation using Selenium

Note: If you are new to java and selenium then start with selenium java training videos .     Email confirmation seems to be integral part of any registration process. I came across an application which lets you provide your email address. You can follow the sign up link in you mail and then complete the registration process. Lets consider we provide GMail address for it. Now if were to use only Selenium then we would have to follow following steps - Launch GMail using Selenium; Some how search for new mail in the list of available mails; Some how click on it; Parse the mail message; Get the registration link; Follow up with registration process What do you think of an approach in which you can
13 comments
Read more

Selenium Tutorial: Get attribute of an element

With Selenium 1.0 Let us consider Google Search Box for example and its "max length"is to be retrieved. Using xPath -         String var = selenium.getAttribute("//input[@name='q']/@maxlength");         System.out.println(var); Using css locator -                        String var = selenium.getAttribute("css=input[name='q']@maxlength");         System.out.println(var);        With Selenium 2.0 (WebDriver)        Using xPath -         String var = webDriver.findElement(By.xpath("//input[@name='q']")).getAttribute("maxlength")         System.out.println(var); Using css locator -                     ...
2 comments
Read more

Capture network traffic using WebDriver

We often come across testing requirements when we need to analyze the network traffic to find - HTTP status of page Analyze header information to find if right information is passed Validating parameters related to ajax requests etc Selenium 1 has had a way to capture n/w traffic but the feature does not always work as expected. At times Selenium 1 does not capture all n/w traffic, And given that Selenium 1 APIs are almost dead it is
4 comments
Read more