Refine your search:

Hi,

I have three indexes that I'm trying to build a transaction from. the first two indexes each have a field named User_Name, which makes the transaction statement pretty easy. This creates the base transaction I'm looking for.

The first index also has a field called ip. What I want to do is use this field to retrieve the events from the third index into the first transaction (unfortunately the User_Name field does not exist in the third index). I've tried so many different searches, all never result in a transaction containing all the pertinent records.

Any thoughts on how to create this type of transaction?

Thanks!!

asked 25 Mar '11, 02:36

castle1126's gravatar image

castle1126
1893418
accept rate: 0%

What does your data look like? Is the username completely missing from the third index, or just not extracted into that field?

(25 Mar '11, 13:36) southeringtonp ♦

The username field does not exist from the third index.

(07 Apr '11, 16:38) castle1126

What fields do exists in the third index that might be used to unite those events with events from one of the first two indexes? A subsearch or double-transaction might work.

(23 Aug '11, 14:12) sdwilkerson

2 Answers:

I am also keen to see what the data looks like as mentioned by southeringtonp. Have you thought about doing data enrichment using a lookup of some unique data and then using the new field to transact on.

link

answered 07 Apr '11, 15:00

b4ggio's gravatar image

b4ggio
233
accept rate: 0%

Maybe this isn't the best place to ask this question but I'll try anyway.

Can I transaction span multiple indexes and multiple sourcetypes? It seems like it can but I thought I would ask to verify it.

Curt

link

answered 28 Sep '11, 12:47

curtgran's gravatar image

curtgran
301
accept rate: 0%

Curtgan, Yes, this isn't the right place, you should really have started a new question. But the answer to your question is, yes, transaction doesn't care so long as the time settings and field are right.

(28 Sep '11, 13:22) sdwilkerson
Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×171

Asked: 25 Mar '11, 02:36

Seen: 1,147 times

Last updated: 28 Sep '11, 13:22

Copyright © 2005-2012 Splunk Inc. All rights reserved.