Splunk Dev

Field data ends with elipsis...how do I get the rest?

claatu
Explorer

I do a search query where one of the fields returned has semicolon-separated values. For example, "Alpha;Beta;delta". The field sometimes has a large number of values, and the last one ends with dot-dot-dot, for example: ";blue;red..."

I know from the source feeding this that the field has more values than are being shown in Splunk. So I think Splunk is just truncating and not showing the rest of the values. Is it possible to get the full amount of data, or is that being truncated at the point of the feed? Is there a solution to this?

Tags (1)
0 Karma
1 Solution

DalJeanis
Legend

One way to test this is

 your search that gets some of these
 | head 5 
 | makemv myfield delim=";"
 | mvexpand myfield

That will take the first five records, change that field into an official multivalue field, then fan out the records so that there is one record per value in that field, with the remainder of fields retained.

Once you review those, you will know whether the data is still there.

View solution in original post

0 Karma

DalJeanis
Legend

One way to test this is

 your search that gets some of these
 | head 5 
 | makemv myfield delim=";"
 | mvexpand myfield

That will take the first five records, change that field into an official multivalue field, then fan out the records so that there is one record per value in that field, with the remainder of fields retained.

Once you review those, you will know whether the data is still there.

0 Karma

claatu
Explorer

Have already done that. That is how I know for sure that the list of items is incomplete.

0 Karma

claatu
Explorer

OK, We can close this question. I saw the details of the feed mechanism, where it states: "These fields are limited to 1250 characters. If such a field has been truncated, the field's value will end with an ellipsis ("...")."

So, I guess there is no getting the full data, as it is not even making it into Splunk.

Thanks for considering it.

Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

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

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...