topic Re: Creating a parameterized transaction search in Splunk Search

Creating a parameterized transaction search

Justin_Grant — Mon, 15 Mar 2010 13:13:55 GMT

Our office has a specific TRANSACTION search we do frequently to track all events related to a particular user. The search is always the same except for the user ID, which the Splunk user copies in from an email.

What's the best way to store the search so that I can quickly call it from the search bar but plug in the Session ID I want to restrict results to?

I guess I could use a macro and stick a | WHERE after it, but I was wondering if there was a more proper/efficient or proper way to do it.

I see there's a "transaction type" feautre I can use-- is this the right solution?

I also know I can do a Form Search but in this case we want to use the "plain" search bar.

Re: Creating a parameterized transaction search

Glenn — Mon, 15 Mar 2010 20:30:50 GMT

A Form search definitely sounds like what you are a looking for...

What is the reason you want to use the "plain" search bar rather than a form search? If it is because of the way that the simple form search displays its results, then you can get around this. The simple form search results page also does not meet my requirements, and I prefer the flashtimeline view, so I built an advanced form search which redirects to the flashtimeline view, with the "plain" search bar at the top now filled out with the actual search syntax (passed from the form search).

If this sounds like what you are after, let me know and I'll explain further how to do it.

Re: Creating a parameterized transaction search

gkanapathy — Tue, 16 Mar 2010 08:46:49 GMT

You can use transactiontypes, but I suggest you use saved searches. You don't have to use them with form searches, but you can easily convert this:

sourcetype=blah sessionid=$sessid$ | transaction startswith="blah" endswith="yadda" fields=sessionid

And invoke it with:

| savedsearch "Name you saved it under" sessid="id123456"

Re: Creating a parameterized transaction search

Justin_Grant — Wed, 17 Mar 2010 01:02:40 GMT

as usual, great answer! out of curiosity, why are transaction types not recommended in this scenario?

Re: Creating a parameterized transaction search

Justin_Grant — Wed, 17 Mar 2010 01:08:03 GMT

Hi Glenn, mostly I'm trying to avoid the complexity of having a separate view just for this. Want to keep things simple. But I like your idea of redirection. Want to post this as an example on Splunkbase.com?

Re: Creating a parameterized transaction search

gkanapathy — Wed, 17 Mar 2010 01:09:12 GMT

Seems redudundant to me, and there's such a thing as over-abstraction. If you're not using the same transaction type in lots of different places, there isn't any point. You've already got the transaction defined in the saved search. Why make it harder to edit?