cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question
naveenalagu
Explorer
Member since: ‎07-22-2018
‎09-18-2023
Community Statistics
Posts 5
Solutions 0
Karma Given 2
Karma Received 0
Member Since ‎07-22-2018
Activity Feed
View All

How to rearrange columns in the .csv that is creat...

by in Dashboards & Visualizations
‎03-01-2023 04:17 AM
‎03-01-2023 04:17 AM
Hi, As the query states, I have a stats command that gives me a table with all the required columns. While viewing the stats during search, using table command I am able to reorder the columns to the desired view. However, when I write the output to a csv using outputlookup, the columns get re arranged in alphabetical order of their names. Is there any way we can override this? Thanks for the help! ... View more
Labels

Re: How to calculate the total count of occurances...

by in Splunk Search
‎02-02-2023 07:45 AM
‎02-02-2023 07:45 AM
Thanks! That did the trick.🙂 ... View more

Re: How to calculate the total count of occurances...

by in Splunk Search
‎02-02-2023 02:58 AM
‎02-02-2023 02:58 AM
Thanks a lot for this. However, the Table comes out with repeated values for Year and Month.  DEDUP seems to remove entries of other Columns as well. Is there any way to remove those duplicates? Thanks in advance! ... View more

Re: How to calculate the total count of occurances...

by in Splunk Search
‎02-02-2023 02:54 AM
‎02-02-2023 02:54 AM
Just to point out: the desired output your illustrated is not "occurrences of CCYY then MM then DD," but occurrences of CCYY, then CCYYMM, then CCYYMMDD.   This is correct. I would have to further drill down to HH MM SS as well, which would be CCYYMMHHMMSS.  Thanks for the info.  Additionally, 2022-27 is not a very good illustration of Month. Apologies for this.  ... View more

How to calculate the total count of occurances of ...

by in Splunk Search
‎02-01-2023 05:47 PM
‎02-01-2023 05:47 PM
Basically I have a set of raw data with different time stamp in CCYYMMDDHHMMSS format. I want to list out the stats which shows how many occurrences of CCYY then MM then DD . I am able to use STRFTIME to get the segregate the data into desired format as year month and day. My expected result output is Year Year Count Month Month Count Day DayCount 2022 1000 2022-11 250 2022-11-27 20 2023 10 2022-12 100 2022-11-12 5         2022-11-27 35 I used the below |stats count as total by year, month day But the actual output is not as expected Year Year Count Month Month Count Day DayCount 2022 20 2022-11 20 2022-11-27 20 2022 5 2022-12 5 2022-11-12 5 2022 35 2022-27 35 2022-11-27 35   Should be simple enough, just not for me. Please help. Thanks! ... View more
Labels
Contact Me
Online Status
Offline
Date Last Visited
‎09-18-2023 01:28 AM
Karma given to
View All