Hi Everyone, Thank you for your suggestions.
I have configured the below exporter to get the data using KQL from log analytics workspaces. https://github.com/webdevops/azure-loganalytics-exporter - This one only queries log analytics workspace not other resources. It works fine as expected. @[email protected] - https://grafana.com/grafana/plugins/grafana-azure-data-explorer-datasource/ - I have used this plugin to query the data from grafana and show the result. It directly queries from azure monitor/log analytics workspace it will have only certain time data based on retention period. Our requirement is to store the data for more than 1 year. Azure monitor kql, metrics will show data only for the last 90 days. So, we need to export the data and store it in prometheus. So, I am trying here for long term storage as prometheus. We have another requirement to fetch server requests for Application insights using Azure monitor. I have tried the below exporters it is showing different values instead of actual server requests in application insights. https://github.com/RobustPerception/azure_metrics_exporter https://github.com/webdevops/azure-metrics-exporter Could you please suggest any other methods to export metrics from an azure monitor with dimension support? Thanks, Venkatraman N On Mon, Aug 5, 2024 at 2:38 AM Conall O'Brien <[email protected]> wrote: > On Thu, 1 Aug 2024 at 10:38, Venkatraman Natarajan <[email protected]> > wrote: > >> Hi Team, >> >> I have application insights which I am able to query using KQL and show >> the result in Azure. >> >> I need to store the queried result in prometheus database. >> >> Then using promQL I need to display it in grafana. >> >> https://github.com/webdevops/azure-metrics-exporter - I have tried this >> one; it shows only metrics not able to query using KQL. >> >> https://github.com/webdevops/azure-loganalytics-exporter - This one only >> queries log analytics workspace not other resources. >> >> https://github.com/RobustPerception/azure_metrics_exporter - This one >> not having dimension support. >> > > Do you intend to use the PromQL data for anything other than Grafana? If > not, issuing the KQL queries directly from Grafana would be simpler than > all this transcoding. > > > Grafana (self hosted) and Grafana Cloud can use a plugin for KQL queries. > See > https://grafana.com/grafana/plugins/grafana-azure-data-explorer-datasource/ > for more details. IIRC, Azure Managed Grafana supports graphs using KQL > without needing the additional plugin. See > https://learn.microsoft.com/en-us/azure/data-explorer/grafana?tabs=azure-managed-grafana > for ore specifics about Azure Managed Grafana. > > -- > > Conall O'Brien > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CANSgTEYZTnUYGBsHo%3DcjSmFxa%2B-C2ZNfWOdZU8Xbm3fBqu8w8w%40mail.gmail.com.
