Can we run SQL queries from Dynatrace Managed cluster or security gateway to a DB server?

[hmor3]

Hi,

we need to run SQL queries in DB for various Health checks .

Is it possible to send a SQL query to DB every 5/10/15 min remotely from Cluster or gateway or locally from ONeagent? Is there any plugin available for the same?

Thanks

Himanshu Mor

[pahofmann]

You could write a OneAgent Plugin.

[johan_meyer]

Hi @Himanshu M.

I was just wondering if you ever managed to get any joy with this?

[Enrico_F]

Unfortunately this is not possible without writing your own plugin 😞

https://answers.dynatrace.com/answers/223657/view.html

[erh_inetum]

so writting a plugin is the only solution, right?

Thanks.

Elena.

[Mike_L · Accepted solution]

Either write an extension or use another tool to do the query and send the result to Dynatrace using one of the APIs.