Splunk Search

Help with props.conf with lookup?

daniel333
Builder

All,

I have a lookup, which I in turn want to do a couple aliases on. But doesn't seem to work. I get clienthost back, but the aliases don't. Any idea what I might be doing wrong here?

  ## Some DNS
  FIELDALIAS-real_ip_as_clientip = real_ip as clientip
  LOOKUP-dns = dnslookup clientip OUTPUT clienthost
  FIELDALIAS-clienthost_as_src_host = clienthost AS src_host
  FIELDALIAS-clienthost_as_src_dns = clienthost AS src_dns
0 Karma
1 Solution

somesoni2
Revered Legend

Have a look at this really nice Splunk documentation which provides sequence of all search time operation.
https://docs.splunk.com/Documentation/Splunk/8.0.2/Knowledge/Searchtimeoperationssequence

The Field Aliasing happes before Lookup, that's the reason you don't see your clienthost aliases.

View solution in original post

0 Karma

somesoni2
Revered Legend

Have a look at this really nice Splunk documentation which provides sequence of all search time operation.
https://docs.splunk.com/Documentation/Splunk/8.0.2/Knowledge/Searchtimeoperationssequence

The Field Aliasing happes before Lookup, that's the reason you don't see your clienthost aliases.

0 Karma

daniel333
Builder

Dang, that's no good. Any work around for this?

0 Karma

somesoni2
Revered Legend

This might work:

LOOKUP-dns = dnslookup clientip OUTPUT clienthost clienthost as src_host clienthost as src_dns

basically lookup is outputting 3 fields (same field with different names)

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...