SQL Server Data source for Custom Database Extension MSSQL

AndrewP — Mon, 02 Sep 2024 20:56:38 GMT

Hello, I am working on the migration to 2.0, I am able to fetch the metrics, but not able to fetch dimensions, example of the query:

SELECT

count(*) as cntService,

service_name

FROM *******

WHERE

AGENT_STATUS = 'RUNNING'

GROUP BY

SRVICE_NAME

metrics:

- key: *****.running.service.cnt

value: col:cntService

dimensions:

- key: ****.running.service.name

value: col:service_name

And I can see a metrics, but not able to see dimensions in Dynatrace, Do you have any idea what I am doing wrong? The same query is giving proper values in the SQL server.

Thanks

Re: SQL Server Data source for Custom Database Extension MSSQL

jegron — Tue, 03 Sep 2024 07:34:14 GMT

Hi @AndrewP !

Are you migrating EF1 Custom Database Extension ? If yes, you can use the migrator with this app :

https://www.dynatrace.com/hub/detail/custom-extensions-creator/
Migrate a Custom DB Query extension from v1 to v2 with a single click

But your YAML seems good. Did you check the extension logs to see if there is a non accepted value in service_name?

topic SQL Server Data source for Custom Database Extension MSSQL in Extensions

SQL Server Data source for Custom Database Extension MSSQL

Re: SQL Server Data source for Custom Database Extension MSSQL