topic Re: How to combine information from 2 different sources like sourcetype=eea:loghandler and lookup file in Splunk Search

How to combine information from 2 different sources like sourcetype=eea:loghandler and lookup file

silviuchiric76 — Wed, 30 Sep 2020 03:51:08 GMT

Dear all

I have 2 data sources: logs forwared to the server as :
sourcetype=eea:loghandler
and lookup definition file as users_with_email

file
called users_with_email.csv

I have a key field in both sources the same:
in sourcetype=eea:loghandler is called user with values like firstname.lastname@domain.com
and in lookup definition file I have email field, same value firstname.lastname@domain.com
and this is the case for all users

I need to get an aggregated reports of users from

sourcetype=eea:loghandler by joining the department field from lookup definition file users_with_email(users_with_email.csv)

When I try to make an OR:
sourcetype=eea:loghandler OR inputlookup users_with_email
got no results

Re: How to combine information from 2 different sources like sourcetype=eea:loghandler and lookup file

silviuchiric76 — Wed, 30 Sep 2020 03:51:14 GMT

I am interested for an inner join after email.users_with_email = eea:loghandler.user

Re: How to combine information from 2 different sources like sourcetype=eea:loghandler and lookup file

gcusello — Thu, 30 Jan 2020 14:34:14 GMT

Hi @silviuchiric76,
you should try something like this:

sourcetype=eea:loghandler
| lookup users_with_email.csv email AS user OUTPUT department
| dedup user
| sort user
| table user department

A little hint: use always index in your searches to have faster results!

Ciao.
Giuseppe