Splunk Search

SLA Line on Chart

hartfoml
Motivator

I am using this search to get license use over 30 days

 index="summary_indexers" | timechart partial=f span=1d sum(kb) as KB | eval gb=round(KB/1048576,1) | convert timeformat="%A - %m/%d" ctime(_time) AS DATE | table DATE gb

This gives ma b bar chart with one bar per day.

I would like to put a RED SLA line at the license limit so that the managers can clearly see where the License SLA will be violated and how close we are to that line.

Tags (2)
1 Solution

dwaddle
SplunkTrust
SplunkTrust

Except for the RED part (which is configurable as part of the viewstate / dashboard config), this search adds in your SLA line:

index="summary_indexers" 
| eval sla=20 
| timechart partial=f span=1d sum(kb) as KB,max(sla) as SLA 
| eval gb=round(KB/1048576,1) 
| convert timeformat="%A - %m/%d" ctime(_time) AS DATE 
| table DATE gb SLA

View solution in original post

0 Karma

dwaddle
SplunkTrust
SplunkTrust

Except for the RED part (which is configurable as part of the viewstate / dashboard config), this search adds in your SLA line:

index="summary_indexers" 
| eval sla=20 
| timechart partial=f span=1d sum(kb) as KB,max(sla) as SLA 
| eval gb=round(KB/1048576,1) 
| convert timeformat="%A - %m/%d" ctime(_time) AS DATE 
| table DATE gb SLA
0 Karma

hartfoml
Motivator

Thanks that did it

0 Karma

kamal_jagga
Contributor

Hi,

I have 10 services being displayed in a single chart. And i want to project 10 different SLAs for the different services.
If i use the below method, it gives me same sla for all.
| eval sla=20

Is there any way to do it.

Kindly advise.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

How Edge Processor's Durable Queue Works

Edge Processor sits in one of the most consequential places in any Splunk pipeline: between your data sources ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Quantify Your Splunk Investment Impact: Introducing Savings Metrics to Value Insights

Building on the foundation established in our initial Value Insights releases, we are introducing the Savings ...