Splunk Search

mvexpand is not trimming values

dspracklen
Path Finder

As per my question yesterday, I thought I had all of my problems resolved. I since discovered that when I do mvexpand on the raw data it does not break out the individual values.

Restating the problem from before, I need to group events together and eliminate transactions, and then perform stat functions on the remainder. The suggestions I've seen are to add the mvraw=t option to the transaction command before doing mvexpand.

If I had 42 values in a field called ProblemID from 42 events originally, I would end up with a copy of all 42 values in each of the new events created by mvexpand. I need to either find a way to break the transaction out into the original events or at least just be able to perform stat calls on the raw data as though they were the original events.

Hope that makes sense.

EDIT Nevermind. I see now that the transaction command is NOT going to be useful to me in this instance. The problem is that for each event for a given asset there is a value associated with it. I need to sum those values up, but transaction will combine like values and thus give me a wrong answer when I act on the compressed information. I will probably just have to just have a very long-running search and deal with it. (this is a scheduled search anyway)

Tags (2)
0 Karma
1 Solution

dspracklen
Path Finder

Please see the edit section in the question. I realized this whole method is flawed anyway, so the question has become irrelevant. Sorry.

View solution in original post

0 Karma

dspracklen
Path Finder

Please see the edit section in the question. I realized this whole method is flawed anyway, so the question has become irrelevant. Sorry.

0 Karma
Get Updates on the Splunk Community!

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...