This supporting add-on (SA) for Splunk enables lookup of MAC address field to IEEE registered vendor information and the ability to identify assets by subnet mask. Additional capabilities such as normalization of MAC address are also provided per Splunk Common Information model http://docs.splunk.com/Documentation/CIM/latest/User/NetworkTraffic. App comes with sample dashboards to showcase how to use both the mac normalization configuration and subnet conversion kit. Both can be safely hidden without impacting functionality; details on hiding an app are described at: http://docs.splunk.com/Documentation/Splunk/latest/AdvancedDev/ShareYourWork#Set_visibility

Mapping information is obtained from IEEE, found at http://standards.ieee.org/regauth/oui/oui.txt. Additional detail can be found at http://standards.ieee.org/faqs/regauth.html

This project is hosted on GitHub, see https://github.com/hire-vladimir/SA-NetOps

App installation is simple, and only needs to be present on the search head. Documentation around app installation can be found at http://docs.splunk.com/Documentation/AddOns/released/Overview/Singleserverinstall

Lookup mac_vendor_lookup takes mac address an input argument; it performs a case insensitive "starts with" match on the mac field to determine vendor information. mac field is expected to be normalized per http://docs.splunk.com/Documentation/CIM/latest/User/NetworkTraffic, to help with this effort macro normalize_mac_address is provided.

Lookup subnet_to_cidr takes another Lookup vlan_inventory as an input argument; it performs an exact match to determine the cidr_notation based on subnet_mask. The user should run the search to manually generate the cidr_network lookup once they have loaded all of thier subnet information into the vlan_inventory lookup. Once both steps are complated Splunk will automagically begin tagging all src_ip or dest_ip events with the matching environment information.

The TCP/IP layer 2 Media Access Control (MAC) address of a packet's source/destination, such as 06:10:9f:eb:8f:14. Note: Always force lower case on this field. Note: Always use colons instead of dashes, spaces, or no separator.

| inputlookup vlan_inventory | lookup subnet_to_cidr subnet_mask OUTPUT cidr, binary_mask, host_count, usable_hosts | eval cidr_address= network+cidr  | outputlookup cidr_network

Note: Lookup data is static, as in, it is refreshed every app release. It's possible to setup more frequent data refresh, by running the following:

splunk cmd python SA-NetOps/bin/ieee_oui_parser.py > SA-NetOps/lookups/mac_vendor_lookup.csv

The app was tested on Splunk 6.2+ on CentOS Linux 7.1, SUSE Linux Enterprise Server 11.4/12.3, and Ubuntu 16.04.

... | `normalize_mac_address(mac)` | lookup mac_vendor_lookup mac OUTPUT mac_vendor, mac_vendor_address, mac_vendor_address2, mac_vendor_country | ...

| makeresults | eval mac1="11-22-33-44-55-66", mac2="2233.455.6677" | macformat format=ieee inputs="mac1,mac2"

Options for format are: cisco, dash, ieee, and none.

The inputs option is a list of comma-delimited fields in the incoming data. It defaults to macadderss unless otherwise configured.

[macformat]
format=none
inputs=macaddress

| localop | stats count | fields - count | eval src_mac="cc-20-e8-01-ab-3f" | `normalize_mac_address(src_mac)` | lookup mac_vendor_lookup mac AS src_mac OUTPUT mac_vendor, mac_vendor_address, mac_vendor_address2, mac_vendor_country

• Splunk is a registered trademark of Splunk, Inc.