https://community.splunk.com/t5/Splunk-Search/Need-Help-to-pull-the-logs-in-the-below-format/m-p/513592#M144110 <P>When you run the search without the <FONT face="courier new,courier">stats</FONT> command do you get values for the app, src, dest, src_port, and dest_port fields? If any are null then <FONT face="courier new,courier">stats</FONT> will not return results. Use fillnull as necessary.</P> Tue, 11 Aug 2020 15:19:22 GMT richgalloway 2020-08-11T15:19:22Z https://community.splunk.com/t5/Splunk-Search/Need-Help-to-pull-the-logs-in-the-below-format/m-p/513575#M144099 <P>Hi Community,</P><P>I was trying to pull the logs&nbsp; in the following format _time, src, dest, src_port, dest_port by using stats command. but i could not able to get the source port and the destination port details in the results. Please help me out with the query.</P><P>&nbsp;</P><P>Used Query EX :&nbsp;index="notable" search_name="XXXXXXXXXXXXXX" | stats count by _time app src dest src_port dest_port |</P> Tue, 11 Aug 2020 13:30:10 GMT https://community.splunk.com/t5/Splunk-Search/Need-Help-to-pull-the-logs-in-the-below-format/m-p/513575#M144099 mputtam 2020-08-11T13:30:10Z https://community.splunk.com/t5/Splunk-Search/Need-Help-to-pull-the-logs-in-the-below-format/m-p/513592#M144110 <P>When you run the search without the <FONT face="courier new,courier">stats</FONT> command do you get values for the app, src, dest, src_port, and dest_port fields? If any are null then <FONT face="courier new,courier">stats</FONT> will not return results. Use fillnull as necessary.</P> Tue, 11 Aug 2020 15:19:22 GMT https://community.splunk.com/t5/Splunk-Search/Need-Help-to-pull-the-logs-in-the-below-format/m-p/513592#M144110 richgalloway 2020-08-11T15:19:22Z