All Apps and Add-ons

Is there a way to loop connections in DBConnect? Trying to perform a statement across several connections.

paimonsoror
Builder

Hi all;

We are trying to do some database monitoring which requires us to perform a few select statements across multiple different connections. Instead of creating about 100 saved searches that run periodically, I was hoping that I could simply leverage a for-loop that would use an inputlookup to loop a list of connection names.

Unfortunately I run into the streaming-vs-nonstreaming issue which puts me at a roadblock. Any chance that someone can assist with a possible workaround / alternative to what I am trying to accomplish?

| inputlookup dbconnection.csv
| foreach connection_name [ | dbxquery connection=<<FIELD>> query="select INSTANCE_NAME,STATUS,DATABASE_STATUS from v$instance" ]
0 Karma
1 Solution

tiagofbmm
Influencer

Hey

I believe what you are looking for is the map function.

With that you can use the exact same dbxquery to differebt connections easily.

Check the map command here https://docs.splunk.com/Documentation/Splunk/7.0.3/SearchReference/Map

View solution in original post

tiagofbmm
Influencer

Hey

I believe what you are looking for is the map function.

With that you can use the exact same dbxquery to differebt connections easily.

Check the map command here https://docs.splunk.com/Documentation/Splunk/7.0.3/SearchReference/Map

paimonsoror
Builder

Thanks so much for this, sent you the reward points 🙂

... oops ... i think i actually sent you double the points lol .... oh well.

0 Karma

paimonsoror
Builder

omg, so simple. I'm testing this now and will report back / reward!

0 Karma
Get Updates on the Splunk Community!

Splunk Education - Fast Start Program!

Welcome to Splunk Education! Splunk training programs are designed to enable you to get started quickly and ...

Five Subtly Different Ways of Adding Manual Instrumentation in Java

You can find the code of this example on GitHub here. Please feel free to star the repository to keep in ...

New Splunk APM Enhancements Help Troubleshoot Your MySQL and NoSQL Databases Faster

Splunk Observability has two new enhancements to make it quicker and easier to troubleshoot slow or frequently ...