...
The above settings can also be defined as global properties in the JMeterjmeter.properties configuration file, or in the user.properties file.
The JMeter Log Format
...
XML Element | Explanation | ||
{{/testResults }} | Root element for XML test log | ||
| Version of test results. Currently (JMeter 2.1.1), set to "1.1" irrespective of testlog format flag. | ||
| All log data is stored under an array of 'sampleResult' elements. | ||
| Timestamp - See Java method System.currentTimeMillis() | ||
| Datatype - typically "text" | ||
| Name set for the thread group, with affixed at the end " <iteration>-<thread_id>". For eg "Integration Tests Thread Group 1-1" | ||
| Label set for the sampler. For eg "Login to Custom URL using test account credentials" | ||
| Time in milliseconds for request to complete. Eg "2515" | ||
| Response message. Eg "OK" | ||
| Response code. Eg "200" | ||
| String indicating status of the request. Can be "true" or "false" | ||
| HTTP Redirects are represented as an array of nested 'sampleResult' elements. Only 1 level of nesting occurs (i.e. the nested subresults do not nest further). | ||
| A string containing POST Data, Query Data and Cookie Data | ||
| XML attribute indicating whether that white space is significant. Set to "preserve" | ||
| Set to "samplerData" | ||
| Assertion information are stored in an array of assertionResult | ||
| The failure message when the assertion fails | ||
| Set to "true" or "false" to indicate error in assertion (stays "false" on assertion failure) | ||
| Set to "true" or "false" to indicate whether assertion failed or not | ||
| Data returned in response |
...
Once the data is in Excel, I convert the timestamp column from Jmeter's Unix Java timestamp format (base year 1970) to the Excel format (base year 1900 or 1904 depending on the Excel version and underlying OS) using this following formula. This formula is applied to the entire timestamp column.
...
The script uses a few neat awk tricks, such as:
- Rounding unix Java timestamps to nearest minute
- Collect timestamps grouped by minute
- Convert unix Java timestamp to YYYY-MM-dd etc.
- Print Throughput for a minute increment
- Print Average response time for a minute increment
- Do all of the above in an efficient single pass through awk (this was the hardest bit!)
...
NB, here's a script to convert JMeter's Unix Java timestamps:
Script: utime2ymd.txt
...