Hi,
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
metricsets:
- database_account
enabled: true
period: 300s
client_id: "${CLIENT_ID}"
client_secret: "${CLIENT_SECRET}"
tenant_id: "${TENENT_ID}"
subscription_id: "${SUBSCRIPTION_ID}"
resources:
- resource_query: "resourceType eq 'Microsoft.Sql/servers/databases'"
metrics:
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