Splunk Search

How can I pass a variable to the tail command?

terryloar
Path Finder

...
| tail 200

works fine.
...
| eval tail_value=200
| tail tail_value

throws this error:
Error in 'tail' command: The number of results must be a positive number.

I've used tokens as the tail argument but a simple variable is not recognized. For example:
...
| tail $token_from_dropdown$

works.

We've written a cumbersome work-around, but I know I'm missing the simple solution.

Thanks.

0 Karma
1 Solution

jhupka
Path Finder

One possibility is to get the dynamic value via a subsearch:

index=_internal | tail [ | stats count | eval search=10 | fields search ]

That will effectively expand to a search that looks like this:

 index=_internal | tail ((10))

So in your case just come up with a subsearch that dynamically obtains your value.

View solution in original post

0 Karma

jhupka
Path Finder

One possibility is to get the dynamic value via a subsearch:

index=_internal | tail [ | stats count | eval search=10 | fields search ]

That will effectively expand to a search that looks like this:

 index=_internal | tail ((10))

So in your case just come up with a subsearch that dynamically obtains your value.

0 Karma

terryloar
Path Finder

Good, simple solution. Thanks.

0 Karma
Get Updates on the Splunk Community!

Fall Into Learning with New Splunk Education Courses

Every month, Splunk Education releases new courses to help you branch out, strengthen your data science roots, ...

Super Optimize your Splunk Stats Searches: Unlocking the Power of tstats, TERM, and ...

By Martin Hettervik, Senior Consultant and Team Leader at Accelerate at Iver, Splunk MVPThe stats command is ...

How Splunk Observability Cloud Prevented a Major Payment Crisis in Minutes

Your bank's payment processing system is humming along during a busy afternoon, handling millions in hourly ...