Splunk DB Connect 2: How to run same the same SQL query on multiple databases?

[internet_team]

Hello,

I would like to run the same SQL query on many databases. First way I tried was to clone db inputs, but this is not efficient in case the SQL query changes (need to update each input).

Is there any easy way to run 1 SQL query on multiple databases?
Is it possible to set mySQL query on 1 text file, and specify this text file on query stanza ?

[jtrimmings]

How about

| dbxquery connection=databasecon1 query="select @@servername"

| union
[ dbxquery connection=databasecon2 query="select @@servername"]
| union
[dbxquery connection=yetanotherdb query="select@@servername"]

[kyaparla]

I have similar requirement, so I tried some like this and it worked for my requirement.

|rest /servicesNS/-/-/configs/conf-db_connections | stats count by title,host | search title="*" | map search="|dbxquery query=\" url encoded sql query\" connection=$title$ maxrows=100 | eval connection=\"$title$\" | eval dbhost=\"$host$\""

[jcoates_splunk]

Good question -- there isn't a way to do that (at least not one I can think of). Can you please open a support case so we can get an enhancement request and investigate further?

[internet_team]

Hello, i did it. Hope it help ...