×

Are you a member of the Splunk Community?

Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question
mcastino
New Member
Member since: ‎07-30-2018
‎06-05-2020
Community Statistics
Posts 3
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎07-30-2018
Activity Feed
View All

Re: Why does the date format in scheduled csv repo...

by in Getting Data In
‎08-20-2019 01:38 AM
‎08-20-2019 01:38 AM
Thanks, will see how it goes! ... View more

Why does the date format in scheduled csv report c...

by in Getting Data In
‎08-19-2019 06:55 PM
‎08-19-2019 06:55 PM
I have made a scheduled report which emails a csv file containing counts of particular events for each day in the last seven days. The format looks a little like this: Date - X, Y, Z 2019-08-12 - 5, 6, 8 2019-08-13 - 10, 8, 7 2019-08-14 - 2, 1, 1 The output in the Splunk UI shows dates correctly ( | fieldformat Date= strftime(Date, "%Y-%m-%d" ), and when I download a CSV report manually the dates also look fine. However, in the scheduled report sent via email, dates are presented as below: Date 1565532000 1565618400 1565704800 1565791200 1565877600 1565964000 1566050400 Any thoughts on what's going on here? Thanks! ... View more

Perform numerical calculations on field containing...

by in Splunk Dev
‎07-30-2018 04:35 PM
‎07-30-2018 04:35 PM
Hi all, new to splunk so apologise for such a simple question. I have a field called "options.deposit.amount" containing deposit amounts that Splunk is treating as string because value is preceded by $ sign. I'd like to be able to convert to numeric values so that I can perform calculations but am having trouble. Data comes in the format of $XX.xx with no commas or spaces. I have tried this with no success: search| eval Dep_Amt = substr(options.deposit.amount,2) Any help with be greatly appreciated. Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-05-2020 02:04 AM