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.

 

Saving Test Results to MySQL Database

⇒⇒Apache JMeter Tutorials

2017-11-18, 164👍, 0💬