https://community.dynatrace.com/t5/DQL/Get-Start-Timestamp-based-on-Log-Correlation-Id-in-Dynatrace/m-p/266311#M1563 <P>I have requirement to get the start timestamp from the logs based on a particular correlation Id in the Grail.</P><P>Could you please suggest on this</P> Mon, 30 Dec 2024 10:45:42 GMT KeerthanaH 2024-12-30T10:45:42Z https://community.dynatrace.com/t5/DQL/Get-Start-Timestamp-based-on-Log-Correlation-Id-in-Dynatrace/m-p/266311#M1563 <P>I have requirement to get the start timestamp from the logs based on a particular correlation Id in the Grail.</P><P>Could you please suggest on this</P> Mon, 30 Dec 2024 10:45:42 GMT https://community.dynatrace.com/t5/DQL/Get-Start-Timestamp-based-on-Log-Correlation-Id-in-Dynatrace/m-p/266311#M1563 KeerthanaH 2024-12-30T10:45:42Z https://community.dynatrace.com/t5/DQL/Get-Start-Timestamp-based-on-Log-Correlation-Id-in-Dynatrace/m-p/266355#M1564 <P>If you are looking for earliest (and maybe latest too) timestamp of log line with particular correlation in, it could look like this:</P><LI-CODE lang="markup">| summarize { start_time=min(timestamp), end_time=max(timestamp)}, by: {corrleation_id}</LI-CODE><P>but I may be incorrectly interpreting your need.<BR /><BR />Example on test data looks like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="krzysztof_hoja_0-1735585589043.png" style="width: 846px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/25509i1ADA684FED077FC5/image-dimensions/846x424?v=v2" width="846" height="424" role="button" title="krzysztof_hoja_0-1735585589043.png" alt="krzysztof_hoja_0-1735585589043.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 30 Dec 2024 19:06:56 GMT https://community.dynatrace.com/t5/DQL/Get-Start-Timestamp-based-on-Log-Correlation-Id-in-Dynatrace/m-p/266355#M1564 krzysztof_hoja 2024-12-30T19:06:56Z