i have created a data lab input. the query is configured to fetch the data in batch manner which runs every 30 mins. when i run the Query with DBXQUERY i am able to see the output/events also in the 1st stage of data lab input creation i could see the records. but when the input was configured i tried to search for the events , i could not find any events. i tried with all the pre-defined indexes as well as with the customized index (updated the required files in splunk ), still i am unable to fetch the data. we are required to achieve this because most of the dashboards are dependent on DB and we can not build each dashboard with DBXQUERY. kindly help me to resolve this. thanks in Advance ... View more

we are building various dashboards for monitoring purpose. Most of the dashboards need the data from database, which we are fetching by connection to database using DBXQuery. initially the panels on the dashboard were populating Quickly but later on due to increased DB connection everything got slower. Now we are trying to reduce the connections to Database as the Queries are affecting performance of other procedures in database. i wanted to know that is there any way to reduce connection either by storing the sql o/p(which gives different result on each run) or by using the dump files of the table? i really need to reduce the sql connections from Splunk ... View more