Splunk Search

multiple field conversions in a search eg kb to Mb

Conradj
Path Finder

Hi,

I have multiple fields returned in a search that I to plot as separate lines on a line graph. however, both fields are by default provided in bytes. I want to convert both in megabytes for the plot

Data might be for example...
time=12:00:00, memUsage=194433567, memPeak=1949456694

i can use | eval current=(memUsage/1024/1024)

But how do I convert the second? before going onto define the chart? (I am sure that its something very simple, but so far it has escaped me)

Cheers,

C.

Tags (3)
0 Karma
1 Solution

gkanapathy
Splunk Employee
Splunk Employee

Something like:

<search_term> | eval current=(memUsage/1024/1024) | eval peak=memPeak/1048576 | timechart span=1h avg(current), max(peak)

?

View solution in original post

gkanapathy
Splunk Employee
Splunk Employee

Something like:

<search_term> | eval current=(memUsage/1024/1024) | eval peak=memPeak/1048576 | timechart span=1h avg(current), max(peak)

?

Conradj
Path Finder

(argh) Thank you 🙂

My error was in defining the chart to use two fields, not the conversion.

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...