<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic DQL function replacing splunk command stats list in DQL</title>
    <link>https://community.dynatrace.com/t5/DQL/DQL-function-replacing-splunk-command-stats-list/m-p/282761#M2395</link>
    <description>&lt;P&gt;is there a DQL Command/function available which can replace the stats list command in splunk ? Thanks in advance&lt;/P&gt;</description>
    <pubDate>Thu, 31 Jul 2025 19:17:35 GMT</pubDate>
    <dc:creator>susmita_k</dc:creator>
    <dc:date>2025-07-31T19:17:35Z</dc:date>
    <item>
      <title>DQL function replacing splunk command stats list</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-function-replacing-splunk-command-stats-list/m-p/282761#M2395</link>
      <description>&lt;P&gt;is there a DQL Command/function available which can replace the stats list command in splunk ? Thanks in advance&lt;/P&gt;</description>
      <pubDate>Thu, 31 Jul 2025 19:17:35 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-function-replacing-splunk-command-stats-list/m-p/282761#M2395</guid>
      <dc:creator>susmita_k</dc:creator>
      <dc:date>2025-07-31T19:17:35Z</dc:date>
    </item>
    <item>
      <title>Re: DQL function replacing splunk command stats list</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-function-replacing-splunk-command-stats-list/m-p/282842#M2397</link>
      <description>&lt;P&gt;Hi, the stats command in Splunk is an aggregation command, in Dynatrace with DQL there are 3 &lt;A href="https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/commands/aggregation-commands" target="_self"&gt;aggregation commands&lt;/A&gt;.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Looking at &lt;A href="https://help.splunk.com/en/splunk-cloud-platform/search/spl2-search-reference/stats-command/stats-command-overview-syntax-and-usage#:~:text=quantity)%2C%20min(quantity)-,The%20results%20look%20like%20this%3A,-count(productId)" target="_self"&gt;this example&lt;/A&gt; in the Splunk documentation, I think something similar can be made using the summarize command with DQL.&lt;/P&gt;&lt;P&gt;I tried making this example in a Notebook, here are the results.&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;fetch logs
| filter matchesPhrase(content, "long transaction")
| parse content, """LD 'type ['LD:type']'"""
| parse content, """LD 'duration ['INT:duration']'"""
| summarize {count(), sum(duration), avg(duration), max(duration), min(duration)}, by:{type} &lt;/LI-CODE&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="angelalanis_1-1754070014813.png" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/29338i727EC2CA90EDE634/image-size/medium?v=v2&amp;amp;px=400" role="button" title="angelalanis_1-1754070014813.png" alt="angelalanis_1-1754070014813.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Let me know if you find this useful.&lt;/P&gt;</description>
      <pubDate>Fri, 01 Aug 2025 17:39:59 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-function-replacing-splunk-command-stats-list/m-p/282842#M2397</guid>
      <dc:creator>angelalanis</dc:creator>
      <dc:date>2025-08-01T17:39:59Z</dc:date>
    </item>
  </channel>
</rss>

