Splunk Search

db connect doesn't see table

a212830
Champion

Hi,

I have a database input issue. I setup the database connection, and run a tail command, but it keeps telling me that the table or view doesn't exist. It does exist, and I do have permissions to see it. I can see it when I query it via the DB Connect -> DB Info, and when I look at it via Oracle SQL Developer.

Any suggestions?

Tags (1)
0 Karma

Jason
Motivator

If you can query the table/view using the DB Connect -> DB Query dashboard in Splunk, try setting up the database tail by selecting the "enter SQL" in the manager screen for the tail.

0 Karma

a212830
Champion

Tried it - still fails with view/table not found. The same query will work from db connect - db query.

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...