All Apps and Add-ons

How to use DB Connect Lookup

john_glasscock
Path Finder

I have created a DBConnect Lookup for a SQL Database connection. However, I am unable to get it to work correctly in my search. Any help would be appreciated.

DBConnect
Field = Card_Number Column=Account_Number

Output
Columns New Output Field
First_Name customer_first_name

Search string that is not working
index=transactions CARD_NUMBER=* |eval CARD_NUMBER = "APR00" + CARD_NUMBER | lookup db_connect_Credit_Card Account_Number as CARD_NUMBER OUTPUT First_Name as customer_first_name

0 Karma

cmerriman
Super Champion

do you have db connect v1 or v2? if you are on v2, I think it is OUTPUTNEW instead of OUTPUT.

http://docs.splunk.com/Documentation/DBX/2.3.1/DeployDBX/Createandmanagedatabaselookups

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...