Collections:
Add Execution Identification to Test Result
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
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
2017-09-28, 1697🔥, 0💬
Popular Posts:
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...
How to force JMeter to automatically flush test result to file immediately after each sampler is exe...