Getting Data In

Calculating bandwidth usage of Windows machines using WMI and Splunk

nk-1
Path Finder

In C:\Program Files\SplunkUniversalForwarder\etc\apps\Splunk_TA_windows\local\inputs.conf:

[perfmon://Network Interface]
counters = Bytes Received/sec;Bytes Sent/sec
instances = *
interval = 10
object = Network Interface
index = wmi

SplunkWeb Query:

earliest=-1d host=MyHost sourcetype="Perfmon:Network Interface" | eval MB_Usage=10*Value/1024/1024| timechart span=1h sum(MB_Usage)

(multiplying by 10 because interval=10 and WMI metric is Bytes/sec?)

Would that give me MB Usage by hour for the given host?

0 Karma

DalJeanis
SplunkTrust
SplunkTrust

Seems reasonable. I'd verify by doing something like this, and checking for reasonableness and number of events ...

earliest=-1d@d+600m latest=-1d@d+610m 
host=MyHost sourcetype="Perfmon:Network Interface" 
| eval MB_Usage=10*Value/1024/1024

You could also do this...

earliest=-1d host=MyHost sourcetype="Perfmon:Network Interface" 
| eval MB_Usage=3600*Value/1024/1024 
| timechart span=1h avg(MB_Usage)

If the value number is per second, then 3600 times that value number is the data per hour at that moment, and the average of those will approximate the total amount that particular hour.

0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...