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, 2031🔥, 0💬
Popular Posts:
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
How to expand IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has ...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to update hidden input value field value with WebDriver in Python? Normally, a hidden input valu...