Refine your search:

Hi,

Ok at this point I can barely spell SPLUNK but I have gone through a bootcamp course and I'm trying to pull off my first assignment to correlate between two logs.

I have login data like username, AssignedIP, time/date in one log. I have outbound src_ip dest_ip traffic and time/date in another log. I know when a user is assigned an IP but I don't know when they stop other than seeing a new event assigning the IP to a different user.

AssignedIP = src_ip, is the link across the data sources but only within the time period that the user had the IP address.

I have two use cases: 1. Show me all the traffic for a particular user 2. Find the user that generated this traffic

I may have to specify the time and date and not just the last X days/weeks etc.

Can someone point me in the right direction how to build this search and correlate the data? Is this is better as a subsearch or a transaction. I know transactions are more costly but not sure when they are better to use.

Thanks for any help. Sorry for the newbie questions

Curt

asked 27 Jul '11, 07:35

curtgran's gravatar image

curtgran
301
accept rate: 0%

edited 27 Jul '11, 07:38


2 Answers:

Have you looked at the command transaction?

link

answered 28 Jul '11, 09:49

fk319's gravatar image

fk319
469212
accept rate: 22%

Yes, I have looked at transactions. And I've been trying to figure out how it works. I've looked at a lot of examples but they all seem to use the same log where I'm trying to go across multiple logs. My biggest issue is figuring out what exactly you put in the transaction command to tie fields together.

Maybe it's because the fields are not the same name in each log. If that's the case I have to figure out how to either redefine, rename or create duplicates with the same name.

Curt

link

answered 02 Aug '11, 08:07

curtgran's gravatar image

curtgran
301
accept rate: 0%

search <multiple logs=""> | transaction maxspan=5m field.

I suppose you knew that already, what you need is to have a common field between the logs. You will need to the rex command to help you along here. Usually there is some identifier, like ID or client ip.

(05 Aug '11, 10:39) fk319
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:

×212
×172
×47

Asked: 27 Jul '11, 07:35

Seen: 1,193 times

Last updated: 05 Aug '11, 10:39

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