# can any one help with custom plugin that fetches database statistics using a SQL-query?

**URL:** <https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759>\
**Category:** Open Q&A\
**Tags:** dynatrace-saas, postgresql\
**Created:** [March 13, 2020, 12:22pm UTC](https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759 "2020-03-13T12:22:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cochagwu](https://avatars.discourse-cdn.com/v4/letter/c/df788c/32.png) [@cochagwu](https://community.dynatrace.com/u/cochagwu)\
**Post date:** [March 13, 2020, 12:22pm UTC](https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759/1 "2020-03-13T12:22:45Z")

</div>

[@Mattias W.](https://answers.dynatrace.com/users/28178/view.html) [@Mattias W.](https://answers.dynatrace.com/users/35573/view.html) can you help with the Above please?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Mike\_L](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mike_l/32/11717_2.png) [@Mike\_L](https://community.dynatrace.com/u/Mike_L)\
**Post date:** [March 13, 2020, 12:28pm UTC](https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759/2 "2020-03-13T12:28:37Z")

</div>

Hi,

If you have a OneAgent installed on the box I recommend you to follow these instructions to create a OneAgent plugin:

[https://dynatrace.github.io/plugin-sdk/readme.html](https://dynatrace.github.io/plugin-sdk/readme.html)

For ActiveGate plugins we have a help page, but it is quite similar to the OneAgent plugin, except for where it is executed from:

> **[Develop your own Extensions](https://docs.dynatrace.com/docs/ingest-from/extensions/develop-your-extensions)**
>
> Develop your own Extensions in Dynatrace.

If you do not have the time to dive into the above material to create it yourself, you can also reach out to your delivery or account manager and they can reach out to our services team for helping out.

Mike

---

<div class="post-metadata">

**Author:** ![cochagwu](https://avatars.discourse-cdn.com/v4/letter/c/df788c/32.png) [@cochagwu](https://community.dynatrace.com/u/cochagwu)\
**Post date:** [March 13, 2020, 12:39pm UTC](https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759/3 "2020-03-13T12:39:08Z")

</div>

Thank [@Michael L.](https://answers.dynatrace.com/users/4119/view.html) i will review and revert

---

<div class="post-metadata">

**Author:** ![Radoslaw\_Szulgo](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/radoslaw_szulgo/32/1977_2.png) [@Radoslaw\_Szulgo](https://community.dynatrace.com/u/Radoslaw_Szulgo)\
**Post date:** [March 13, 2020, 1:00pm UTC](https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759/4 "2020-03-13T13:00:20Z")

</div>

Take a look at my example:

```auto
def collectStatsFromDB(self, device):
        try:
            connection = mysql.connector.connect(host=self.databaseUrl,
                                                database=self.dbName,
                                                user=self.dbUsername,
                                                password=self.dbPasswd)
            sql_select_Query = """
                select metric from my_table
            """
            cursor = connection.cursor()
            cursor.execute(sql_select_Query)
            record = cursor.fetchone()

            if cursor.rowcount > 0:
                result = [record[0]]
            else:
                result = [0]

            # report stat counter
            device.stat_counter(key='count', value=StatCounterDataPoint(
                result[0], result[0], result[0], 1)
            )
        except Error as e:
            logger.exception(e)
        finally:
            if (connection.is_connected()):
                connection.close()
                cursor.close()
                print("MySQL connection is closed")

```

---

<div class="post-metadata">

**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:43pm UTC](https://community.dynatrace.com/t/can-any-one-help-with-custom-plugin-that-fetches-database-statistics-using-a-sql-query/18759/5 "2022-05-01T15:43:55Z")

</div>

There is now a generic way to do this:

[https://community.dynatrace.com/t5/Dynatrace-tips/Custom-Database-Queries/td-p/185781](https://community.dynatrace.com/topic/185781)
