https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275580#M1967 <P>I think you can get the main trace if you look for spans where the span.parent_id value is not present (null).&nbsp;</P><P>In its simplest form and without any additional filters, the DQL might look like this:</P><LI-CODE lang="javascript">fetch spans | filter isNull(span.parent_id) | fields start_time, trace.id, dt.entity.service, endpoint.name, duration</LI-CODE> Mon, 21 Apr 2025 23:05:31 GMT marco_irmer 2025-04-21T23:05:31Z https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275575#M1965 <P>I'm trying to mimic the way duration of a trace is shown in the Distributed Tracing apps. I'm getting very, very close but seem to be missing something. I realize this may be slightly different depending on the application, but I'd like to know if anyone has had any success with this or if anyone from Dynatrace would like to chime in and describe how it's calculated.&nbsp;</P> <P>My trouble is some of the spans seem to be duplicated to represent code functions and if I don't exclude them from my query they will contribute to the overall sum of the durations.</P> <P>The reason this is important is because I'd like to calculate duration of a trace, but without certain specific spans and their sub-spans. I'm trying to recreate the duration in DQL as a start.</P> Thu, 18 Dec 2025 10:55:01 GMT https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275575#M1965 StrangerThing 2025-12-18T10:55:01Z https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275580#M1967 <P>I think you can get the main trace if you look for spans where the span.parent_id value is not present (null).&nbsp;</P><P>In its simplest form and without any additional filters, the DQL might look like this:</P><LI-CODE lang="javascript">fetch spans | filter isNull(span.parent_id) | fields start_time, trace.id, dt.entity.service, endpoint.name, duration</LI-CODE> Mon, 21 Apr 2025 23:05:31 GMT https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275580#M1967 marco_irmer 2025-04-21T23:05:31Z https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275666#M1973 <P>That doesn't seem to work because my beginning span also has a span.parent_id</P> Tue, 22 Apr 2025 13:54:21 GMT https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/275666#M1973 StrangerThing 2025-04-22T13:54:21Z https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/291792#M2928 <P>Hey&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/53298">@StrangerThing</a>&nbsp;,<BR /><SPAN>I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you!&nbsp;</SPAN><SPAN class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:"><span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></SPAN><BR /><SPAN>Please let me know what works best for you.</SPAN></P> Thu, 18 Dec 2025 10:54:31 GMT https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/291792#M2928 IzabelaRokita 2025-12-18T10:54:31Z https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/291838#M2947 <P>I've built out something that works, however I'd still like a way to differentiate between async and sync spans</P> Thu, 18 Dec 2025 14:03:28 GMT https://community.dynatrace.com/t5/DQL/Fetch-Spans-to-Calculate-Duration-in-Distributed-Traces-Using/m-p/291838#M2947 StrangerThing 2025-12-18T14:03:28Z