All Apps and Add-ons

Missing events using dbxlookup

LH_SPLUNK
Explorer

Hi,
I'm using a dbxlookup.
While searching WITHOUT the lookup I get all events.
With the dbxlookup there are some events are missing, thus the dbxlookup isn't used in the first step.

All results:
index=main
| fields *
| search source=A
| search ANum=Number
| stats count

Missing results while using BDXLOOKUP
index=main
| fields *
| dbxlookup lookup=Lookup1
| search source=A
| search ANum=Number
| stats count

Thanks.
LH

0 Karma

nikita_p
Contributor

Hi,
There are two ways to use dbxlookup command.

dbxlookup chunksize= lookup=
The argument refers to the lookup you defined in DB Connect UI.
From DB Connect 3.1.0, dbxlookup command allows users to declare Splunk fields/table column mapping directly in the options. The syntax is similar as lookup. Users do not have to create a lookup in UI before using it in dbxlookup command.

dbxlookup connection= query= chunksize= AS OUTPUT AS

Also go through the link below of splunk documentation
https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/Createandmanagedatabaselookups

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What events are missing?

---
If this reply helps you, Karma would be appreciated.
0 Karma

LH_SPLUNK
Explorer

Splunk cannot find events during the whole timespan.
-->Searching 7 days --> getting the results for 1 day

Searching day by day I get every event but the whole span --> missing events

I get an error sign under the search but no explanation. In the search.log the error is next to ChunkedExternProcessor

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What is the full text of the ChunkedExternProcessor error message?

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

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...