Splunk Search

How to create a report on storage growth with percentages?

SimonTurton
New Member

I have managed to pull together the following

| mstats max(_value) prestats=true WHERE metric_name="df.used" span=1mon AND host IN (server1.fqdn,server2.fqdn,server3.fqdn, server4.fqdn)
| timechart max(_value) as "max" span=1mon by host

I am struggling to work out how to add a column which shows percentage differences on the previous max value

ideally, I want to produce something like the below

any pointers greatly appreciated!???

  Totals percentage change   percentage change   percentage change   percentage change
  Server1   Server2   Server3   Server4  
2021-12 66.0454   62.2212   58.0469   60.6775  
2022-01 68.8615 4.26% 63.6594 2.31% 58.0931 0.08% 60.6775 0.00%
2022-02 68.0096 -1.24% 57.1727 -10.19% 58.3543 0.45% 60.6775 0.00%
2022-03 69.0297 1.50% 57.5982 0.74% 58.3765 0.04% 60.6775 0.00%
2022-04 74.4503 7.85% 56.7901 -1.40% 58.3883 0.02% 60.6775 0.00%
2022-05 79.0023 6.11% 54.415 -4.18% 58.2995 -0.15% 60.6775 0.00%
2022-06 84.5459 7.02% 54.5954 0.33% 58.3365 0.06% 60.6775 0.00%
Average growth   4.25%   -2.06%   0.08%   0.00%
Labels (1)
0 Karma

VatsalJagani
Champion

@SimonTurton - You can use streamstats command for that.

Your query here
| streamstats current=f window=1 values(Server*) as Prev_Server*
| foreach "Server*" [| eval "Change <<FIELD>>"=round((<<FIELD>>-Prev_<<FIELD>>)*100/Prev_<<FIELD>>,2)]

 

Here is my sample query that I used to test:

| makeresults | eval Server1=66.0454, Server2=62.2212
| append [| makeresults | eval Server1=68.8615, Server2=63.6594]
| append [| makeresults | eval Server1=68.0096, Server2=57.1727]
| streamstats current=f window=1 values(Server*) as Prev_Server*
| foreach "Server*" [| eval "Change <<FIELD>>"=round((<<FIELD>>-Prev_<<FIELD>>)*100/Prev_<<FIELD>>,2)]

VatsalJagani_0-1656582011153.png

 

I hope this helps!!! Upvote/karma would be appreciated!!!

0 Karma
Get Updates on the Splunk Community!

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

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

How I Instrumented a Rust Application Without Knowing Rust

As a technical writer, I often have to edit or create code snippets for Splunk's distributions of ...