How to find SSH session in past month

[disasters]

I want to know that there are or not SSH sessions which is in last 5 minutes in past 1 month. (except today)

- I want to compare srcip and dstip

- Time range picker (last 5 minutes)

index=fw AND dstport=22 NOT [ search  index=fw AND dstport=22 earliest=-1mon@mon latest=-1day@day | fields + srcip, dstip]
| dedup srcip, dstip
| table _time, srcip, dstip, dstport, protocal, action, hostname

this is not working correctly.

[disasters]

It works.

Could you explain purpose of stats, format?

[manjunathmeti]

stats is used as dedup to remove duplicate records and format is used to convert results into a single linear search string.

More on format here: https://docs.splunk.com/Documentation/SplunkCloud/latest/Search/Changetheformatofsubsearchresults#Ch...

[manjunathmeti · Accepted solution]

Hi @disasters 

Try this query,

index=fw dstport=22 NOT [ search  index=fw dstport=22 earliest=-1mon@d latest=-1d@d  | stats count by srcip, dstip |  fields srcip, dstip | format]
| dedup srcip, dstip
| table _time, srcip, dstip, dstport, protocal, action, hostname

If this reply helps you, an upvote/like would be appreciated.