Are you a member of the Splunk Community?
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: How to remove the timezone from my field in a ...
- 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'm fetching the data from a CSV file, but the issue with my data is that some of the values are in PDT and some are in PST.
The format is 2016-06-15 04:55 PM PDT. I just want all these values to be of same zone minus the time zone at the end. I want to display my data over a timechart.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
| inputlookup xxx.csv | eval time=strptime(your_time_field,"%Y-%m-%d %H:%M %p %Z") | bin span=15m time | stats count by time | eval time=strftime(time, "%c")
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
| inputlookup xxx.csv | eval time=strptime(your_time_field,"%Y-%m-%d %H:%M %p %Z") | bin span=15m time | stats count by time | eval time=strftime(time, "%c")
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hope this can help:
|inputlookup xxx.csv | eval _time=strptime(your_time_field,"%Y-%m-%d %H:%M %p %Z") | timechart span=5m count
the display time zone will be the user time zone, same as server time zone by default
the time format could be found in
http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Commontimeformatvariables
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For some strange reason it is not showing any results.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
could you remove |timechart span=5m count, and check if the _time is parsed correctly?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
After I changed the name of my time field, _time is getting parsed.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Could you post your current search? Is the data from CSV being ingested to Splunk OR being used as lookup table OR direct csv access (inputcsv)?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am using inputlookup
Thanks for the Memories! Splunk University, .conf25, and our Community
Data Persistence in the OpenTelemetry Collector
Introducing Splunk 10.0: Smarter, Faster, and More Powerful Than Ever
