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