SQL Query - Elastic Cloud

Elastic Search
1

Hi,

We are monitoring SQL queries using another tool, and we want to analyze is it's possible to do it using Elastic. We have Elastic Cloud and this is one of our queries:

SELECT Count(*)
FROM BD1.BD2
INNER JOIN BD1.BD2 ON BD2.ACC_NUM_ID=BD2.ACC_NUM_ID
WHERE BD2.VINQ_PROV='23'
AND BD2.ACC_NUM_ID>='125470565'
AND BD2.ACCR_NUM_ID NOT IN ('67','6','82')

I'm reading that metricbeat has an SQL Module that can do SQL queries, but I don't know if it can do this type of queries. And if it's possible, how to do it from Elastic Cloud.

Anyone knows?

Thanks

2

Metricbeat cannot run SQL - MSSQL module | Metricbeat Reference [8.1] | Elastic. I'm not sure if there's a Beat that can.