Splunk Search
Highlighted

DB connect issue

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
Highlighted

Re: DB connect issue

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, an upvote would be appreciated.
0 Karma
Highlighted

Re: DB connect issue

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
Highlighted

Re: DB connect issue

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

Re: DB connect issue

Explorer

dbx logs i can see status=complete

0 Karma
Highlighted

Re: DB connect issue

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, an upvote would be appreciated.
0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.