Hi, I'm trying to get the DB tables as input into Splunk by using Add DB Inputs in Splunk Manager, I'm able to index the Data from my table into Splunk when i don't mention the query(the Splunk creates its own query) But when i mention the query such as this SELECT * FROM TABLE_NAME {{WHERE ROWNUM <= 30}} I'm unable to index the data into Splunk. This is very important for me as my tables are very large in size so i can't index them completely i need a Where Condition for this Any Help is Appreciated, Thanks. ... View more

Hi, I have installed Splunk Db-connect & connected to my Oracle DB when i do a select statement I'm getting numbers(not in standard format example # # # # # # # # # #.# # #) instead of the Date that is stored in DB In my DB the Date is stored as 01-APR-14. Any Help is Appreciated, Thanks. ... View more

Hi, I'm struggling with dbquery syntax, please anyone tell the correct syntax. I have configured my oracle DB with Splunk DBX, I'm able to view tables of my DB but I'm unable to query them. Any Help is Appreciated, Thanks. ... View more

Hi, I'm getting this error command="dbquery", A database error occurred: ORA-00900: invalid SQL statement I have connected my oracle DB to Splunk Using "DB Connections in Splunk Manager" My Java Bridge Server is Running Under "Explore DB Schema",I'm able to view the table Names & their attributes under "DB Info". But when i Use the Select Statement under "DB Query" I'm getting the above error. the query that i used is | dbquery "DB___NAME" "SELECT * FROM TABLE-NAME" LIMIT=100 I haven't yet configured the ADD DB Inputs(DB Inputs in SplunkManager) Any Help is Appreciated Thanks. ... View more