Splunk Search

Why are stats values and data not aligning?

AK89
Explorer

In this scenario, each HOST_NAME has many HOME_LOCATIONS. Each HOME_LOCATION has unique info - in this case, the RDBMS_VERSION and the DATABASE_RELEASE.

I am trying to produce a simple statistics table that shows each unique HOME_LOCATION (and accompanying info) for each HOST_NAME. 

--------------------

When I run the below (1st screen shot) the data is aligned as I'd expect it to

| stats values(HOME_LOCATION) values(RDBMS_VERSION) by HOST_NAME

2 fields.png

When I run the below (2nd screen shot) and add the third values field in red, the data becomes misaligned for some rows

| stats values(HOME_LOCATION) values(RDBMS_VERSION) values(DATABASE_RELEASE) by HOST_NAME

3 fields.png

What am I missing or doing incorrectly?

Labels (1)
Tags (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

values() shows the unique values sorted in lexicographical order - if you want to maintain a one-to-one correspondence use list() instead of values() however this does not dedup the values so you may end up with duplicates.

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

values() shows the unique values sorted in lexicographical order - if you want to maintain a one-to-one correspondence use list() instead of values() however this does not dedup the values so you may end up with duplicates.

AK89
Explorer

Appreciate the quick response! This works. As for dupes, my data is pulled in on a scheduled basis, so I can use the time range to handle dupes. Thank you!

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...