# Custom Database Queries **URL:** \ **Category:** Dynatrace Tips\ **Tags:** databases, extensions, tips-and-tricks\ **Created:** [May 1, 2022, 3:40pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006 "2022-05-01T15:40:50Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\ **Post date:** [May 1, 2022, 3:40pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006/1 "2022-05-01T15:40:50Z")
Custom Database Queries is a new extension “to bring in business data, job processing metrics, database and table statistics, anything that is stored in your Databases” into Dynatrace! It doesn’t seem to be an Extension 2.0 yet, but the corresponding documentation pages about the SQL Data sources are already out there: > **[SQL data source](https://docs.dynatrace.com/docs/ingest-from/extensions/develop-your-extensions/data-sources/sql)** > > Learn how to create an SQL data source-based extension using the Extensions framework. Although I have not yet tried it out, it looks very promising! ---
**Author:** ![Shirai](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/shirai/32/27711_2.png) [@Shirai](https://community.dynatrace.com/u/Shirai)\ **Post date:** [July 7, 2022, 9:53am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/2 "2022-07-07T09:53:23Z")
I received a question from a customer about this extension. I will try this extension once. ---
**Author:** ![techean](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/techean/32/227_2.png) [@techean](https://community.dynatrace.com/u/techean)\ **Post date:** [July 7, 2022, 11:24am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/3 "2022-07-07T11:24:05Z")
One of our client used for Oracle DB monitoring to ingest custom metric into Dynatrace, works fine ! ---
**Author:** ![charles\_preecs](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/charles_preecs/32/25661_2.png) [@charles\_preecs](https://community.dynatrace.com/u/charles_preecs)\ **Post date:** [July 8, 2022, 2:18pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006/4 "2022-07-08T14:18:06Z")
We started using this extension recently and its been very helpful.  Hope it is moved to v2 soon. ---
**Author:** ![mizso74](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@mizso74](https://community.dynatrace.com/u/mizso74)\ **Post date:** [July 8, 2022, 4:00pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006/5 "2022-07-08T16:00:45Z")
It is a great tool. It opens lot of new opportunities to correlate business and IT performance data in real time. Extension configuration is quite easy. Remoteplugin log is very useful during the configuration on the installed AG. My only probelm is: similar to other AG extensions, in case of issue with the AG there is no data. See attached an example dashbord piece.       ![DB_query_v2.png](https://global.discourse-cdn.com/dynatrace/original/2X/0/0fe8e8044205575c744339332c260cb24fe66aad.png) ---
**Author:** ![echwallah](https://avatars.discourse-cdn.com/v4/letter/e/9e8a1a/32.png) [@echwallah](https://community.dynatrace.com/u/echwallah)\ **Post date:** [July 28, 2022, 12:13am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/6 "2022-07-28T00:13:51Z")
This feature seems very exciting to explore but according to Cluster update 1.246 this has been suspended due to Security concerns. [@AntonioSousa](https://community.dynatrace.com/user/17213) is this correct? Quoting the release notes " #### Infrastructure Monitoring - Due to security concerns, we have blocked custom SQL extensions using the Extensions 2.0 framework. (APM-378722)" ---
**Author:** ![echwallah](https://avatars.discourse-cdn.com/v4/letter/e/9e8a1a/32.png) [@echwallah](https://community.dynatrace.com/u/echwallah)\ **Post date:** [July 28, 2022, 12:16am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/7 "2022-07-28T00:16:34Z")
This feature seems very exciting to explore but according to Cluster update 1.246 this has been suspended due to Security concerns. [@AntonioSousa](https://community.dynatrace.com/user/17213) is this correct? Quoting the release notes " #### Infrastructure Monitoring - Due to security concerns, we have blocked custom SQL extensions using the Extensions 2.0 framework. (APM-378722)" ---
**Author:** ![AntonioSousa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antoniosousa/32/50_2.png) [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\ **Post date:** [July 28, 2022, 8:02am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/8 "2022-07-28T08:02:45Z")
[@echwallah](https://community.dynatrace.com/user/9193), Not quite sure about the Release Notes. I can confirm that my custom queries keep working under 1.246. In any case, the one I’m using is not the extensions v2, so shouldn’t be affected. ---
**Author:** ![Kenny\_Gillette](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/kenny_gillette/32/20170_2.png) [@Kenny\_Gillette](https://community.dynatrace.com/u/Kenny_Gillette)\ **Post date:** [August 2, 2022, 3:22pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006/9 "2022-08-02T15:22:42Z")
We use to check sql blocking and chart it in dynatrace.  Love it ---
**Author:** ![Kenny\_Gillette](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/kenny_gillette/32/20170_2.png) [@Kenny\_Gillette](https://community.dynatrace.com/u/Kenny_Gillette)\ **Post date:** [August 2, 2022, 3:24pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006/10 "2022-08-02T15:24:04Z")
It does not affect this plugin.  We checked with Dynatrace.  Our plugin is still working also. ---
**Author:** ![Sanket\_Molavade](https://avatars.discourse-cdn.com/v4/letter/s/ac8455/32.png) [@Sanket\_Molavade](https://community.dynatrace.com/u/Sanket_Molavade)\ **Post date:** [November 23, 2022, 6:05am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/11 "2022-11-23T06:05:15Z")
Hi all, We have configured the same but not getting proper output metrics. can you help me to configure the same? Actually we want the output of custom query and set alerting on the output of that query. In data explore we are not able to get the db output matrices. We have mentioned the configuration and output below, ![Sanket_Molavade_0-1669180780567.png](https://global.discourse-cdn.com/dynatrace/original/2X/d/decee1c9f150e81daedd972e17eb6d75a06ac633.png) ![Sanket_Molavade_1-1669180825845.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/9/89c9632f1c204bee275560557cb8a5e5a464fa2f.png) OUTPUT: ![Sanket_Molavade_0-1669183403370.png](https://global.discourse-cdn.com/dynatrace/original/3X/3/b/3b28fd24e506f7c34b85511fca64aabf0fc65f31.png) Thank you in advance. ---
**Author:** ![mizso74](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@mizso74](https://community.dynatrace.com/u/mizso74)\ **Post date:** [November 23, 2022, 6:19am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/12 "2022-11-23T06:19:36Z")
Hi [@Sanket\_Molavade](https://community.dynatrace.com/user/53319), Could you please check my post? [Solved: Re: Generic DB Query Plugin - Dynatrace Community](https://community.dynatrace.com/post/197973#M3965) If you need any further support please let me know. Best regards, Mizső ---
**Author:** ![jegron](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jegron/32/12797_2.png) [@jegron](https://community.dynatrace.com/u/jegron)\ **Post date:** [December 19, 2022, 10:33am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/13 "2022-12-19T10:33:52Z")
Right now, still unable to upload SQL Extension 2.0. But for your information, Dynatrace support told me 1.257 release will allow again custom SQL query with extension V2 🙂 ---
**Author:** ![Shivanish](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@Shivanish](https://community.dynatrace.com/u/Shivanish)\ **Post date:** [November 21, 2023, 9:51am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/14 "2023-11-21T09:51:24Z")
Hello Sanket, May i know how you achieve this ? I’m dealing with same case so need suggestions. ---
**Author:** ![Shivanish](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@Shivanish](https://community.dynatrace.com/u/Shivanish)\ **Post date:** [November 21, 2023, 9:59am UTC](https://community.dynatrace.com/t/custom-database-queries/35006/15 "2023-11-21T09:59:25Z")
Hello Mizso, How we can set the alert/threshold on  output of custom query ?? ---
**Author:** ![mizso74](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@mizso74](https://community.dynatrace.com/u/mizso74)\ **Post date:** [November 21, 2023, 10:41pm UTC](https://community.dynatrace.com/t/custom-database-queries/35006/16 "2023-11-21T22:41:32Z")
Hi [@Shivanish](https://community.dynatrace.com/user/69071), Custom query create a metric: custom.db.query. You can use it to create a metric event. In data explorer you can create a metric expression by splitting and filtering your custom db query metric by its dimenasions. Here is an example: ![Mizs_2-1700606242831.png](https://global.discourse-cdn.com/dynatrace/original/2X/4/4f14b6360c0d010c7c334739aa043e5f6b02bd15.png) Create metric expression by advance mode you can copy it to the metric event creation: ![Mizs_3-1700606321814.png](https://global.discourse-cdn.com/dynatrace/original/2X/b/b450caadae62c757a060e054ebab1345cbb2490c.png) Create a metric event by the metric expression: ![Mizs_4-1700606395523.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/0/e030c07033ff7179b44616cdf4f22a43bcd50749.png) Then you need an any alareing profile and a problem notification integration eg, for e-mail alerting. I hope it helps. Best regards, Mizső