Splunk Enterprise

How to filter value greater than threshold with multiple fields?

splunkkid
Path Finder

Hello,

I made splunk command to predict ip usage per each data center.

The current command and results are like below.

 

<COMMAND>

 

 

 

MY_SEARCH
| eval usage=round(used/total*100, 2)
| timechart span=1d limit=0 values(usage) by center
| predict [search MY_SEARCH Which makes same center list above | stats values(center) as center| rename center as search ] algorithm="LLP5", future_timespan=90
| fields _time, prediction(*)
| rename prediction(*) as *

 

 

 

 

<RESULTS>

_time                       center1     center2     center3     center4

2021/06/03           78                  82              75                   54

2021/06/04           78.023         82.21       75.23             55.323

...

 

Like above, the results show me how usage would be increased or decreased based on prev usage value.

Now, I need to make alert trigger with this result to predict which center would need more ip list before it gets full.

Like, I want to check if it increased to more than 95% in 3months. 

 

How can I make that happen?

Thank you!

Labels (2)
0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.