Differences

This shows you the differences between two versions of the page.

--- resolution_area:prometheus_resolutions:res-p9127 [2023/03/28 11:27] – 10.91.110.100
+++ resolution_area:prometheus_resolutions:res-p9127 [2023/04/27 09:59] (current) – 10.91.110.100
@@ Line 12: / Line 12: @@
 **Manual Action Steps:**
-N/A
+This query will find the element(s) in question:
+<code>  SELECT id,date_added,name,ip_address,port,technology,tier_id FROM network_element ne
+        WHERE (ne.tier_id IS NULL
+        OR ne.tier_id = '')
+        AND ne.on_air
+        AND ne.show_in_monitor
+        AND ne_type != 'CUSTOMER-NETWORK'
+        AND technology NOT IN ('NON_DAS', 'n/a')
+        AND ne.date_added > '2023-03-28 00:00:00';
+        </code>
+You can see what different billing tiers exist on the environment with this query
+<code>
+select * from billing_tiers
+</code>
+Then you need to run an update query and insert the relevant Tier id in the "tier_id" field of the network element.
 **Auto Clear:** Will clear when network elements affected are assigned a billing tier.

Internal Errigal Collaboration Wiki