Metricbeat Azure Module - unable to get metrices of MSSQL Database Account


We are trying to implement metricbeat for our Azure resources where we are using Azure Module provided by metricbeat itself. Here we are facing a challenge that we are not able to capture MSSQL database metrices from our azure subscription. But we are able to see VM's, scalesets, Account related info, Billing and storage accounts. It is not working for database accounts.

The service principal that we are using has full read permission at the subscription level, so it should be able to read all the resources that are under that subscription.

Here is the yml configuration that we are using,

- module: azure
  - database_account
  enabled: true
  period: 300s
  client_id: "${CLIENT_ID}"
  client_secret: "${CLIENT_SECRET}"
  tenant_id: "${TENENT_ID}"
  subscription_id: "${SUBSCRIPTION_ID}"
    - resource_query: "resourceType eq 'Microsoft.Sql/servers/databases'"
        namespace: "Microsoft.Sql/servers/databases"

And the error we are getting while running metricbeat is,

metricbeat-8.4.1-windows-x86_64>metricbeat.exe -c metricbeat.yml
Exiting: 1 error: error initializing the monitor client: module azure - database_account metricset. No queries allowed, please select one of the allowed options

Can someone please help me fix this? I have tried different combinations as well but not able to read the metrices. The example given in the Azure Module documentation is for DocumentDb and there is no example given for MSSQL database

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.