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, 1658🔥, 0💬
Popular Posts:
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...
How to access Response Status Code 400 as Success? My sampler failed, because the server returns the...
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...