i have multiple dabatases (>100) with the identic structure. For business-monitoring, i have about 80 queries which check information in the database. Now, i want to execute each of this queries on each of this databases and load the result into splunk. In splunk, is it possible to define the >100 database-connections once and the 80 queries once and then make some "magic" step to execute each statement on each database? I don't want to create a new connection for each combination of database and query.
Splunk: Execute the same query on multiple datasources
453 Views Asked by Thomas At
1
There are 1 best solutions below
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in SPLUNK
- Splunk metadata information
- Linux command outputs in splunk
- With a regular expression, match letters and numbers but not whitespaces
- break multiline events using LINE_BREAKER
- Running Python Splunk SDK Test Suite
- Incorrect Extraction of fields in Splunk
- ios crash in splunk mint
- How to search a given time range for every day in Splunk?
- Protocol(SSLV3) unsupported issue while retrieving data from Splunk
- How can you filter out direct calls to your API coming from mobile apps rather than web browsers when viewing/parsing IIS logs
- Negative regex in splunk (not using fields)
- How to get negative lookahead in regex to accept more words
- Splunk: column order of csv
- Charting multivariables in Splunk
- How to add condition in splunk data model constraint
Related Questions in SPLUNK-QUERY
- How do I create a Splunk query for unused event types?
- Splunk command to check if current search is greater than x% of previous search
- How to Build Splunk Search Query for below Scenario
- Finding brute force attacks with splunk
- i have 3 columns , total count , pass count , and fail count , how do i write formula in SQL or SPL if fail count is > 8% its development error
- Use sub-second precision on "earliest" in Splunk query
- How to write Splunk query to get first and last request time for each sources along with each source counts in a table output
- How to do compound query with where clause in Splunk?
- SPLUNK enterprise i am trying to calculate results where if > 4% of failure is anomaly?
- Searching for a particular kind of field in Splunk
- Splunk conditional distinct count
- Read Squid access.log with Splunk
- Splunk showing wrong index time
- How to extract alpha-numeric fields in a Splunk query and list them in table form
- Splunk query to extract fields from log data
Related Questions in DBCONNECT
- How can a java application running within a Fargate container connect to Aurora Postgresql db?
- error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': could not find function "MySQL"
- How to ingest db logs into splunk? I need only logs to be Warning , Error , Critical , ORA-* logs. any sample prop changes would be appreciated
- dbConnect works in Rstudio.exe and RGui.exe but fails as an executable in RScript.exe
- I have 2 main dbs and i want to create one as a connection of those two
- connecting to clickhouse in R
- How can I install the dbconnect module in Python?
- Call a C# function from MySQL
- Warning: <BigQueryConnection> uses an old dbplyr interface
- How do I get R to find dbConnect function?
- R teradata DBI:dbConnect() error: TimedOut: No response received when attempting to connect to the Teradata server
- R: NULL value passed as symbol address, error in .Call(RS_PostgreSQL_init, config.params, force) :
- DB Connect and workspace notebooks returns different results
- Can't connect to SQLlite database
- Batch executing query in RPostgres returning same data
Related Questions in SPLUNK-HEC
- AWS Cloudwatch logs ingestion to splunk using hec
- Splunk query to retrieve value from json log event and get it in a table
- Issue in sending python logs to Splunk using splunk_hec_handler
- Splunk HEC sourcetype override mapping all events to a single transform
- Splunk Cloud HEC endpoint address do not resolve
- No fluent-plugin-splunk-hec plugin found while using splunk/fluentd-hec Docker image
- Openshift and Splunk HEC integration for logging
- How to batch the app events with max of 1000 events per second when using Splunk HTTP Event Collector (HEC)
- Splunk: Execute the same query on multiple datasources
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The only way Splunk has to connect to a database "itself" is via DB Connect (docs)
From Splunk's perspective, there is no way to connect to 100 databases without having unique connections to each.
So far as I know, there is no tool that will connect to more than one database without unique connections - that's something database servers enforce in transactional models.
That being said, if you have a way to enumerate all the databases you want to connect to, and a place to save the queries you want to run, you could build either a