Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: How to find SSH session in past month
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works.
Could you explain purpose of stats, format?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accelerating Observability as Code with the Splunk AI Assistant
Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...
Congratulations to the 2025-2026 SplunkTrust!
