All Apps and Add-ons

Unable to see data in DB connect

rakesh44
Communicator

Below is the date mentioned in DB query Input , but am getting only few months data

Am getting only Jun-17, Jul-17, May-17, Apr-17,Mar-17,Feb-17,Jan-17 rest month data is missing

DB Query:
To_char(fdml.as_of_date, 'Mon-YY') IN ('Jan-17, 'Feb-17', 'Mar-17', 'Apr-17', 'May-17', 'Jun-17', 'Jul-17', 'Aug-17', 'Sep-17', 'Oct-17', 'Nov-17', 'Dec-17', 'Jan-18', 'Feb-18', 'Mar-18', "Apr-18', 'May-18', 'Jun-18', 'Jul-18', 'Aug-18', 'Sep-18', 'Oct-18', 'Nov-18')

0 Karma
1 Solution

rakesh44
Communicator

This is caused because of fetch size default is 300 , when i increase it issue is resolved

View solution in original post

0 Karma

rakesh44
Communicator

This is caused because of fetch size default is 300 , when i increase it issue is resolved

0 Karma

inventsekar
Super Champion

Are you running it as a regular user or splunk admin?

<<< Am getting only Jun-17, Jul-17, May-17, Apr-17,Mar-17,Feb-17,Jan-17 >>>
how many results you get? is there any limits.conf issue?

PS ... If any post helped you in any way, pls give a hi-five to the author with an upvote. if your issue got resolved, please accept the reply as solution.. thanks.
0 Karma

rakesh44
Communicator

Appreciate for both reply , able to find out issue. I re-run the query with specific date & time & removed * from execution frequency and hence fetch the data with month wise , after that i disabled the query.
Good Learning.Thanks

0 Karma

kmaron
Motivator

does the data exist if you run the query outside of DB connect?

0 Karma
Get Updates on the Splunk Community!

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...

Announcing General Availability of Splunk Incident Intelligence!

Digital transformation is real! Across industries, companies big and small are going through rapid digital ...