topic Re: SPL for displaying overview panel in splunk app for infrastructure. in All Apps and Add-ons

SPL for displaying overview panel in splunk app for infrastructure.

nathanluke86 — Mon, 11 Nov 2019 13:27:51 GMT

I'm hoping someone could help.

I would like to create a dashboard for one of our hosts similar to the Splunk app for infrastructure overview page (as in screenshot below).

We are indexing as metrics (index=em_metrics) and would like to create the panels shown below.

Thanks

Re: SPL for displaying overview panel in splunk app for infrastructure.

aberkow — Mon, 11 Nov 2019 18:11:40 GMT

Hi - are you able to find it by looking at the xml for the dashboard in {SplunkMachineName}{SplunkPath}\etc\apps\app(default|local)\ui\views?

Re: SPL for displaying overview panel in splunk app for infrastructure.

dagarwal_splunk — Wed, 30 Sep 2020 02:55:14 GMT

I think you are looking for SPLs to use for your dashboard i.e "mstats" command: https://docs.splunk.com/Documentation/Splunk/8.0.0/SearchReference/Mstats
You can use commands like mstats, mcatalog to look into em_metrics index.

Sample SPL for your dashboard:
| mstats avg(memory.free) WHERE index=em_metrics AND host=xyzz span=1m

You can split the above search by any dimension.
To get the list of dimensions:
| mcatalog values(_dims) WHERE index=em_metrics AND host=xyzz

You can pipe it to timechart to produce a chart: https://docs.splunk.com/Documentation/Splunk/8.0.0/SearchReference/Timechart

Re: SPL for displaying overview panel in splunk app for infrastructure.

nathanluke86 — Wed, 30 Sep 2020 02:56:30 GMT

Hi @dagarwal_splunk,

I have been using the mstats command to create metrics dashboards etc but what I cant seem to figure out is how the CPU is calculated. I cant seem to get the same result. I am not sure what metric_name is used to get the required result CPU used %.

Only metrics are:

Process.%_Privileged_Time
Process.%_Processor_Time
Process.%_User_Time
Processor.%_C1_Time
Processor.%_C2_Time
Processor.%_Idle_Time
Processor.%_Interrupt_Time
Processor.%_Privileged_Time
Processor.%_Processor_Time
Processor.%_User_Time

Thanks

Re: SPL for displaying overview panel in splunk app for infrastructure.

dagarwal_splunk — Wed, 30 Sep 2020 02:55:28 GMT

You should use Processor.%_Processor_Time for Cpu utilization.
See this to learn more about this metric: https://social.technet.microsoft.com/wiki/contents/articles/12984.understanding-processor-processor-time-and-process-processor-time.aspx
Processor - % Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the percentage of time that the processor spends executing the idle thread and then subtracting that value from 100%. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval.