Splunk Search

mvexpand acts like a filter?

responsys_cm
Builder

I'm building an app to manage Nessus vulnerability data and grab CVE data from the National Vulnerability Database (NVDB). The search does the following:

Searches for all Nessus plugin scripts

Dedupes events by Nessus ID

Replaces a number of field values to make them human readable

Performs a lookup by Nessus ID and returns any CVE IDs associated with the plugin

Some plugins have one or more CVE IDs. Some don't have any. When I pipe that search to the mvexpand command, events without CVE IDs disappear from the search results.

Is there an easy way to make the mvexpand command conditional only on events that have a CVE ID?

Thanks.

Craig

Tags (1)
0 Karma

vbumgarner
Contributor

This is old, so I'm sure you've figured it out, but a question deserves an answer...

You need to use

fillnull value="-" CVEID 

before the mvexpand to not lose records that have no CVEID value.

Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...