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!

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

Data Management Digest – May 2026

Welcome to the May 2026 edition of Data Management Digest!   As your trusted partner in data innovation, the ...