Add Excution Identification to Test Result

Q

How to add an execution identification to the test result? I want to separate test results between today's execution from last month execution.

✍: FYIcenter.com

A

You can follow this tutorial to add an custom field to record an execution ID in the test result.

1. Run JMeter and open "\fyicenter\First-Load-Test-6.jmx".

2. Open "Test Plan" settings and add the following to "User Defined Variables":

Name: runID
Value: ${__time(yyyyMMddHHmmss)}

3. Save the test plan to "\fyicenter\First-Load-Test-6.jmx".

4. Run MySQL client tool and add the "runID" column to the table:

mysql> alter table jmeter_test_result add column runID BIGINT;

5. Close JMeter and start it again with the following command:

>\fyicenter\jmeter\bin\jmeter -J sample_variables=testID,runID

6. Query the database with this command:

mysql> select testID, runID, elapsed, label, success 
   from jmeter_test_result order by timeStamp desc limit 0,10;
   
+--------+----------------+---------+----------+---------+
| testID | runID          | elapsed | label    | success |
+--------+----------------+---------+----------+---------+
|    123 | 20171117230054 |      43 | Google   | true    |
|    123 | 20171117230054 |      42 | Facebook | true    |
|    123 | 20171117230054 |      45 | Google   | true    |
|    123 | 20171117230054 |      43 | Facebook | true    |
|    123 | 20171117230054 |      42 | Google   | true    |
|    123 | 20171117230054 |      42 | Google   | true    |
|    123 | 20171117230054 |      43 | Facebook | true    |
|    123 | 20171117230054 |      48 | Facebook | true    |
|    123 | 20171117230054 |      51 | Google   | true    |
|    123 | 20171117230054 |      42 | Google   | true    |
+--------+----------------+---------+----------+---------+
10 rows in set (0.00 sec)

Now you can run multiple test plans and multiple times. Then run some queries to generate summary report yourself.

 

Generate Test Summary Report from MySQL

Modify MySQL Table to Store New Field

Saving Test Results to MySQL Database

⇑⇑ Apache JMeter Tutorials

2017-11-18, 265👍, 0💬