topic Re: Dynatrace SaaS - Executing custom-sql-query to get a value from database table and set custom-Alert in Alerting https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110405#M772 <P>Hi,</P><P>These answers apply to your question:</P><P><A rel="noopener noreferrer" href="https://community.dynatrace.com/questions/236438/can-any-one-help-with-custom-plugin-that-fetches-d.html" target="_blank">https://community.dynatrace.com/questions/236438/can-any-one-help-with-custom-plugin-that-fetches-d.html</A></P><P>Mike</P> Mon, 16 Oct 2023 14:29:48 GMT Mike_L 2023-10-16T14:29:48Z Dynatrace SaaS - Executing custom-sql-query to get a value from database table and set custom-Alert https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110404#M771 <P>Like AppMon give options to query a database table (AWS MSSQL RDS) and set the alert based on the value, how can it be done in Dynatrace SaaS?</P> Thu, 19 Mar 2020 12:46:35 GMT https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110404#M771 anil_yadav 2020-03-19T12:46:35Z Re: Dynatrace SaaS - Executing custom-sql-query to get a value from database table and set custom-Alert https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110405#M772 <P>Hi,</P><P>These answers apply to your question:</P><P><A rel="noopener noreferrer" href="https://community.dynatrace.com/questions/236438/can-any-one-help-with-custom-plugin-that-fetches-d.html" target="_blank">https://community.dynatrace.com/questions/236438/can-any-one-help-with-custom-plugin-that-fetches-d.html</A></P><P>Mike</P> Mon, 16 Oct 2023 14:29:48 GMT https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110405#M772 Mike_L 2023-10-16T14:29:48Z Re: Dynatrace SaaS - Executing custom-sql-query to get a value from database table and set custom-Alert https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110406#M773 <P>Could you please elaborate this line (from your given link answer): - </P><OL><LI>device.stat_counter(key='count', value=StatCounterDataPoint( result[0], result[0], result[0], 1)</LI></OL><P>Here, how to declare/initialize/define device? StatCounterDataPoint is a custom method or what? </P><P><BR /></P><P>Thanks in advance,</P> Thu, 09 Apr 2020 06:31:33 GMT https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/110406#M773 anil_yadav 2020-04-09T06:31:33Z Re: Dynatrace SaaS - Executing custom-sql-query to get a value from database table and set custom-Alert https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/185784#M2975 <P>There is now a generic way to do this:</P><P><A href="https://community.dynatrace.com/t5/Dynatrace-tips/Custom-Database-Queries/td-p/185781" target="_blank">https://community.dynatrace.com/t5/Dynatrace-tips/Custom-Database-Queries/td-p/185781</A></P> Sun, 01 May 2022 15:44:11 GMT https://community.dynatrace.com/t5/Alerting/Dynatrace-SaaS-Executing-custom-sql-query-to-get-a-value-from/m-p/185784#M2975 AntonioSousa 2022-05-01T15:44:11Z