Splunk Search

DB connect issue

vin02ptl
Explorer

Hi Team,

I have created connection for oracle DB in db connect app. When i am trying to run the sql query in DB connect i can see the result. But when i am trying to search the same result in search head using index and source , not getting any result.

 

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust
You created a DBX connection. Did you also create an input?
Please share the search you are using on the SH.
---
If this reply helps you, Karma would be appreciated.
0 Karma

vin02ptl
Explorer

inputs ,identities ,connection etc all I have created .It was working some time before but not working now. There is no change in credentials and I could see the result with sql query. I using search "index=*** source=***" in SH to find the data.

0 Karma

richgalloway
SplunkTrust
SplunkTrust
Is the input still running?
What messages are you seeing in splunkd.log or the dbx logs?
---
If this reply helps you, Karma would be appreciated.
0 Karma

vin02ptl
Explorer

dbx logs i can see status=complete

0 Karma

richgalloway
SplunkTrust
SplunkTrust
Does the log say how many rows were returned from the DB? If it's zero then that would explain why your search doesn't find anything.
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...