GCE Compute Engine Monitoring Plugin | Deprecate MQL from Google

I need suggestions/advises how to go further on this?

  • What Grafana version and what operating system are you using?
    Latest Version 9.x and RHEL9.x

  • What are you trying to achieve?
    To create a dashboard by using available plugin GCE VM instance Monitoring for getting all VMs count
    which are all under 2 orgs in their sub projects

  • How are you trying to achieve it?
    Unfortunately i didn’t able to acheive this using
    MQL and i came to know that MQL is deprecated from google.

  • What happened?
    Not able to get the aggregated total number of VMs count

  • What did you expect to happen?
    To list all the VMs count from our orgs and it relevant projects

  • Can you copy/paste the configuration(s) that you are having problems with?
    fetch gce_instance
    | metric ‘compute.googleapis.com/instance/uptime
    | group_by [metadata.state], count(val())

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    N/A

  • Did you follow any online instructions? If so, what is the URL?
    Nope