Splunk Search

How to fetch weekly data of success failed and warning events and show it daywise in line chart?

athark20
Observer

I am trying to fetch data of weekly successful, failed and warning event counts. I want 5 days data to be shown daywise on line chart. I am using this query. I need modification to show it on line chart which represents date and count of successful, failed and warning events.

Query:

index=outputsolutions host=*dxr22* Error | bin _time span=1d | stats count as dailycount by _time
Labels (3)
0 Karma

athark20
Observer

Can you please help in writing it for me I am a newbie in splunk

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Actually, the correct code should be

| timechart count by status

where status can have three values success, failed, and warning.

Can you describe your data and how to tell whether status is success, failed, or warning?  Without these, everything is just guesswork.

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Do you mean timechart?

| timechart span=1d count by successful failed warning

Obviously you'll need to define "successful", "failed", and "warning" in your search 

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...