Splunk Search

DB COnnect Lookup setup

SS1
Path Finder

Hello SPlunkers,

For DB connect lookup

I have reference search with below format,

2020-11-13 01:14:12 * PUT /packages/version/323 - 8080 userX Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/86.0.4240.111+Safari/537.36 * 200 0 0 31

 

I have a set lookup SQL as below,

Id           Name
323    ApacheMaven

 

I want to match the ID in from the reference search with the lookup and send out the results as ID, Name, User. Please let me know if we can achieve that

Labels (7)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Please describe the problem more.  The "search" is not a search, but raw data or, perhaps, a result of a search.  What is the search itself?  Are fields already extracted?

The "SQL as below" is not SQL at all, but what looks like the output of SQL.  What command(s) were used to produce that output?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...