SQL Server Data source for Custom Database Extension MSSQL

[AndrewP]

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

[jegron]

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?