Splunk Search

Display CPU Utilization per host per time using +Add Inputs from Edit Dashboard

hishamjan
Explorer

Hi,

below is the timechart for my search to display CPU utilization of my forwarders and indexerScreenshot 2021-03-02 at 1.46.20 PM.png

Using the host dropdown box, I would like to search for an individual host at a time to display its memFreePct and memUsedPct over a specific period of time (using Time dropdown box). 

The search query is as follows:

 

source="vmstat"
            | dedup host 
 | eval host=upper(host)
            | eval FreeGBs=FreeMBytes/1024, TotalGBs=TotalMBytes/1024, UsedGBs=UsedMBytes/1024
            | table host memFreePct memUsedPct

 

 

Is there a way I can edit this search query to be able to find timechart graph for only one host at a time using the dropdown box?

The search query in the Host dropdown box is as follows:

 

sourcetype=vmstat
| dedup host
|table host

 

 

Thanks in advance for the help.

 

Regards

Labels (5)
0 Karma

jodonald
Explorer

Hi @hishamjan 

You will need to add a field to your search query to include the selected host from your dropdown.

For example, if the token from the dropdown was named "selected_host" then you would modify the search query for the panel to be:

source="vmstat" host=$selected_host$
            | dedup host 
 | eval host=upper(host)
            | eval FreeGBs=FreeMBytes/1024, TotalGBs=TotalMBytes/1024, UsedGBs=UsedMBytes/1024
            | table host memFreePct memUsedPct

 

And you will need to modify the dropdown to assign a value or an "*" (for no selected hosts) to the token "selected_host".  the Splunk documentation for Create and edit forms would be a great place to review those settings.

One more thing to consider, if you want to view the data over time, then you will probably want to modify the search query for your panel to be populated by a timechart instead of eval/table.

 

source="vmstat" host=$selected_host$
| eval host=upper(host)
| eval FreeGBs=FreeMBytes/1024, TotalGBs=TotalMBytes/1024, UsedGBs=UsedMBytes/1024
|timechart avg(memFreePct) as memFreePct, avg(memUsedPct) as memUsedPct by $selected_host$

 

Hope that helps.

0 Karma
Get Updates on the Splunk Community!

Routing Data to Different Splunk Indexes in the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...

Getting Started with AIOps: Event Correlation Basics and Alert Storm Detection in ...

Getting Started with AIOps:Event Correlation Basics and Alert Storm Detection in Splunk IT Service ...

Register to Attend BSides SPL 2022 - It's all Happening October 18!

Join like-minded individuals for technical sessions on everything Splunk!  This is a community-led and run ...