Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- how do I clac time out using eval
- 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
in,out,name
05-06-2015 11:37:04,05-06-2015 11:37:04 ,uid2
05-06-2015 11:36:06,,uid2
how do I do this,
If out time is not in the event and
OUT time > (current_time + 1hr) then mark status as TIMEOUT
lets say now is 05-06-2015 12:47:00 then expected output should be as
==================================
in,out,name
05-06-2015 11:37:04,05-06-2015 11:37:04 ,uid2 -> expected is -> LOGOUT
05-06-2015 11:36:06,,uid2 -> TIMEOUT
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Based on your comment:
OUT time > (current_time + 1hr) then mark status as TIMEOUT else 'ACTIVE'
This is the search (but it doesn't make any sense to me because now event should "happen after" now()):
... | eval outEpoch= strptime(out, "%m-%d-%Y %H:%M:%S") | eval status=if(outEpoch > (now() + 60*60), "TIMEOUT", "ACTIVE")
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Based on your comment:
OUT time > (current_time + 1hr) then mark status as TIMEOUT else 'ACTIVE'
This is the search (but it doesn't make any sense to me because now event should "happen after" now()):
... | eval outEpoch= strptime(out, "%m-%d-%Y %H:%M:%S") | eval status=if(outEpoch > (now() + 60*60), "TIMEOUT", "ACTIVE")
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Like this (probably not exactly what you need but I am having trouble comprehending your example; this should get you started anyway):
... | eval status=if(isnull(out), "TIMEOUT", "LOGOUT") | table in out name status
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
OUT time > (current_time + 1hr) then mark status as TIMEOUT else 'ACTIVE'
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Manage Edge Processor pipelines end to end with APIs
Splunk Brings Proof of Control to Digital Asset Transfers
Manage Ingest Processor pipelines end to end with APIs
