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 ?
How about
| dbxquery connection=databasecon1 query="select @@servername"
| union
[ dbxquery connection=databasecon2 query="select @@servername"]
| union
[dbxquery connection=yetanotherdb query="select@@servername"]
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$\""
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?
Hello, i did it. Hope it help ...