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

[paimonsoror]

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" ]

[tiagofbmm · Accepted solution]

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]

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

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

[paimonsoror]

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