Splunk Search

Continue on dbxquery Failure

Explorer

I have a search that performs a basic dbxquery connection and SQL search.  If the database table were to be dropped or there were any other errors encountered during the search, I would like the rest of the SPL to keep chugging along.

Is there a creative way to continue past the dbxquery error?

This is a simple example looking up an Oracle DB name:

 

| makeresults
| eval connection_name="<my db connection>"
| map search="| dbxquery connection=$connection_name$ query=\"select * from global_nameWRONG;\""
| eval test="didn't get here"
| table GLOBAL_NAME,test

 

Labels (1)
0 Karma