diff --git a/telegraf/meta/prometheus.yml b/telegraf/meta/prometheus.yml
index e5f57a2..4e77e67 100644
--- a/telegraf/meta/prometheus.yml
+++ b/telegraf/meta/prometheus.yml
@@ -72,6 +72,12 @@
     total:instance_id:instance_arping_success:avg10m:for10m:eq0:
       query: >-
         count(instance_id:instance_arping_success:avg10m:for10m == 0)
+    total:openstack_nova_instance_failed:
+      query: >-
+        count(instance_id:instance_arping_success:avg10m:for10m == 0 or on(id) openstack_nova_instance_status == 2)
+    total:openstack_nova_instance_all:
+      query: >-
+        count(instance_id:instance_arping_success:avg10m:for10m or on(id) openstack_nova_instance_status)
   {%- endif %}
 {%- endif %}
 {%- if pillar.opencontrail is defined %}
@@ -89,6 +95,12 @@
     total:instance_id:instance_ping_success:avg10m:for10m:eq0:
       query: >-
         count(instance_id:instance_ping_success:avg10m:for10m == 0)
+    total:openstack_nova_instance_failed:
+      query: >-
+        count(instance_id:instance_ping_success:avg10m:for10m == 0 or on(id) openstack_nova_instance_status == 2)
+    total:openstack_nova_instance_all:
+      query: >-
+        count(instance_id:instance_ping_success:avg10m:for10m or on(id) openstack_nova_instance_status)
   {%- endif %}
 {%- endif %}
 {%- if address is defined %}