Splunk Enterprise Security

Vulnerbaility data model information is mismatch with datamodel acceleration

raghu_yara
New Member

Hi,

using this query
| from datamodel:"Vulnerabilities"."Vulnerabilities" |stats count by signature getting result 234
using this query
| tstats summariesonly=true values(Vulnerabilities.signature) as vuln_count from datamodel=Vulnerabilities.Vulnerabilities
| mvexpand vuln_count
getting result 194.
So that dashboards are getting wrong information Splunk enterprise security app. Please help me where I did mistake.

0 Karma

xpac
SplunkTrust
SplunkTrust

The values() option only gives you each value once.
If signature exists more than once, it's only contained once in the result (like an implicit dedup). Therefore, you might less results than by simply counting them.
Use list() instead of values(), that should fix it.

Hope that helps.

Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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