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

hishamjan — Tue, 02 Mar 2021 08:52:50 GMT

Hi,

below is the timechart for my search to display CPU utilization of my forwarders and indexer

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

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

jodonald — Tue, 02 Mar 2021 14:59:18 GMT

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.

topic Re: Display CPU Utilization per host per time using +Add Inputs from Edit Dashboard in Splunk Search

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

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