Need Help to pull the logs in the below format

[mputtam]

Hi Community,

I was trying to pull the logs  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.

Used Query EX : index="notable" search_name="XXXXXXXXXXXXXX" | stats count by _time app src dest src_port dest_port |

[richgalloway]

When you run the search without the stats command do you get values for the app, src, dest, src_port, and dest_port fields? If any are null then stats will not return results. Use fillnull as necessary.