Splunk Search

Nessus data charting- How to make a trend chart of specific data set?

jenkinsta
Path Finder

I am making a trend chart of specific data set. What I am looking for is (generic example)

index=nessus | eval Month=strftime(firstSeen,"%b") | chart count by severity Month

So the end result would be Months on the X axis and the count of severity (critica,high,medium) for each month. Each month would have a count of each severity.  But using the firstseeen date from the date event. 

Labels (3)
0 Karma
1 Solution

yeahnah
Motivator

Hi @jenkinsta 

I think timechart would be better suited for this.  Something like

index=nessus
| timechart span=1month count BY severity 

 The counts are group by month then

Hope that helps

View solution in original post

yeahnah
Motivator

Hi @jenkinsta 

I think timechart would be better suited for this.  Something like

index=nessus
| timechart span=1month count BY severity 

 The counts are group by month then

Hope that helps

jenkinsta
Path Finder

Thanks, I can do it by the time of the event but what I am looking for is by the firstSeen value from the event itself. 

 

eval FirstSeenMonth=strftime(firstSeen,"%b")

How can I group by FirstSeenMonth or is there something else I need to do before I do any charting?

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...